Displaying table name in the combobox

Question

hello can anybody help me in displaying the table names from dataset into the comboBox ..

Pravin More · Answer

Hi Satishchandra, here is code DataSet dataSet1=new DataSet(); SqlConnection conn = new SqlConnection("Data Source='SHAWHP\SQLEXPRESS';Initial Catalog=SoftwareInventory;Integrated Security=SSPI"); // change this coonection string according to you settings of sql server SqlCommand cmd = new SqlCommand("SELECT name FROM Databasename.sys.tables", conn); SqlDataAdapter adapter = new SqlDataAdapter(cmd); adapter.Fill(dataSet1, "Table"); //now you can show this dataset table on window form combobox toolStripComboBox1.ComboBox.DataSource = dataSet1.Tables["Table"] . DefaultView ; toolStripComboBox1.ComboBox.BindingContext = this.BindingContext; Thanks, Pravin. Mark "Accepted Answer" if this post help you.

Tulasi · Answer

Try this for (int i = 0; i { //add this as item to combobox ds.Tables[0].TableName.ToString(); }

Pravin More · Answer

Hi Sathishchandra, ok for that do 1 thing in 1st query of Tablename selection get tableID and Tablename too.....like this SELECT object_id,name FROM DBName.sys.tables so when you click on name send tableID to below Query like this SELECT * FROM syscolumns WHERE ID=36195179 (selected objectID) Thanks

Satishchandra TN · Answer

Thanks Pravin it helped me.. Can you guide me in fetching the columns of the respective table when selected in combobox

Satishchandra TN · Answer

Thanks Vidya .. it helped me.. can you guide me in getting the columns of the respective table when selected in combobox?

Displaying table name in the combobox

Answers (5)