I have an application written in Classic ASP. I use MANY recordsets. How do I convert such code related to recordsets to ASP.NET?Mostly you will work with DataReader and DataSet Classes and use the DataSets that they return to bindable ASP.NET Web Controls such as the ASP
ataGrid and others.<BR><BR>If you are just starting out on your ASP.NET adventure I would highly recommend browsing the IBuySpy sample application and the related source code samples that are provided.<BR><BR>You can view the IBuySpy Application here..<BR> http://www.ibuyspy.com<BR><BR>And the documentation here..<BR> http://www.ibuyspy.com/storevb/docs/docs.htmYeah I know. BUT the question is...how do you utilize current recordset code in ASP.NET?> Yeah I know. BUT the question is...how do <BR> > you utilize current recordset code in ASP.NET?<BR><BR>I'm sure that this is not the answer that wanting to hear but... You should re-code your scripts to take advantage of the new controls... that's how!<BR><BR>There is no ADO in .NET only ADO.NET and therefore no sense in using the ADODB recordset class when writing ADO.NET code.<BR><BR>But if you really insist on using an ADODB.Recordset then reading Scott Mitchell's post below:<BR><BR> RE: VB6 Components in ASP.NET<BR> http://www.aspmessageboard.com/forum/ASPPlus.asp?M=281455&P=1&F=36<BR><BR>Might be of some interest to you. Then you can try something like this in your ASP.NET page...<BR><BR> Sub Page_Load (sender As Object, e As EventArgs)<BR><BR> Dim objRst = Server.CreateObject("ADODB.Recordset")<BR> Response.Write (TypeName(objRst))<BR><BR> End Sub
ataGrid and others.<BR><BR>If you are just starting out on your ASP.NET adventure I would highly recommend browsing the IBuySpy sample application and the related source code samples that are provided.<BR><BR>You can view the IBuySpy Application here..<BR> http://www.ibuyspy.com<BR><BR>And the documentation here..<BR> http://www.ibuyspy.com/storevb/docs/docs.htmYeah I know. BUT the question is...how do you utilize current recordset code in ASP.NET?> Yeah I know. BUT the question is...how do <BR> > you utilize current recordset code in ASP.NET?<BR><BR>I'm sure that this is not the answer that wanting to hear but... You should re-code your scripts to take advantage of the new controls... that's how!<BR><BR>There is no ADO in .NET only ADO.NET and therefore no sense in using the ADODB recordset class when writing ADO.NET code.<BR><BR>But if you really insist on using an ADODB.Recordset then reading Scott Mitchell's post below:<BR><BR> RE: VB6 Components in ASP.NET<BR> http://www.aspmessageboard.com/forum/ASPPlus.asp?M=281455&P=1&F=36<BR><BR>Might be of some interest to you. Then you can try something like this in your ASP.NET page...<BR><BR> Sub Page_Load (sender As Object, e As EventArgs)<BR><BR> Dim objRst = Server.CreateObject("ADODB.Recordset")<BR> Response.Write (TypeName(objRst))<BR><BR> End Sub