record not shown

umair mohsin

9y915.NET

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

9 Replies

Know the answer? Post it — somebody with the same question will find it here.

Bryian Tan9y ago
Can you share your aspx page too? Specfically for the GridView1
umair mohsin9y ago
if i don't want to use data set inspite i wonna use data table then what would be the code.
Gnanavel Sekar9y ago
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();
Amit Gupta9y ago
Please look at the link that I had posted, thats exactly looks what you want.
umair mohsin9y ago
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
Amit Gupta9y ago
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/
umair mohsin9y ago
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
Amit Gupta9y ago
@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 Shah9y ago
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?