Hello all -
Before I become Control Dependent, i would like to understand how Database Access and Direct manipulation of data in ASP.NET is achieved.
I am having trouble finding anything that addresses this with SQL Server (express) and was hoping someone here could help me.
in Classic ASP i would create a connection using server.createObject("ADODB.Connection") and then a RecordSet object to which i would feed a query string and if there are returns i could step through them with a
Do While Not RS.Eof
I've found some info on connecting to MySql DB which allows me similar (if more hoop jumping) access but how do i do this with MS Sql?
- Also, while on the topic, with MySql there is a DataReader object which allows me to loop through, but i can't seem to access the information by way of field name, only index. is this my only option?
Thank you in Advance