how to fill a datagridview on listview Item Selection Change

Mustaq Khan

I have a listview and datagridview, and i want ....When i click on listview item it should be added to datagridview....

4 Replies

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

darma teja13y ago
Hi Mustaq,

Write the following code in listView_SelectedIndexChanged event

try
{

grdview.DataSource = null;
grdview.Columns.Clear();
grdview.Rows.Clear();

string sqlQuery = write your SQL query here and with list view text also

SqlDataAdapter da = new SqlDataAdapter(sqlQuery, con);
SqlCommandBuilder cb = new SqlCommandBuilder(da);
DataSet ds = new DataSet();

da.Fill(ds);
grdview.DataSource = ds.Tables[0];

con.Close();
}
catch (Exception exx)
{
MessageBox.Show(exx.ToString());
}
finally
{
if (con != null)
con.Close();
}

Darma
Dharmendra Singh13y ago
ya if u use this event then here u can call gridview bind method. because on this event specific selection of value use to validate gridview data.
Mustaq Khan13y ago
I Want the code to fill the datagridview with the listview item selected
Dharmendra Singh13y ago
on listView_SelectedIndexChanged event