Hello to all
My problem is :
i am using data reader to read values from datatable which have two fields Username and Password. when i match my textbox values to table values, datareader takes datatable value as "text " i.e including all the length of that field which cause always non matching. i want that it should not take spaces and whole length of field just the values.
i am writing the code i am using and marking the problem.

CODE:

Dim sqlSelect As String

        Dim strUserName, strPassword As String
        strUserName = txtUserName.Text
        strPassword = txtPassword.Text
        sqlSelect = "Select * from Login"
        Dim cmd As SqlCommand
        Dim oDataReader As SqlDataReader
        cn.Open()
        cmd = New SqlCommand(sqlSelect, cn)
        cmd.CommandType = CommandType.Text
        cmd.Connection = cn
        oDataReader = cmd.ExecuteReader()
        While oDataReader.Read()
            Dim dbUserName As String
            Dim dbPassword As String
            dbUserName = oDataReader("UserName").ToString()
//This dbusername getting the Value "test ". but it should get "test" only.
            dbPassword = oDataReader("Password")

                 If (dbUserName = strUserName) Then
                If(dbPassword = strPassword) Then
                Response.Redirect("ViewProductUsers.aspx")

            End If
            End If
        End While
END CODE

Regards,



thanks......

__________________
thanks......

Hi there...

a couple of things:

This way of read user is no a good one.. what if you have 1000 users??? you will read all the table to see if there are a matching user?? better try to get the user directly from the database (do a Sql passing the user and password.. and please use parameters to avoid an sql injection)...

The problem with the fields filled with spaces is probably a database problem, witch database are you using and what is the field definition?

Replace response.redirect with server.transfer... redirect cause an unnecessary round trip to the client.

HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========
My programs achieved a new certification (can you say the same?):
WORKS ON MY MACHINE
http://www.codinghorror.com/blog/archives/000818.html
================================================== =========

hi
thanks for your valuable suggestions
i will implement that.
rather i solve my problem my appliying trim function at the end i.e
   .................ToString().Trim()

Regards,
Munish

thanks......