not show data in grid view after code

Posted by Naveenrohillamca under ASP.NET on 7/3/2011 | Points: 10 | Views : 2103 | Status : [Member] | Replies : 2

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

SqlConnection con = new SqlConnection();
con.ConnectionString = "Data Source=ROHILLA;Initial Catalog=query;Persist Security Info=True;User ID=sa;Password=123";
con.Open();
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = new SqlCommand("select * from Table1 where roll=1", con);

DataSet ds = new DataSet();
da.Fill(ds, "Table1");
dataGridView1.DataSource = ds;
after doing this grid view don't show data pls help me to see code in grid view

Reply | Reply with Attachment

Alert Moderator

Responses

Posted by: Rajesh_parbat on: 7/3/2011 [Member] Starter | Points: 25

0	Hi, Add the following after dataGridView1.DataSource = ds; dataGridView1.DataBind(); Naveenrohillamca, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Naveenrohillamca on: 7/3/2011 [Member] Starter | Points: 25

0	HI..........THANKS 4 HELP ME........ PLS PROVIDE ME A EBOOK FOR ASP.NET 3.5 THANKS Naveenrohillamca, if this helps please login to Mark As Answer. \| Alert Moderator

Latest Posts