Solved

how to detect case sensitive? DataView in ADO.NET

Posted on 2004-09-17
2
214 Views
Last Modified: 2008-02-01
Hi, I am using FindRows to find if the Username & Password exist in the database, if so, it should says "Correct" in debug, which indeed it works.

But I have a problem that it is not case-sensitive.

I would like the user to type the exact name & password (case sensitive).

Can anyone help me please? many thanks.


 Dim dvCheck As DataView = New DataView(dsLoginDetails.Tables("LoginDetails"), "", _
                                        "Username, Password", _
                                        DataViewRowState.CurrentRows)

        Dim foundRows() As DataRowView = _
                dvCheck.FindRows(New Object() {txtUsername.Text, txtPassword.Text})

        If foundRows.Length = 0 Then
            Debug.WriteLine("No match found.")
        Else
            Dim myDRV As DataRowView
            For Each myDRV In foundRows
                Debug.WriteLine("Correct")
            Next
        End If
0
Comment
Question by:staines
2 Comments
 
LVL 20

Accepted Solution

by:
ihenry earned 125 total points
ID: 12090159
With this

dsLoginDetails.CaseSensitive = true
or
dsLoginDetails.Tables("LoginDetails").CaseSensitive = true

will affect the case-sensivity comparison in the DataRowView searching using Find or FindRows.
0
 

Author Comment

by:staines
ID: 12090333
Yup it works! thanks!!
0

Featured Post

ScreenConnect 6.0 Free Trial

At ScreenConnect, partner feedback doesn't fall on deaf ears. We collected partner suggestions off of their virtual wish list and transformed them into one game-changing release: ScreenConnect 6.0. Explore all of the extras and enhancements for yourself!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Since .Net 2.0, Visual Basic has made it easy to create a splash screen and set it via the "Splash Screen" drop down in the Project Properties.  A splash screen set in this manner is automatically created, displayed and closed by the framework itsel…
It’s quite interesting for me as I worked with Excel using vb.net for some time. Here are some topics which I know want to share with others whom this might help. First of all if you are working with Excel then you need to Download the Following …
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question