Click here to Skip to main content
15,499,289 members
Home / Discussions / Visual Basic
   

Visual Basic

 
GeneralRe: count number of rows in table Pin
peteyshrew16-May-07 5:19
Memberpeteyshrew16-May-07 5:19 
GeneralRe: count number of rows in table Pin
peteyshrew16-May-07 5:34
Memberpeteyshrew16-May-07 5:34 
GeneralRe: count number of rows in table Pin
Dave Kreskowiak16-May-07 5:39
mveDave Kreskowiak16-May-07 5:39 
Questionsyntax error Pin
peteyshrew16-May-07 4:05
Memberpeteyshrew16-May-07 4:05 
AnswerRe: syntax error Pin
andyharman16-May-07 4:53
professionalandyharman16-May-07 4:53 
GeneralRe: syntax error Pin
peteyshrew16-May-07 5:19
Memberpeteyshrew16-May-07 5:19 
QuestionInsert Stored Procedure taking values from vb Help Pin
Vimalsoft(Pty) Ltd16-May-07 4:00
professionalVimalsoft(Pty) Ltd16-May-07 4:00 
AnswerRe: Insert Stored Procedure taking values from vb Help Pin
Dave Kreskowiak16-May-07 5:11
mveDave Kreskowiak16-May-07 5:11 
You already did this. The part you missed is that you didn't do any validation of the data in the textbox's before you assigned the values to your parameters. Your code just assumed that all the data will be valid, all the time.

You have to write code that checks the Text property of each textbox, converts it to the correct datatype expected by your parameters, and verify that each value is within acceptable ranges before you assign those values to the parameters.


A guide to posting questions on CodeProject[^]

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


GeneralRe: Insert Stored Procedure taking values from vb Help Pin
Vimalsoft(Pty) Ltd16-May-07 5:19
professionalVimalsoft(Pty) Ltd16-May-07 5:19 
GeneralRe: Insert Stored Procedure taking values from vb Help [modified] Pin
Vimalsoft(Pty) Ltd16-May-07 5:19
professionalVimalsoft(Pty) Ltd16-May-07 5:19 
GeneralRe: Insert Stored Procedure taking values from vb Help Pin
Dave Kreskowiak16-May-07 5:31
mveDave Kreskowiak16-May-07 5:31 
Questionhow do i edit a selected row or record in sql database through datagrid during runtime? Pin
sathyan_829416-May-07 3:51
Membersathyan_829416-May-07 3:51 
AnswerRe: how do i edit a selected row or record in sql database through datagrid during runtime? Pin
Dave Kreskowiak16-May-07 5:29
mveDave Kreskowiak16-May-07 5:29 
AnswerRe: how do i edit a selected row or record in sql database through datagrid during runtime? Pin
Xandip16-May-07 19:32
MemberXandip16-May-07 19:32 
Questionfitting application screen resolution and size Pin
balakpn16-May-07 3:44
Memberbalakpn16-May-07 3:44 
AnswerRe: fitting application screen resolution and size Pin
Dave Kreskowiak16-May-07 5:26
mveDave Kreskowiak16-May-07 5:26 
GeneralRe: fitting application screen resolution and size Pin
balakpn16-May-07 21:42
Memberbalakpn16-May-07 21:42 
GeneralRe: fitting application screen resolution and size Pin
Dave Kreskowiak17-May-07 3:44
mveDave Kreskowiak17-May-07 3:44 
QuestionHow to convert HTML to Doc, pdf, rtf Pin
Kumaran21cen16-May-07 2:54
MemberKumaran21cen16-May-07 2:54 
AnswerRe: How to convert HTML to Doc, pdf, rtf Pin
andyharman16-May-07 4:59
professionalandyharman16-May-07 4:59 
QuestionLevel Output Meter Pin
mweingart16-May-07 1:13
Membermweingart16-May-07 1:13 
AnswerRe: Level Output Meter Pin
Xandip16-May-07 1:19
MemberXandip16-May-07 1:19 
GeneralRe: Level Output Meter Pin
mweingart16-May-07 1:42
Membermweingart16-May-07 1:42 
AnswerRe: Level Output Meter Pin
Dave Kreskowiak16-May-07 5:17
mveDave Kreskowiak16-May-07 5:17 
QuestionHow do i work with PDF files in vb.net Pin
koolprasad200316-May-07 0:16
professionalkoolprasad200316-May-07 0:16 

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.