record not shown

Question

here is my code SqlConnection conn = new SqlConnection(ConStr1); conn.Open(); SqlCommand cmd = new SqlCommand("select * from emplyees", conn); cmd.CommandType = CommandType.Text; SqlDataAdapter sda = new SqlDataAdapter(); DataSet ds = new DataSet(); sda.Fill(ds); GridView1.DataSource = ds; GridView1.DataBind(); conn.Close(); i want to display record on a button click event but record is not displaying could anyone help me what should i do? code should examine.furthermore i don't want to use data set

Amit Gupta · Answer

Please look at the link that I had posted, thats exactly looks what you want.

Amit Gupta · Answer

Your code was ok, the thing you need to check is: 1. Make sure dt contains rows (by debug your code) 2. Make sure gridview has AutoGenerateColumn = false and runat =server in the designer section If problem still exists then take a fresh gridview and try your code. Take a look to the below article http://www.c-sharpcorner.com/UploadFile/009464/bind-gridview-using-dataset-in-Asp-Net/

Amit Gupta · Answer

@Umair Your code is incomplete, SqlDataAdapter has some missing argument SqlConnection conn = new SqlConnection(ConStr1); conn.Open(); SqlCommand cmd = new SqlCommand( "select * from emplyees" , conn); cmd.CommandType = CommandType.Text; SqlDataAdapter sda = new SqlDataAdapter( cmd ); DataSet ds = new DataSet(); sda.Fill(ds); GridView1.DataSource = ds; GridView1.DataBind(); conn.Close(); Thats it !!

Nilesh Shah · Answer

Is there any exception or error you get? are there any records in employees table or not? Can you put debug point on following line and see if ds contains any data in it or not? GridView1.DataSource = ds; if ds does not have any data in it then there is different way to solve it. if ds has data, then there is different way to solve it like looking at your aspx file, does your grid has any bound field in it, is the field name ok?

Bryian Tan · Answer

Can you share your aspx page too? Specfically for the GridView1

umair mohsin · Answer

if i don't want to use data set inspite i wonna use data table then what would be the code.

Gnanavel Sekar · Answer

Did you check whether you are getting record in ds? if yes and not displaying data means just use below code GridView1.DataSource = ds.Tables[0].DefaultView; GridView1.DataBind();

umair mohsin · Answer

my database table has reocords which has shown on page load event but same code i entered on button click event nothing happend this time

umair mohsin · Answer

sorry dear there is a mistake in a code i forgot to post that select command property for sql data adapter. i have tried before what you said,but notinh happend.here is it. SqlConnection conn = new SqlConnection(ConStr1); conn.Open(); SqlCommand cmd = new SqlCommand("select * from emplyees", conn); cmd.CommandType = CommandType.Text; DataTable dt = new DataTable(); SqlDataAdapter sda = new SqlDataAdapter(); sda.SelectCommand = cmd; sda.Fill(dt); GridView1.DataSource = dt; GridView1.DataBind(); conn.Close(); you can try it on abutton click event