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:"Calibri","sans-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