Click here to Skip to main content
15,906,574 members
Home / Discussions / Visual Basic
   

Visual Basic

 
QuestionRe: Desktop refresh on Timer_Tick Pin
Sonia Gupta16-May-07 22:35
Sonia Gupta16-May-07 22:35 
AnswerRe: Desktop refresh on Timer_Tick Pin
Christian Graus17-May-07 2:37
protectorChristian Graus17-May-07 2:37 
AnswerRe: Desktop refresh on Timer_Tick Pin
Dave Kreskowiak17-May-07 4:48
mveDave Kreskowiak17-May-07 4:48 
GeneralRe: Desktop refresh on Timer_Tick Pin
The ANZAC17-May-07 11:27
The ANZAC17-May-07 11:27 
QuestionReading a file in the internet Pin
re infecta16-May-07 22:24
re infecta16-May-07 22:24 
AnswerRe: Reading a file in the internet Pin
ne0h17-May-07 2:12
ne0h17-May-07 2:12 
Question'prcInserting Expects parameter @Extension which was not Supplied" Pin
Vimalsoft(Pty) Ltd16-May-07 21:49
professionalVimalsoft(Pty) Ltd16-May-07 21:49 
AnswerRe: 'prcInserting Expects parameter @Extension which was not Supplied" Pin
Dave Kreskowiak17-May-07 4:39
mveDave Kreskowiak17-May-07 4:39 
I've told you three times what you have to do.

I give up. You're simply not listening, or your not doing any experimentation to test what I'm telling you.

If you don't put the effort into it, why should we?


[EDIT]
Wait a minute! Sorry! My bad. I thought you were asking the same question for a fourth time. Blush | :O

You don't need all of this:
With ComNum_key
.ActiveConnection = conn
.CommandText = "prcInserting"
.CommandType = adCmdStoredProc
End With


With ComExtension
.ActiveConnection = conn
.CommandText = "prcInserting"
.CommandType = adCmdStoredProc
End With

With ComCell_ID
.ActiveConnection = conn
.CommandText = "prcInserting"
.CommandType = adCmdStoredProc
End With

With ComActual_Extent
.ActiveConnection = conn
.CommandText = "prcInserting"
.CommandType = adCmdStoredProc
End With

With ComLis_key
.ActiveConnection = conn
.CommandText = "prcInserting"
.CommandType = adCmdStoredProc
End With

With ComFunc_key
.ActiveConnection = conn
.CommandText = "prcInserting"
.CommandType = adCmdStoredProc
End With

You're creating 6 seperate sql commands and adding a single parameter to each. You need to create just ONE sql command, then add all 6 of your parameters to the one command. Also, you've managed to convert the input from the textboxs to numbers, but you didn't use these numbers in the sql parameters. You, AGAIN, assigned the strings to the parameters. (This is why I thought you asked the same question for a forth time!) Those are really BAD variable names BTW.
strNum_key = Val(Trim(txtnumkey.Text))
strExtension = Val(Trim(txtextension.Text))
strCell_ID = Val(Trim(txtcellid.Text))
strActual_Extent = Val(Trim(txtactualextent.Text))
strLis_key = Val(Trim(txtliskey.Text))
strFunc_key = Val(Trim(txtfunckey.Text))

Set sqlCommand = New Command
Set prmNum_key = sqlCommand.CreateParameter("Num_Key", adBigInt _
, adParamInput, strNum_key )

Set prmExtension = sqlCommand.CreateParameter("Extension", adBSTR _
, adParamInput, , strExtension)

Set prmCell_ID = sqlCommand.CreateParameter("Cell_ID", adBSTR _
, adParamInput, , strCell_ID)

Set prmActual_Extent = sqlCommand.CreateParameter("Actual_Extent", adBSTR _
, adParamInput, , strActual_Extent)

Set prmLis_key = sqlCommand.CreateParameter("Lis_Key", adBSTR _
, adParamInput, 50, strLis_key)

Set prmFunc_key = sqlCommand.CreateParameter("Func_key", adBSTR _
, adParamInput, 8, strFunc_key)




A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
     2006, 2007


Questionvb6 to vb.net Pin
Sonia Gupta16-May-07 21:16
Sonia Gupta16-May-07 21:16 
AnswerRe: vb6 to vb.net Pin
Christian Graus16-May-07 22:34
protectorChristian Graus16-May-07 22:34 
GeneralRe: vb6 to vb.net Pin
Sonia Gupta16-May-07 23:53
Sonia Gupta16-May-07 23:53 
AnswerRe: vb6 to vb.net Pin
ChandraRam16-May-07 23:47
ChandraRam16-May-07 23:47 
GeneralRe: vb6 to vb.net Pin
Sonia Gupta16-May-07 23:50
Sonia Gupta16-May-07 23:50 
GeneralRe: vb6 to vb.net Pin
Christian Graus17-May-07 0:04
protectorChristian Graus17-May-07 0:04 
QuestionVB.NET Connect to Server Pin
Socheat.Net16-May-07 21:02
Socheat.Net16-May-07 21:02 
AnswerRe: VB.NET Connect to Server Pin
Sonia Gupta16-May-07 21:18
Sonia Gupta16-May-07 21:18 
GeneralRe: VB.NET Connect to Server Pin
Socheat.Net16-May-07 21:30
Socheat.Net16-May-07 21:30 
AnswerRe: VB.NET Connect to Server Pin
Sonia Gupta16-May-07 21:35
Sonia Gupta16-May-07 21:35 
QuestionRe: VB.NET Connect to Server [modified] Pin
Socheat.Net16-May-07 21:51
Socheat.Net16-May-07 21:51 
GeneralRe: VB.NET Connect to Server Pin
Sonia Gupta16-May-07 22:25
Sonia Gupta16-May-07 22:25 
GeneralRe: VB.NET Connect to Server Pin
Socheat.Net16-May-07 22:42
Socheat.Net16-May-07 22:42 
QuestionRe: VB.NET Connect to Server Pin
Sonia Gupta16-May-07 23:08
Sonia Gupta16-May-07 23:08 
AnswerRe: VB.NET Connect to Server Pin
Socheat.Net16-May-07 23:22
Socheat.Net16-May-07 23:22 
AnswerRe: VB.NET Connect to Server Pin
Socheat.Net16-May-07 23:24
Socheat.Net16-May-07 23:24 
GeneralRe: VB.NET Connect to Server Pin
Sonia Gupta16-May-07 23:34
Sonia Gupta16-May-07 23:34 

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.