How to Compare a TextBox Value to a SQL DataBase

bex · January 23rd, 2009, 09:40 AM

Hi there i need to compare a textbox Value to a SQL databse i am lookinh for one column and once that is confiremed i need to look to the other column in the same row and bind it to a label control.

My DataBase hase 1 table with 2 columns

i have this so far

Code:

ProtectedSub CustomValidator_TextBox1_ServerValidate(ByVal source AsObject, _
ByVal args As System.Web.UI.WebControls.ServerValidateEventArgs) _
Handles CustomValidator_TextBox1.ServerValidate
args.IsValid = True
ForEach drv As DataRowView In SqlDataSource2.Select(DataSourceSelectArguments.Empty)
If drv("Alex").ToString() = args.Value Then
args.IsValid = False
ExitFor
EndIf
Next
If args.IsValid Then
Campaign.Text = ?????
EndIf
EndSub

Thanks

dparsons · January 27th, 2009, 11:49 PM

This is interesting code since you say you need to compare a Textbox value to your database yet there is no reference to a textbox anywhere in your code?

I believe something like this would work for you (I am assuming based off of the code and explination you have provided):

vb Code:

For Each drv As DataRowView In SqlDataSource2.Select(DataSourceSelectArguments.Empty)
If Convert.ToString(drv("Alex").Equals(args.Value) Then
args.IsValid = False
Exit For
End If
'Assumption code
If Convert.ToString(drv("somecolumn").Equals(sometextbox) Then Campaign.Text = Convert.ToString(drv("somecolumn2"))
Next

FYI, there is a chance the code above, as written, has a bug in it. If the first if evaluates to true the For loop will exit before it evaluates the second If statement.

hth
-Doug