Dear All,

I just jumped from Vb to C#. How can i know column name under a dataset?

common class for recordset save:

using System.Data.OleDb;
public string conStr= @"Provider=Microsoft.Jet.OLEDB.4.0; Data Source=..\\database.mdb";
cnn = new OleDbConnection(conStr);
cnn.open();
da = new OleDbDataAdapter("select * from " + sTableName, cnn);
ds = new DataSet();
da.Fill(ds, sTableName);

till here it works fine. The above code is under a class (rs)...

The problem i am fetching is here:
string lssql;
lssql = "update " + tablename + " set " + i_should_know_the_column_name + "='" +
                txtDescription.Text + "' where " + columnname = textbox1.text
rs.dataSave(lssql);

**i_should_know_the_column_name --> how to know the column name rs.ds.table(column(1)). Can anyone help me in this regards.

I am using VS2005, MSACCESS, WinXP32bit

Thanks in advance

BT  

Hi,
Try

ds[tablename].DataColumns[1].Name


____________________________
Build it better, faster, quicker, easier.. then fix it (non-offical MS mission statement)