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_idname 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?