Programming Forums > Application Development > Visual Basic .NET

Intimidat0r · Nov 16th, 2005, 10:10 PM

This is really ASP.NET, but I'm using VB as the language, so I thought i'd post it here for lack of a better place.

anyway, i have this code:

(Toggle Plain Text)

		Dim objConn As New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath(DBPath))
		Try
			objConn.Open()
		Catch ex As OleDbException
			Response.Write("<script>alert('Could not connect to the database.\nPlease contact the administrator.');</script>")
			Exit Sub
		End Try

		Dim objCmd As New OleDbCommand("SELECT post FROM teacher_info WHERE username='" & Session.Item("Username") & "'", objConn)
                'ERROR LINE JUST BELOW
		Dim objDataReader As OleDbDataReader = objCmd.ExecuteReader
                'ERROR LINE JUST ABOVE
		objDataReader.Read()

		txtBulliten.Text = objDataReader.Item("post")

and when i try to run it the line i marked as error line throws a oledbexception. anybody have any idea what's wrong? thanks.

Dameon · Nov 16th, 2005, 10:28 PM

What is the exception message?

Intimidat0r · Nov 16th, 2005, 10:32 PM

the exception message:

Quote:

No value given for one or more required parameters.

Ooble · Nov 17th, 2005, 11:39 AM

Take a look at the MSDN page - you have to implement it in a specific way.

Intimidat0r · Nov 17th, 2005, 8:11 PM

um, is there something im missing between the example and what i have?

Ooble · Nov 18th, 2005, 5:43 PM

Sorry - I thought there was, but it seems your code should be fine, semantically at least. What exactly is the error message?

melbolt · Nov 20th, 2005, 11:26 PM

hmm, it looks good to me, I know this may sound stupid but try putting a () on the end

like in the example on MSDN:

(Toggle Plain Text)

myReader = myCommand.ExecuteReader()

I've seen dumber things happen before in .NET, it should automatically put it in there, I assume you copy/pasted this, it should be in there. I've actually had errors as a result of this before, give it a try.

so try changing this:

(Toggle Plain Text)

Dim objDataReader As OleDbDataReader = objCmd.ExecuteReader

to this:

(Toggle Plain Text)

Dim objDataReader As OleDbDataReader = objCmd.ExecuteReader()

lemme know if this makes a difference, I'm curious

Ooble · Nov 21st, 2005, 11:04 AM

That makes sense... I know in VB you didn't have to do that (it actually caused an error), but in VB .NET they could have changed it.

Nov 16th, 2005, 10:10 PM	#1
Intimidat0r Hobbyist Programmer Join Date: May 2005 Location: Don't know, but the padded walls are a nice touch. Posts: 126 Rep Power: 0	OleDB This is really ASP.NET, but I'm using VB as the language, so I thought i'd post it here for lack of a better place. anyway, i have this code: (Toggle Plain Text) Dim objConn As New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath(DBPath)) Try objConn.Open() Catch ex As OleDbException Response.Write("<script>alert('Could not connect to the database.\nPlease contact the administrator.');</script>") Exit Sub End Try Dim objCmd As New OleDbCommand("SELECT post FROM teacher_info WHERE username='" & Session.Item("Username") & "'", objConn) 'ERROR LINE JUST BELOW Dim objDataReader As OleDbDataReader = objCmd.ExecuteReader 'ERROR LINE JUST ABOVE objDataReader.Read() txtBulliten.Text = objDataReader.Item("post") Dim objConn As New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath(DBPath)) Try objConn.Open() Catch ex As OleDbException Response.Write("<script>alert('Could not connect to the database.\nPlease contact the administrator.');</script>") Exit Sub End Try Dim objCmd As New OleDbCommand("SELECT post FROM teacher_info WHERE username='" & Session.Item("Username") & "'", objConn) 'ERROR LINE JUST BELOW Dim objDataReader As OleDbDataReader = objCmd.ExecuteReader 'ERROR LINE JUST ABOVE objDataReader.Read() txtBulliten.Text = objDataReader.Item("post") and when i try to run it the line i marked as error line throws a oledbexception. anybody have any idea what's wrong? thanks. __________________ Children in the dark cause accidents, and accidents in the dark cause children. http://www.ronincoders.org

Nov 16th, 2005, 10:28 PM	#2
Dameon Troll Join Date: Apr 2005 Location: Texas Posts: 732 Rep Power: 4	What is the exception message? __________________ MD5(sig) = bcef75433db02e9ad9bf81d6f7c5c270

Nov 17th, 2005, 11:39 AM	#4
Ooble I eat cake for breakfast. Join Date: Jul 2004 Location: In my box. Posts: 4,434 Rep Power: 9	Take a look at the MSDN page - you have to implement it in a specific way. __________________ Me :: You :: Them

Nov 17th, 2005, 8:11 PM	#5
Intimidat0r Hobbyist Programmer Join Date: May 2005 Location: Don't know, but the padded walls are a nice touch. Posts: 126 Rep Power: 0	um, is there something im missing between the example and what i have? __________________ Children in the dark cause accidents, and accidents in the dark cause children. http://www.ronincoders.org

Nov 18th, 2005, 5:43 PM	#6
Ooble I eat cake for breakfast. Join Date: Jul 2004 Location: In my box. Posts: 4,434 Rep Power: 9	Sorry - I thought there was, but it seems your code should be fine, semantically at least. What exactly is the error message? __________________ Me :: You :: Them

Nov 20th, 2005, 11:26 PM	#7
melbolt Hobbyist Programmer Join Date: Feb 2005 Location: PA, USA Posts: 244 Rep Power: 4	hmm, it looks good to me, I know this may sound stupid but try putting a () on the end like in the example on MSDN: (Toggle Plain Text) myReader = myCommand.ExecuteReader() myReader = myCommand.ExecuteReader() I've seen dumber things happen before in .NET, it should automatically put it in there, I assume you copy/pasted this, it should be in there. I've actually had errors as a result of this before, give it a try. so try changing this: (Toggle Plain Text) Dim objDataReader As OleDbDataReader = objCmd.ExecuteReader Dim objDataReader As OleDbDataReader = objCmd.ExecuteReader to this: (Toggle Plain Text) Dim objDataReader As OleDbDataReader = objCmd.ExecuteReader() Dim objDataReader As OleDbDataReader = objCmd.ExecuteReader() lemme know if this makes a difference, I'm curious __________________ I have never let my schooling interfere with my education. -Mark Twain- Xbox live gamertag: melbolt

Nov 21st, 2005, 11:04 AM	#8
Ooble I eat cake for breakfast. Join Date: Jul 2004 Location: In my box. Posts: 4,434 Rep Power: 9	That makes sense... I know in VB you didn't have to do that (it actually caused an error), but in VB .NET they could have changed it. __________________ Me :: You :: Them

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Programming Forums > Application Development > Visual Basic .NET

OleDB