Click here to Skip to main content
15,921,837 members
Home / Discussions / Visual Basic
   

Visual Basic

 
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 
GeneralRe: Implementing some broadcast udp protocol Pin
ohad_2924-Feb-07 10:28
ohad_2924-Feb-07 10:28 
GeneralRe: Implementing some broadcast udp protocol Pin
nlarson1124-Feb-07 15:10
nlarson1124-Feb-07 15:10 
QuestionMemory of String Pin
Kumaran21cen23-Feb-07 2:40
Kumaran21cen23-Feb-07 2:40 
AnswerRe: Memory of String Pin
Colin Angus Mackay23-Feb-07 4:20
Colin Angus Mackay23-Feb-07 4:20 
Questionsearch for a word inside a .doc file Pin
digitaldxb23-Feb-07 1:19
digitaldxb23-Feb-07 1:19 
AnswerRe: search for a word inside a .doc file Pin
Dave Kreskowiak23-Feb-07 5:48
mveDave Kreskowiak23-Feb-07 5:48 
GeneralRe: search for a word inside a .doc file Pin
digitaldxb23-Feb-07 6:55
digitaldxb23-Feb-07 6:55 
GeneralRe: search for a word inside a .doc file Pin
Dave Kreskowiak23-Feb-07 7:19
mveDave Kreskowiak23-Feb-07 7:19 
QuestionItem index Pin
david bagaturia23-Feb-07 0:48
david bagaturia23-Feb-07 0:48 
AnswerRe: Data type problem Pin
Colin Angus Mackay23-Feb-07 1:02
Colin Angus Mackay23-Feb-07 1:02 
AnswerRe: Item index Pin
Colin Angus Mackay23-Feb-07 1:56
Colin Angus Mackay23-Feb-07 1:56 
GeneralRe: Item index Pin
david bagaturia23-Feb-07 2:21
david bagaturia23-Feb-07 2:21 
GeneralRe: Item index Pin
Colin Angus Mackay23-Feb-07 4:23
Colin Angus Mackay23-Feb-07 4:23 

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.