OdbcCommandBuilder DeriveParameters Problem
-
Hi, I use OdbcCommandBuilder.DeriveParameters to get a stored procedure parameters and fill them in with values. After that, I can access the command object to see all parameter's name and values. But when I fill the command with the data adapter I got the following error: ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Procedure 'sSPName' expects parameter '@dteBeg', which was not supplied. Code: ...... Dim cmdODBC As OdbcCommand = cnnODBC.CreateCommand() cmdODBC.CommandTimeout = 300 cmdODBC.CommandType = CommandType.StoredProcedure cmdODBC.CommandText = sSPName cnnODBC.Open() OdbcCommandBuilder.DeriveParameters(cmdODBC) 'Add values to parameters: For i As Integer = 0 To cmdODBC.Parameters.Count - 1 ...... Next 'Write out the parameter's name and value: For Each parameter As OdbcParameter In cmdODBC.Parameters response.write(parameter.ParameterName & "=" & parameter.Value) Next Dim adpODBC As New OdbcDataAdapter(cmdODBC) adpODBC.Fill(ds, "Results") 'error appeal here. ...... Any helps are appreciated.