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):
For Each drv As DataRowView In SqlDataSource2.Select(DataSourceSelectArguments.Empty)
If Convert.ToString(drv("Alex").Equals(args.Value) Then
args.IsValid = False
If Convert.ToString(drv("somecolumn").Equals(sometextbox) Then Campaign.Text = Convert.ToString(drv("somecolumn2"))
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.
Wrox online library: Wrox Books 24 x 7
Did someone here help you? Click
on their post!
"Easy is the path to wisdom for those not blinded by themselves."