dataset

Question

How to fill dataset from dropdownlist?

Master Billa · Answer

Hi You can do  like this way Normal 0 false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4 /* Style Definitions */ table.MsoNormalTable {mso-style-name:Table Normal; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-qformat:yes; mso-style-parent:; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin-top:0in; mso-para-margin-right:0in; mso-para-margin-bottom:10.0pt; mso-para-margin-left:0in; line-height:115%; mso-pagination:widow-orphan; font-size:11.0pt; font-family:Calibrisans-serif; mso-ascii-font-family:Calibri; mso-ascii-theme-font:minor-latin; mso-fareast-font-family:Times New Roman; mso-fareast-theme-font:minor-fareast; mso-hansi-font-family:Calibri; mso-hansi-theme-font:minor-latin;} DataSet data = null ; private void comboBox1_SelectedIndexChanged( object sender EventArgs e) { string slectedValue = comboBox1 . SelectedItem . ToString(); using ( SqlConnection con = new SqlConnection ( connection )) { using ( SqlCommand cmd = con . CreateCommand()) { cmd . CommandText = select * from tableName where ID=' + slectedValue + ' ; cmd . CommandType = CommandType . Text; data = new DataSet (); using ( SqlDataAdapter adapter = new SqlDataAdapter (cmd)) { adapter . Fill(data); } } } DataGrid1 . DataSource = data . Tables[0]; } Thank you