Click here to Skip to main content
15,909,822 members
Home / Discussions / .NET (Core and Framework)
   

.NET (Core and Framework)

 
GeneralRe: Hello Can any one help me out real quick please Pin
ricmil4217-Feb-10 10:51
ricmil4217-Feb-10 10:51 
GeneralRe: Hello Can any one help me out real quick please Pin
Bob Beaubien17-Feb-10 10:52
Bob Beaubien17-Feb-10 10:52 
GeneralRe: Hello Can any one help me out real quick please Pin
Andy_L_J17-Feb-10 18:27
Andy_L_J17-Feb-10 18:27 
QuestionExntending windows explorer Pin
seanwright17-Feb-10 8:14
seanwright17-Feb-10 8:14 
AnswerRe: Exntending windows explorer Pin
Ashfield17-Feb-10 22:01
Ashfield17-Feb-10 22:01 
GeneralRe: Exntending windows explorer Pin
seanwright18-Feb-10 0:34
seanwright18-Feb-10 0:34 
AnswerRe: Exntending windows explorer Pin
Dave Kreskowiak18-Feb-10 2:26
mveDave Kreskowiak18-Feb-10 2:26 
QuestionOdbcCommandBuilder DeriveParameters Problem Pin
JimFeng17-Feb-10 5:55
JimFeng17-Feb-10 5:55 
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.
QuestionHelp regarding hosting/Development server? Pin
callousfantom17-Feb-10 0:05
callousfantom17-Feb-10 0:05 
AnswerRe: Help regarding hosting/Development server? Pin
Not Active17-Feb-10 0:26
mentorNot Active17-Feb-10 0:26 
AnswerRe: Help regarding hosting/Development server? Pin
Eddy Vluggen17-Feb-10 5:02
professionalEddy Vluggen17-Feb-10 5:02 
AnswerRe: Help regarding hosting/Development server? [modified] Pin
callousfantom17-Feb-10 18:00
callousfantom17-Feb-10 18:00 
QuestionJava in Visual Studio 2008 Team Suite? Pin
mauricemcse16-Feb-10 11:01
mauricemcse16-Feb-10 11:01 
AnswerRe: Java in Visual Studio 2008 Team Suite? Pin
Not Active16-Feb-10 12:21
mentorNot Active16-Feb-10 12:21 
AnswerRe: Java in Visual Studio 2008 Team Suite? Pin
Richard MacCutchan16-Feb-10 12:33
mveRichard MacCutchan16-Feb-10 12:33 
QuestionOne MSMQ Queue works but another one doesn't Pin
Hypermommy16-Feb-10 6:03
Hypermommy16-Feb-10 6:03 
QuestionUnable to print multiple copies for crystal report in vb.net. Pin
jgotlt15-Feb-10 0:06
jgotlt15-Feb-10 0:06 
QuestionHosting XNA in a windows forms control and in turn hosting that control in WPF Pin
Ekoj Lirpa13-Feb-10 8:23
Ekoj Lirpa13-Feb-10 8:23 
AnswerRe: Hosting XNA in a windows forms control and in turn hosting that control in WPF Pin
Hessam Jalali13-Feb-10 11:33
Hessam Jalali13-Feb-10 11:33 
GeneralRe: Hosting XNA in a windows forms control and in turn hosting that control in WPF Pin
Ekoj Lirpa13-Feb-10 13:04
Ekoj Lirpa13-Feb-10 13:04 
QuestionIE create object to com wrapped dotnet dll launch exe Pin
nlarson1113-Feb-10 3:08
nlarson1113-Feb-10 3:08 
QuestionLooking for FTP component Pin
Hypermommy13-Feb-10 2:20
Hypermommy13-Feb-10 2:20 
AnswerRe: Looking for FTP component Pin
Dimitri Witkowski13-Feb-10 3:54
Dimitri Witkowski13-Feb-10 3:54 
AnswerRe: Looking for FTP component Pin
Not Active13-Feb-10 7:26
mentorNot Active13-Feb-10 7:26 
GeneralRe: Looking for FTP component Pin
Hypermommy15-Feb-10 6:09
Hypermommy15-Feb-10 6:09 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.