Accessing Sql server and reading data from it in c#

Hi ejaz,

Actually the code below is relative to Grid View Web Forms.
----------------------------------------------------------
gdView.DataSource = dt;
gdView.DataBind();
----------------------------------------------------------

If you're using a Win Form then just remove the second line of code.  ("gdView.DataBind();").


Happy Coding :)

Thanks.

Hi again,

Please find below the procedure to access SQL Server database and bind it to a GridView:

----------------------------------------------------------
protected void btnFillGridView_Click(object sender, EventArgs e)
{
string ConnectionString="Server=LOCALHOST;Database=myDB;Integrated Security=True;";
DataTable dt = new DataTable();
SqlConnection con = new SqlConnection(ConnectionString);
SqlDataAdapter da = new SqlDataAdapter("select * from tablename", con);
try
 {
 con.Open();
 }
 catch (Exception ex)
 {
 // Database connection error
 }

if (con.State == ConnectionState.Open)
 {
 da.Fill(dt);
 }
if (con.State == ConnectionState.Open)
 {
  try
  {
   con.Close();
  }
  catch { }
 }

//Bind the DataSource
if (dt.Rows.Count > 0) //check if dt is not empty
 {
  gdView.DataSource = dt;
  gdView.DataBind();
 }
}
---------------------------------------------------

Please don't forget to accept this as answer if it helps :)
Thanks.