How to call Table name from combo box in sql command

Question

I want to pool table name from the combo box in the SQL query. Below code, I use a static table name as "Logdata". For your reference, I attach the code. Please guide me on how to call the selected table in the SQL query from the combo box. Actually, I want to write the column name of the selected table in notepad. public void getColumnName() { cmbFilterColumnName.Items.Clear(); SqlConnection columnCon = new SqlConnection(dbCon); string columnQuery = @ "Select Column_Name from information_Schema.Columns where Table_Name = 'Logdata'" ; SqlCommand columnCmd = new SqlCommand(columnQuery, columnCon); columnCon.Open(); SqlDataReader columnDr = columnCmd.ExecuteReader(); while (columnDr.Read()) { string columnName = columnDr.GetString(0); chkListBxColumnName.Items.Add(columnName); } columnCon.Close(); }

Sachin Singh · Answer

On selectionChangeEvent you can achieve the same. private void ComboBoxName_SelectionChanged( object send ... { string tableName = ComboBoxName.Items.GetItemAt(ComboBoxName.SelectedIndex).ToString(); getColumnName(tableName); } public void getColumnName( string TableName) { cmbFilterColumnName.Items.Clear(); SqlConnection columnCon = new SqlConnection(dbCon); string columnQuery = @ "Select Column_Name from information_Schema.Columns where Table_Name ="+TableName ; SqlCommand columnCmd = new SqlCommand(columnQuery, columnCon); columnCon.Open(); SqlDataReader columnDr = columnCmd.ExecuteReader(); while (columnDr.Read()) { string columnName = columnDr.GetString(0); chkListBxColumnName.Items.Add(columnName); } columnCon.Close(); } or simply string TableName = ComBox.SelectionBoxItem.ToString(); // for WPF //OR string TableName = this .ComboBox.GetItemText( this .ComboBox.SelectedItem); //OR string TableName = cmbbox.Text; string columnQuery = @ "Select Column_Name from information_Schema.Columns where Table_Name =" +TableName;

Amit Gupta · Answer

var tableName = combox.Text; var query = "select * from "+ tableName;