how to show a data from sql server in gridview

Hi Rahul,
Small correction on your code snippet

SqlCommand cmd=new SqlCommand("select * from table_Name", con);
SqlDataAdapter da=new SqlDataAdapter(cmd,con);//Wrong
// here no need to give connection
SqlDataAdapter da=new SqlDataAdapter(cmd);// correct
// bcz you already mention the connection in cmd(object of Sql Command).

String strConnection="";// connection string here
SqlDataAdapter da=new SqlDataAdapter(select * from table_Name", con);
Dataset ds=new Dataset ();
da.fill(ds);
Gridview1.DataSource=ds;
Gridview1.DataBind();
con.Close();

we can show the data from database using Gridview.

String strConnection="";// connection string here
SqlConnection con=new SqlConnection(strConnection);
SqlCommand cmd=new SqlCommand("select * from EmpTable", con);
SqlDataAdapter da=new SqlDataAdapter(cmd);
Dataset ds=new Dataset ();
con.Open();
da.fill(ds);
Gridview1.DataSource=ds;
Gridview1.DataBound;
con.Close();