![]() |
|
![]() |
|
|
Thread Tools | Display Modes |
|
|
#1 |
|
Newbie
Join Date: Apr 2005
Posts: 12
Rep Power: 0
![]() |
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. |
|
|
|
![]() |
| Bookmarks |
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | |
| Display Modes | |
|
|