Getting data out of a data set

[developer155]

Hello I have a dataset and I am trying to find out how to get data from it using individual column name.
here is my code:
SqlConnection cn1 = new SqlConnection();
cn1.ConnectionString="Database=MyDB;User=sa;Password=pass;Server=SomeServ;";
cn1.Open();
SqlDataAdapter da = new SqlDataAdapter("Seelct * from Customers where customerid=111", cn1);
DataSet ds = new DataSet("DataSet");
da.Fill(ds,"DataSet");

So now I have this data from Customers table in dataset and I need to get single fields, like CustomerName, CustomerAddress

What is the way to do this?

thanks alot!!!!

 

[esdee]

try this:

data = MyDataReader.GetInt32(MyDataReader.GetOrdinal("fieldname"));

------------------------

http://esdeeblog.blogspot.com/

dev at viewmoresoft.com

http://www.viewmoresoft.com

tools for your database

 

[obislavu]

ds.Tables[0] is a DataTable that contains the Customers information.
A DataTable objects has a collection of rows and a row is a collection af columns.
So, you can see the DataTable as a matrix and you access a column value providing the row and the column:

// Access by index
object val = dt.Rows[iRow][iColumn]; // row iRow and column iColumn
// Access by column name
object val1 = dt.Rows[iRow]["CustomerName"];
object val2 = dt.Rows[iRow][CustomerAddress"];

Or, directly from the DataSet object:

int iRow = 2;
if (ds.Tables.Count >0 && iRow < ds.Tables[0].Rows.Count)
{
   object val = ds.Tables[0].Rows[idx]["CustomerName"];
}

obislavu

 

[shifar]

Since he use only one customer (ID 111) can't he use a datareader to read the single record. I think this is more efficent (unless he is doing any update or delete etc.)

 

[jby1]

Check out the possibility of using Typed Datasets (loads of info on Google), then you can refer to the column name as an object property.