Datagridview not able to retrieve record

Collins Aigbekhai

I can not retireve record to row in datagridview, using cell_leave event and using the first cell as index to retrieve from database the code is as follows:

private void dgv_CellLeave(object sender, DataGridViewCellEventArgs e)

{

SqlConnection con = new SqlConnection("Data Source=Me; Database=Services;Integrated Security=true");

string str = ("SELECT Code,Category,ItemColor,Price FROM Item WHERE Code='" +col0+ "'");

SqlCommand cmd = new SqlCommand(str, con);

con.Open();

DataTable table = new DataTable();

SqlDataAdapter da = new SqlDataAdapter();

da.SelectCommand = cmd;

da.Fill(table);

dgv.DataSource = table;

}

Please can someone help me?

the image

6 Replies

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

Jignesh Kumar8y ago
Instead of CellLeave event please try CellEndEdit or CellValueChanged event.

https://stackoverflow.com/questions/20297134/how-i-can-get-result-on-cell-leave-event-of-datagrid-view
Collins Aigbekhai8y ago
@Gaurav Raj I am not use to Linq, any ideas will be welcomed.
Collins Aigbekhai8y ago
Thank you @Jigmesh Kumar, DataBind() method did not work sir.
Jignesh Kumar8y ago
Hi,
Still issue is there or resolved ?
Gaurav Raj8y ago
u can use linq ,linq is better than ado.net
Jignesh Kumar8y ago
you are missing dataBind() method after assigning datasource
dgv.DataSource = table;
dvg.DataBind();