Error while reading values from database

See more:

VB

ASP.NET

Hi all...

I am creating a small website which takes user_name and password and after authentication showing its profile page.

I used SQL Server2005 as backend to check user_name and password and reading user id from database.

Now after authentication, in profile page, when I'm trying to load the profile it give some error message.(There were no such error before I tried to login)

The error message is :
The conversion of the nvarchar value '02357092887' overflowed an int column. Maximum integer value exceeded.

where '02357092887' is the uid of user.

I wrote following code in profile page to load profile :

Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
        
dim uid=Convert.ToString(Request.QueryString("uid"))

        conClass.Connect() 'Opening database connection.

        Dim sql As String = "select fname,gender,dob from login where uid=" & uid 
        Dim cmd As New SqlCommand(sql, conClass.con) 
        Dim reader As SqlDataReader = cmd.ExecuteReader 
        While reader.Read   'This line shows error.
            lblFname.Text = reader.GetString(0)
            Page.Title = reader.GetString(0) 
            lblGender.Text = reader.GetString(1) 
            lblDOB.Text = reader.GetString(2)
        End While
        reader.Close()

End Sub

suggest me what should I do.

Thanks.

Gagan