Click here to Skip to main content
15,908,166 members
Home / Discussions / Visual Basic
   

Visual Basic

 
GeneralRe: Caret Size Pin
TwoFaced24-Feb-07 12:54
TwoFaced24-Feb-07 12:54 
GeneralRe: Caret Size Pin
Anybloodyid24-Feb-07 22:47
Anybloodyid24-Feb-07 22:47 
GeneralRe: Caret Size Pin
TwoFaced24-Feb-07 23:17
TwoFaced24-Feb-07 23:17 
GeneralRe: Caret Size Pin
Anybloodyid25-Feb-07 0:50
Anybloodyid25-Feb-07 0:50 
Questionincluiding calculator in my vb.net application Pin
manni_n23-Feb-07 7:04
manni_n23-Feb-07 7:04 
AnswerRe: incluiding calculator in my vb.net application Pin
Dave Kreskowiak23-Feb-07 7:33
mveDave Kreskowiak23-Feb-07 7:33 
GeneralRe: incluiding calculator in my vb.net application [modified] Pin
manni_n23-Feb-07 8:10
manni_n23-Feb-07 8:10 
GeneralRe: incluiding calculator in my vb.net application Pin
Dave Kreskowiak23-Feb-07 8:29
mveDave Kreskowiak23-Feb-07 8:29 
GeneralRe: incluiding calculator in my vb.net application Pin
manni_n23-Feb-07 8:32
manni_n23-Feb-07 8:32 
GeneralRe: incluiding calculator in my vb.net application Pin
Christian Graus23-Feb-07 10:04
protectorChristian Graus23-Feb-07 10:04 
GeneralRe: incluiding calculator in my vb.net application Pin
manni_n23-Feb-07 12:35
manni_n23-Feb-07 12:35 
GeneralRe: incluiding calculator in my vb.net application Pin
Vikash Yadav23-Feb-07 22:24
Vikash Yadav23-Feb-07 22:24 
GeneralRe: incluiding calculator in my vb.net application Pin
manni_n24-Feb-07 1:01
manni_n24-Feb-07 1:01 
Questionconversion from vb.net to vb Pin
manni_n23-Feb-07 7:01
manni_n23-Feb-07 7:01 
AnswerRe: conversion from vb.net to vb Pin
Dave Kreskowiak23-Feb-07 7:31
mveDave Kreskowiak23-Feb-07 7:31 
Questionvb.net error Pin
7prince23-Feb-07 6:02
7prince23-Feb-07 6:02 
AnswerRe: vb.net error Pin
kubben23-Feb-07 6:07
kubben23-Feb-07 6:07 
GeneralRe: vb.net error Pin
7prince23-Feb-07 6:18
7prince23-Feb-07 6:18 
GeneralRe: vb.net error Pin
kubben23-Feb-07 6:47
kubben23-Feb-07 6:47 
GeneralRe: vb.net error Pin
7prince23-Feb-07 6:58
7prince23-Feb-07 6:58 
AnswerRe: vb.net error Pin
Dave Kreskowiak23-Feb-07 7:28
mveDave Kreskowiak23-Feb-07 7:28 
I told you before, you don't need all this code.
You're unncessarily reading the database into a DataSet, selecting the records that you've already selected in the SQL SELECT statement, modifying the data and (trying to) write the data back. You don't have to do this.

Here a hint for the SQL statement you should be using:
UPDATE [Caller Records] SET FirstName=@FirstName, LastName=@LastName,
         CallerPhone=@CallerPhone, HospitalNumber=@HospitalNumber,
         Type=@Type WHERE RecordNo=@RecordNumber

All of the words preceded with an "@" symbol are named parameters that you fill in with the data from your textbox's. You don't have to retrieve anything from the database to do what you want to do.

You can find more information on parameterized queries here[^].


Dave Kreskowiak
Microsoft MVP - Visual Basic


QuestionAdding listbox items to an Access DB Pin
China-Gary23-Feb-07 6:00
China-Gary23-Feb-07 6:00 
AnswerRe: Adding listbox items to an Access DB Pin
JUNEYT23-Feb-07 6:50
JUNEYT23-Feb-07 6:50 
QuestionImplementing some broadcast udp protocol Pin
ohad_2923-Feb-07 3:30
ohad_2923-Feb-07 3:30 
AnswerRe: Implementing some broadcast udp protocol Pin
nlarson1123-Feb-07 7:55
nlarson1123-Feb-07 7:55 

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.