Click here to Skip to main content
15,891,033 members
Home / Discussions / Visual Basic
   

Visual Basic

 
GeneralRe: Problem with datatype in database insert Pin
AAGTHosting28-Mar-08 11:08
AAGTHosting28-Mar-08 11:08 
QuestionLaunching a form from a form Pin
Steven J Jowett28-Mar-08 5:21
Steven J Jowett28-Mar-08 5:21 
GeneralRe: Launching a form from a form Pin
Dave Kreskowiak28-Mar-08 6:45
mveDave Kreskowiak28-Mar-08 6:45 
GeneralRe: Launching a form from a form Pin
Steven J Jowett28-Mar-08 7:18
Steven J Jowett28-Mar-08 7:18 
GeneralPlease Reply - this is urgent Pin
sikhan55528-Mar-08 3:15
sikhan55528-Mar-08 3:15 
GeneralRe: Please Reply - this is urgent Pin
Dave Kreskowiak28-Mar-08 4:37
mveDave Kreskowiak28-Mar-08 4:37 
GeneralUnique Record - this is urgent Pin
sikhan55529-Mar-08 0:35
sikhan55529-Mar-08 0:35 
GeneralRe: Unique Record - this is urgent Pin
Dave Kreskowiak29-Mar-08 17:54
mveDave Kreskowiak29-Mar-08 17:54 
I already did. You don't use a DataReader to get all the records in the table and then search them. You write another query to the database looking for the entered invoice number. If it's there, meaning you get a record back from the database, you tell the user that the invoice already exists. If not, then it's a good invoice number. The SQL statement might look something like:
SELECT invoiceNumber FROM Invoices WHERE invoiceNumber = @userEnteredNumber




A guide to posting questions on CodeProject[^]



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




GeneralRe: Unique Record - this is urgent Pin
AlexeiXX331-Mar-08 5:36
AlexeiXX331-Mar-08 5:36 
GeneralCreate Installer/setup for Excel 2007 Addins Pin
Rupesh Kumar Swami28-Mar-08 2:51
Rupesh Kumar Swami28-Mar-08 2:51 
Questionhow to fasten form load Pin
ahzarmokhli27-Mar-08 23:22
ahzarmokhli27-Mar-08 23:22 
GeneralRe: how to fasten form load Pin
Christian Graus28-Mar-08 1:43
protectorChristian Graus28-Mar-08 1:43 
GeneralRe: how to fasten form load Pin
darkelv28-Mar-08 2:43
darkelv28-Mar-08 2:43 
GeneralRe: how to fasten form load Pin
Dave Kreskowiak28-Mar-08 4:18
mveDave Kreskowiak28-Mar-08 4:18 
QuestionRe: how to fasten form load Pin
CPallini28-Mar-08 9:27
mveCPallini28-Mar-08 9:27 
QuestionSetup making software for VB.net Pin
help as an alias27-Mar-08 20:00
help as an alias27-Mar-08 20:00 
GeneralRe: Setup making software for VB.net Pin
Christian Graus28-Mar-08 1:44
protectorChristian Graus28-Mar-08 1:44 
GeneralRe: Setup making software for VB.net Pin
jzonthemtn28-Mar-08 2:12
jzonthemtn28-Mar-08 2:12 
GeneralShowing rtf file Pin
sjs4u27-Mar-08 19:59
sjs4u27-Mar-08 19:59 
GeneralRe: Showing rtf file Pin
Christian Graus28-Mar-08 1:45
protectorChristian Graus28-Mar-08 1:45 
GeneralGraphs Pin
screwfunk0127-Mar-08 15:11
screwfunk0127-Mar-08 15:11 
GeneralRe: Graphs Pin
Christian Graus27-Mar-08 16:17
protectorChristian Graus27-Mar-08 16:17 
GeneralRe: Graphs Pin
jzonthemtn28-Mar-08 2:11
jzonthemtn28-Mar-08 2:11 
QuestionIs it possible to and edit an excel file from Visual Basic 2005? Pin
Graham Latto27-Mar-08 8:52
Graham Latto27-Mar-08 8:52 
AnswerRe: Is it possible to and edit an excel file from Visual Basic 2005? Pin
Justin Porteous27-Mar-08 9:33
Justin Porteous27-Mar-08 9:33 

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.