Error reading from Access

[Alexander M. Polak]

In a web anabled program we want to read some info of a user. Therefore we
wrote

Private Sub ReadUser(ByVal Username As String)
'Step by step
'1 De connector = MyConn
'2 Make a SQL String (= SqlString)
'3 Make a OleDbCommand ( cmdUsers = New OleDBCommand( SqlString,
MyConn)
'4 Add a Parameter
'5 Make a OleDbDataAdator ( daUsers = New
OleDbDataAdaptor(cmdSelect)
'6 Make a DataSet ( dsUsers as New Dataset)
'7 Get Data ( daUsers.Filll(dsUsers,"Users")
'9 Use Results
'(==================)
'
'There we go
'1 existing connection
'2 Contruct a SqlString
Dim SqlString As String = ("SELECT ID, Naam, Usernaam, Userlevel
FROM Users Where ([Naam]= ?)")
'3 Make OleDbCOmmand
Dim cmdUsers As New System.Data.OleDb.OleDbCommand(SqlString,
MyConn)
'4 Setup Parameter
cmdUsers.Parameters.Add(New System.Data.OleDb.OleDbParameter("Naam",
System.Data.OleDb.OleDbType.VarWChar, 50, "Naam")).Value = Username
'5 Make OledBDataAdaptor
Dim daUsers As New System.Data.OleDb.OleDbDataAdapter(cmdUsers)
'6 Create a new dataset
Dim dsUsers As New DataSet
'7 Get Data from database
daUsers.Fill(dsUsers, "Users")
'Gives a Error : No value given for one or more required parameters.

Etc........
end Sub

Thus someone kowns wat's wrong here. After spending 6 hours with the help
file an a stack of book we have'd a cloe yet.

[Bob Barrows]

Hmm, this looks like dotnet code. You'll probably have better luck getting
an answer on one of the dotnet groups, like
microsoft.public.dotnet.framework.aspnet.


Alexander M. Polak wrote:

> In a web anabled program we want to read some info of a user.
> Therefore we wrote
>
> Private Sub ReadUser(ByVal Username As String)
> 'Step by step
> '1 De connector = MyConn
> '2 Make a SQL String (= SqlString)
> '3 Make a OleDbCommand ( cmdUsers = New OleDBCommand(
> SqlString, MyConn)
> '4 Add a Parameter
> '5 Make a OleDbDataAdator ( daUsers = New
> OleDbDataAdaptor(cmdSelect)
> '6 Make a DataSet ( dsUsers as New Dataset)

[Alexander M. Polak]

Will try that, thanks

"Bob Barrows" <reb_01501@yahoo.com> wrote in message
news:%23fZPLijZDHA.1384@TK2MSFTNGP10.phx.gbl...

> Hmm, this looks like dotnet code. You'll probably have better luck getting
> an answer on one of the dotnet groups, like
> microsoft.public.dotnet.framework.aspnet.
>
>
> Alexander M. Polak wrote:

> > In a web anabled program we want to read some info of a user.
> > Therefore we wrote
> >
> > Private Sub ReadUser(ByVal Username As String)
> > 'Step by step
> > '1 De connector = MyConn
> > '2 Make a SQL String (= SqlString)
> > '3 Make a OleDbCommand ( cmdUsers = New OleDBCommand(
> > SqlString, MyConn)
> > '4 Add a Parameter
> > '5 Make a OleDbDataAdator ( daUsers = New
> > OleDbDataAdaptor(cmdSelect)
> > '6 Make a DataSet ( dsUsers as New Dataset)

>
>