SQL Results to Variables

[dcolanduno]

Hello,

 

I am trying to figure out how to best program a part of a new .NET site I am working on. Sadly, due to a medical issue, I haven't been able to get back into programming for the past three years, and it seems that some of my .NET mojo has been way too lazy. <sigh>

 

So, I have a SQL connection in my ASP.NET application working, and can use some of the built in tools to see the records in the database. But, what I really want is to put the results of my query into some form of recordset where I can assign results into different variables so I can use them within the application.

 

Kind of like retrieving a different variable for each requested field inside the SQL Server record returned.

 

What is the best way to accomplish this? I seem to be barking up the wrong tree in the efforts I have made so far.

 

Thank you,

 

Derek C.

[Nate Bross]

You probably want to look into the DataSet object, it is the .NET version of a RecordSet.

 

Once you populate the DataSet, you access it like this:

 

foreach(DataRow dr in dsObject.Tables["tableName"].Rows)
{
   int yourVariable = int.Parse(dr["fieldName"].ToString());
}

[dcolanduno]

Thanks Nate! :)

[kcwallace]

You can also populate a sqldatareader. I have had much success with it.

 

It seems to take a long time to fill a dataset/datatable. Especially if you have no intentions of editing the returned dataset.