Author: mfrias | Posted on: 7/16/2010 6:23:21 AM | Views : 411

Hi,
I am building an appplication in Flex which shows and lets edit values from a SQL Server DB. To start out, I made a Web Service which verifies the username and password. I hava a simpe table with two columns: username and password

I managed to send values to the web service but I am stuck with the logic to verify that the username is the same as in the DB.
Check out the function. I appreciate any directions or ideas.


Public Function GetDataSet(ByVal username As String, ByVal password As String) As String
Dim result As String = ""
Dim realPswd, realUser As String
realPswd = ""
realUser = ""
Dim dbread As System.Data.SqlClient.SqlDataReader

Try
Dim qString As String = "SELECT username, password FROM CORESETLOGIN1 WHERE username = @username AND password = @password"
Go to the complete details ...