Programming Forums
User Name Password Register
 

RSS Feed
FORUM INDEX | TODAY'S POSTS | UNANSWERED THREADS | ADVANCED SEARCH

Reply
 
Thread Tools Display Modes
Old Apr 11th, 2005, 11:27 AM   #1
Illuminati
Newbie
 
Join Date: Apr 2005
Posts: 12
Rep Power: 0 Illuminati is on a distinguished road
MSSQL/MSACCESS Search

Another little problem im having with searching data from an MS Access Database, the following code gives me an error, but it works perfect if it juse use "SELECT * FROM tblData", the error is on this line:

[PHP]
mDataAdapter.Fill(mDataSetTwo)
[/PHP]

Error given: no value given for one of more required parameters

Seems an obvious error, but i cant for the life of me work out what parameter is missing, lol.

the code:

[PHP]
Dim mDataSetTwo As New System.Data.DataSet
Dim pDataRow(5) As DataRow, DataID As Integer, i As String

mDataAdapter.SelectCommand = New OleDb.OleDbCommand("SELECT * FROM tblData WHERE Name LIKE " & ReleaseName, mConn)
mCommandBuilder = New OleDb.OleDbCommandBuilder(mDataAdapter)

Try

mDataAdapter.Fill(mDataSetTwo) ' error occurs here

pDataRow = mDataSetNuke.Tables(0).Rows(0)

DataID = pDataRow(0)!ID
DataID -= 83

pDataRow(1) = mDataSet.Tables(0).Rows(DataID)

pDataRow(1)!Error = "Yes"
pDataRow(1)!Reason = Reason

mDataAdapter.Update(mDataSet)

Catch err As System.Exception
MsgBox(err.Message)
End Try
[/PHP]

any help would be greatly appretiated, thanks.

Last edited by Illuminati; Apr 11th, 2005 at 2:17 PM.
Illuminati is offline   Reply With Quote
Reply

Bookmarks

« Previous Thread in Forum | Next Thread in Forum »

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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump




DaniWeb IT Discussion Community
All times are GMT -5. The time now is 1:20 PM.

Powered by vBulletin® Version 3.7.0, Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Copyright ©2007 DaniWeb® LLC