Loading

how to show database values to datagrid

Mageshwaran R

Sqlquery Oconnect = new Sqlquery();

SqlCommand Ocmd = new SqlCommand("SELECT *FROM REGISTERNAMES", Oconnect.Openconnection());

SqlDataAdapter Oadp= new SqlDataAdapter(Ocmd);

DataTable Odt = new DataTable();

Oadp.Fill(Odt);

DataGrd.DataContext= Odt.AsDataView();

----------------------------------------------------------------------------------

Hi,I am basic learner,this code is working but not showing database value in datagrid..

only blank row is insert...

2 Replies

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

Amit Gupta7y ago
Accepted answer
Binding should be replaced with below code
Replace
DataGrd.DataContext= Odt.AsDataView();

With
DataGrd.DataSource =ODT;
DataGrd.DataBind();
Amit Gupta7y ago
Have you noticed missing space in your query after *, it should be like... Select * from tablename