A
Agnes
I create stored procedure which search the currencyinformation from sql
server
In my vb.net coding, i will pass the following paramter
Dim prmCurr_Code As New SqlParameter("@searchcode",
SqlDbType.VarChar, 3)
Problem , if the user input "USDX" , this parameter will be passed as "USD"
( since I set it as varchar 3), and the query will give me the "correct"
information, It will make a strange bug.
How should I solve it ? , Should I check the length of input currency before
?
Please give some comment
server
In my vb.net coding, i will pass the following paramter
Dim prmCurr_Code As New SqlParameter("@searchcode",
SqlDbType.VarChar, 3)
Problem , if the user input "USDX" , this parameter will be passed as "USD"
( since I set it as varchar 3), and the query will give me the "correct"
information, It will make a strange bug.
How should I solve it ? , Should I check the length of input currency before
?
Please give some comment