Click here to Skip to main content
15,902,492 members
Home / Discussions / Visual Basic
   

Visual Basic

 
QuestionHow to change return value ? [modified] Pin
wgarnett6-Nov-09 5:37
wgarnett6-Nov-09 5:37 
AnswerRe: How to change return value ? Pin
EliottA6-Nov-09 6:59
EliottA6-Nov-09 6:59 
AnswerRe: How to change return value ? Pin
Christian Graus6-Nov-09 11:54
protectorChristian Graus6-Nov-09 11:54 
QuestionLarge size of Excel files Pin
Saurabh_Damle6-Nov-09 1:59
Saurabh_Damle6-Nov-09 1:59 
AnswerRe: Large size of Excel files Pin
DaveAuld6-Nov-09 10:16
professionalDaveAuld6-Nov-09 10:16 
GeneralRe: Large size of Excel files Pin
Saurabh_Damle6-Nov-09 20:42
Saurabh_Damle6-Nov-09 20:42 
GeneralRe: Large size of Excel files Pin
DaveAuld6-Nov-09 21:17
professionalDaveAuld6-Nov-09 21:17 
QuestionUpdate entries in Database Column. Pin
jeshra2796-Nov-09 0:50
jeshra2796-Nov-09 0:50 
Hi All,
How to UPDATE entries of a column in SQL database ? e.g. I have a database named "clients", with a column "payment", with following entries:

payment
-------
100
200
300


Now I want these values to be updated next time when i calculate the new values that has to updated in the payment column.e.g. new values will be 500, 800, 900.

I have used following commands to update the entries:

cmd = New SqlCommand("Insert Into clients([Payment])Values(@calpay)", con)
cmd.Parameters.AddWithValue("@calpay", PaymentValue)

Where "PaymentValue" are the new values calculated.


Using the above code I found that the values are getting added below the old one, these new values doesnt replace the old values in column... I am getting finally :
payment
-------
100
200
300
500
800
900

Please help me with a piece of code. I think we have to use :
cmd = New SqlCommand(UPDATE clients SET... WHERE...

Kindy suggest me how to go ahead with this?

Thanks
R.S
QuestionPublish application in start-->program list Pin
vijay24826-Nov-09 0:08
vijay24826-Nov-09 0:08 
QuestionLabel Array HELP Pin
PAguilar095-Nov-09 18:20
PAguilar095-Nov-09 18:20 
AnswerRe: Label Array HELP Pin
Christian Graus5-Nov-09 18:57
protectorChristian Graus5-Nov-09 18:57 
AnswerRe: Label Array HELP Pin
dan!sh 5-Nov-09 21:35
professional dan!sh 5-Nov-09 21:35 
GeneralRe: Label Array HELP Pin
PAguilar095-Nov-09 22:42
PAguilar095-Nov-09 22:42 
GeneralRe: Label Array HELP Pin
The Man from U.N.C.L.E.5-Nov-09 22:51
The Man from U.N.C.L.E.5-Nov-09 22:51 
GeneralRe: Label Array HELP Pin
PAguilar095-Nov-09 23:03
PAguilar095-Nov-09 23:03 
GeneralRe: Label Array HELP Pin
Sigurd Johansen6-Nov-09 10:18
Sigurd Johansen6-Nov-09 10:18 
GeneralRe: Label Array HELP Pin
PAguilar096-Nov-09 19:23
PAguilar096-Nov-09 19:23 
GeneralRe: Label Array HELP Pin
Sigurd Johansen7-Nov-09 7:23
Sigurd Johansen7-Nov-09 7:23 
GeneralRe: Label Array HELP Pin
PAguilar097-Nov-09 15:45
PAguilar097-Nov-09 15:45 
GeneralRe: Label Array HELP Pin
DaveAuld6-Nov-09 21:30
professionalDaveAuld6-Nov-09 21:30 
QuestionOutlook Contact Picture Path Problem Pin
dcdhingra5-Nov-09 18:15
dcdhingra5-Nov-09 18:15 
QuestionHelp with Modules-specifically subprocedures Pin
bphoopstar5-Nov-09 18:12
bphoopstar5-Nov-09 18:12 
AnswerRe: Help with Modules-specifically subprocedures Pin
Christian Graus5-Nov-09 19:00
protectorChristian Graus5-Nov-09 19:00 
Questionhow to read data from store procuder in dataset ? Pin
Pitou HORT5-Nov-09 16:41
Pitou HORT5-Nov-09 16:41 
AnswerRe: how to read data from store procuder in dataset ? Pin
Christian Graus5-Nov-09 19:01
protectorChristian Graus5-Nov-09 19:01 

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.