title: Datagridview not showing up in webpage
body: <p>I'm using MS Visual Studio 2010 (ASP.NET - C#) and MS SQL Server 2005, and I'm trying to retrieve all the records in my table <code>tblEmployee</code> from my database <code>EMPLOYEES</code>. There's no error when I debug my program in Visual Studio but when the localhost webpage opens, the datagridview <code>dgvEmployee</code> is not there. There are no retrieved records as well. Here's my code:</p>
  
  <pre><code>SqlConnection sConn;
  SqlDataAdapter daEmp;
  DataSet dsEmp;
  
  const string sStr = "Server = Server-PC\\SQLEXPRESS; Database = EMPLOYEES; Integrated Security = SSPI";
  
  protected void Page_Load(object sender, EventArgs e)
  {
      sConn = new SqlConnection(sStr);
      daEmp = new SqlDataAdapter("SELECT * FROM tblEmployee", sConn);
      dsEmp = new DataSet();
  
      daEmp.Fill(dsEmp, "tblEmployee");
  
      dsEmp.Tables["tblEmployee"].PrimaryKey = new DataColumn[] { dsEmp.Tables["tblEmployee"].Columns["EmployeeID"] };
  
      dgvEmployee.DataSource = dsEmp.Tables["tblEmployee"];
  }
  </code></pre>
  
  <p>This is the code in my Defaultpage.aspx:</p>
  
  <pre><code>&lt;asp:GridView ID="dgvEmployee" runat="server"&gt;
  &lt;/asp:GridView&gt;
  </code></pre>
  
  <p>The database and table name is correct, the table have records, and I'm running both programs as Admin. I just can't figure out what's wrong... Is this regarding with the permissions?</p>