1
Reply

reading a dataset

vsr_prasad

vsr_prasad

Nov 12 2004 2:14 AM
1.9k
Hi, i have a function which returns a dataset. their after i need to read this dataset and fill the variables. my function: public DataSet SelectODBCData(string QueryString, string TableName) { DataSet ds = new DataSet(); OdbcDataAdapter ad = new OdbcDataAdapter(); try { ad.SelectCommand = new OdbcCommand(QueryString, WifiDbCon); if (TableName.Trim().Length > 0) ad.Fill(ds,TableName); else ad.Fill(ds); } catch (System.Exception e) { throw e; } return ds; } after this i did like this in my client procedure: SQLQuery = "Select taglabel from MSAssetTag where MAC = " + "'" + xml.Value + "'"; DataSet ds = new DataSet(); ds = SelectODBCData(SQLQuery,"MSAssetTag"); but from here how to read ds dataset to fill the variable 'TagLabel'?? help me please.. thanks., Prasad

Answers (1)