Database problem...

[DigitalGeek]

with the following code...
imports System.Data
Imports System.Data.Oledb
.
.
.
dim dradotst as OleDbDataReader

connadotst.Open()
Try
dradotst = Me.OleDbSelectCommand1.ExecuteReader(CommandBehavior.CloseConnection)
Catch oledbexception As Exception
MsgBox(oledbexception.Message)
End Try
.
.
.




i get the message...
"No value given for one or more required parameters."


...help....

it worked until I added code in a seperate sub to update the dataset and database?????

 

[aliinal]

do you use parameters in OleDbSelectCommand1's select command?

 

[DigitalGeek]

what parameters? I coppied the example from a book... this works in another program I have written...

it even worked in this program...

 

[aliinal]

I understand that you don't use parameters. if we put aside the parameters, this may occur in a few conditions. one is a wrong fieldname or if you're using a case sensitive DB and if your command is not case sensitive.
but i can not help you further unless i see the select command. if you post it i think i can help more.

have a nice day

@li

 

[DigitalGeek]

I created the connection, adapter, and dataset using the IDE...


'OleDbSelectCommand1
'
Me.OleDbSelectCommand1.CommandText = "SELECT Article, Code, Desciption FROM Articles"
Me.OleDbSelectCommand1.Connection = Me.adotstolec

I don't know if this is what your looking for?