Getting Column Names Through Query

[sindhutiwari]

HI My Aim is to get the column names of a access database table and store it to a combobox using C#.net if any one knows the query or any clue please let me know regards sindhu tiwari

INNOVATIVE

[Muhammad Shahid Farooq]

string connectionString; OleDbConnection connection = new OleDbConnection(); OleDbDataAdapter dataAdapter; DataSet dataSet = new DataSet(); public Form1() { InitializeComponent(); } public void openConnection() { try { connectionString = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=C:\\Test.mdb"; connection.ConnectionString = connectionString; connection.Open(); } catch (Exception e) { MessageBox.Show(e.ToString()); } } public void closeConnection() { try { if (connection.State != 0) { connection.Close(); } } catch (Exception e) { MessageBox.Show(e.ToString()); } } public void fillDataset(string query, DataSet dataSet) { openConnection(); dataAdapter = new OleDbDataAdapter(query, connection); dataAdapter.Fill(dataSet, "ColumnNames"); closeConnection(); } public void fillComboBox() { string strQuery = "Select * From Table1"; fillDataset(strQuery, dataSet); foreach (DataColumn dataColumn in dataSet.Tables[0].Columns) { cmbColumnNames.Items.Add(dataColumn.ColumnName); } } private void Form1_Load(object sender, EventArgs e) { fillComboBox(); }

[pmarfleet]

Why have you posted this question? The link I sent you in response to your previous question also explained how to get a list of fields for an Access table. You should learn to search Google for answers to your questions before posting. Otherwise it looks like you can't be bothered to search for a solution to your problem yourself.

Paul Marfleet "No, his mind is not for rent To any God or government" Tom Sawyer - Rush

[Mitesh Darji]

:cool: you can use the following query in your code ... SELECT column_name FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'name_of_the_table'

Mitesh Darji