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.