[ish*]

Hi.,
In my programme I read data from Database and store in the dataset. My code is as follows.

SqlConnection connection; 
connection = new SqlConnection(ConfigurationManager.ConnectionStrings["GamesConnection"].ConnectionString); 

connection.Open();
		SqlCommand cmd = new SqlCommand("Select gamePlatform from gameTable",connection);
		SqlDataAdapter ad = new SqlDataAdapter(cmd);
		ad.SelectCommand = cmd;
		DataSet ds = new DataSet();
		ad.Fill(ds);
		connection.Close();

But I want to store this data in variable/array. So for that I want to know how to loop through Dataset. I am looking for some help on that.
Thanks

[baavgai]

A DataSet is a container. Inside that container, among other things, are DataTables. If your code worked, you should have at least one. Inside of a DataTable are DataRows. Each row has fields. More info, and probably the code you're looking for, here.

This post has been edited by baavgai: 06 January 2009 - 06:30 AM

[ish*]

baavgai, on 6 Jan, 2009 - 05:29 AM, said:

Hi baavgai.,
Thanks for your answer. I checked the URL n the programe works fine.. Thanks...