Gridview does not bind to database
<p>I have this code in the page load...For some reason the dropdown binds to the db, but the gridview that I want to bind is not displayed. What could be the reason for this? Thanks!</p>

<p>C#:</p>

<pre><code>    SqlConnection conn = new SqlConnection(GetConnectionString());
    conn.Open();

    SqlCommand cmd = new SqlCommand("SELECT CompanyName, CompanyID FROM Company ORDER BY CompanyName", new SqlConnection(GetConnectionString()));
    SqlCommand cmd2 = new SqlCommand("SELECT p.ProjectName AS ProjectName, p.Status FROM Project p, Company c WHERE c.CompanyID = p.CompanyID AND c.CompanyID = 3", new SqlConnection(GetConnectionString()));

    cmd.CommandType = CommandType.Text;

    SqlDataAdapter da = new SqlDataAdapter(cmd);

    DataSet ds = new DataSet();

    da.Fill(ds);

    conn.Close();

    company_list.DataSource = ds;
    company_list.DataTextField = "CompanyName";
    company_list.DataValueField = "CompanyID";
    company_list.DataBind();

    company_list.Items.Insert(0, "-- Please Select Company --");

    cmd2.Connection.Open();

    SqlDataAdapter sqlAdapter = new SqlDataAdapter(cmd2);
    DataSet ds2 = new DataSet();
    sqlAdapter.Fill(ds2);

    Gridview1.DataSource = ds2;
    Gridview1.DataBind();

    cmd2.Connection.Close();
    cmd2.Connection.Dispose();
</code></pre>

<p>ASP.net:</p>

<pre><code>&lt;asp:gridview ID="Gridview1" runat="server" ShowFooter="True"
                       AutoGenerateColumns="False" GridLines="None"&gt;

                    &lt;Columns&gt;
                    &lt;asp:TemplateField HeaderText="Project Name"&gt;
                    &lt;ItemTemplate&gt;
                        &lt;asp:TextBox Text='&lt;%#DataBinder.Eval(Container.DataItem, "ProjectName") %&gt;' CssClass="input input1" ID="project_name" width="150" runat="server" ReadOnly="True"&gt;&lt;/asp:TextBox&gt;
                    &lt;/ItemTemplate&gt;
                    &lt;/asp:TemplateField&gt;

                    &lt;asp:TemplateField HeaderText="Status"&gt;
                    &lt;ItemTemplate&gt;
                        &lt;asp:TextBox Text='&lt;%#DataBinder.Eval(Container.DataItem, "Status") %&gt;' CssClass="input input1" ID="status" width="150" runat="server" ReadOnly="True"&gt;&lt;/asp:TextBox&gt;
                    &lt;/ItemTemplate&gt;
                    &lt;/asp:TemplateField&gt;


        &lt;/Columns&gt;

    &lt;/asp:gridview&gt;
</code></pre>
