Ado.net Dataset Select using COLLATE

R

Rob W

Greetings,

I want to count the rows where the login and password are the same.

The password is case sensitive, the login isn't as selected from a
pre-populated combo box and can never be changed.

I know I can set collation at table creation time but how do I apply it to
the sql statement below?

At the moment I get the syntax error Syntax error: Missing operand after
'COLLATE' operator.
Dim validuser As Integer = usersDS.Tables(0).Select("Name = '" &
cboLogin.SelectedValue.ToString & "' and password COLLATE
SQL_Latin1_General_CP1_CI_AS = '" & txtPassword.Text & "' ").Count

Thanks

Rob
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Why am I getting ForeignKeyConstraint requires child key value error? 12
FilterExpression with sub-select 1
Select all DataRows of a DataColumn 7
Error when trying to create new SQL Server login via ado.Net 3
Re: Please help with dataset Select syntax 0
Display rows from one table not in another in a dataset 1
ADO.Net Dataset questions 2
"IF" test in SP evals to True and False at same time using DataAdapter.FillSchema() 7

Top