tabledata in sqlserver must be displayed in gridview of asp page when pressed displayed button

Question

hi friends

i am a fresher now my problem is i have created a table with some columns in sqldatabase, now i want to display that tabledata in my asp page of gridview when pressed displaybutton .i would be very thankfull if you help me this in stepwise and how to add web.config file in asp page

Krishna Garad · Answer

in click event of buton write this code private void button1_Click { SqlConnection cn=new SqlConnection(Your Connection String Here); string sql=Select * from TableName; SqlDataAdapter ds=new SqlDataAdapter(sqlcn); DataSet ds=new DataSet(); da.Fill(dsTableName); Gridview1.DataSource=ds.Tables[0]; GridView.DataBind(); }