Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2
Thread: retrieving data not working
04-02-2007, 08:28 PM #1
- Join Date
- Aug 2005
- Thanked 0 Times in 0 Posts
retrieving data not working
Hey guys, how to retrieve data from sql server 2000 using asp.net and adodb?
cmd = Server.CreateObject("ADODB.Command") cmd.ActiveConnection = conn If conn.errors.count = 0 Then 'Response.Write("Connected OK") cmd.CommandText = "SELECT * FROM Test" Response.Write(cmd.CommandText) End If
04-02-2007, 10:36 PM #2
- Join Date
- Jun 2005
- Near Chicago, IL, USA
- Thanked 32 Times in 31 Posts
Are you using .net 2.0?
This is old Classic ASP here; .NET is a bit different, and 1.1 and 2.0 are different enough that the version is important.
If this post contains any code, I may or may not have tested it. It's probably just example code, so no getting knickers in a bunch over a typo, OK? If it doesn't have basic error checking in it, such as object detection or checking if objects are null before using them, put that in there. I'm giving examples, not typing up your whole app for you. You run code at your own risk.
Bored? Visit http://www.kaelisspace.com/