how to fill a datagridview on listview Item Selection Change

Question

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

darma teja · Answer

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 Singh · Answer

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 Khan · Answer

I Want the code to fill the datagridview with the listview item selected

Dharmendra Singh · Answer

on listView_SelectedIndexChanged event