ASP.NET

ASP.NET RSS

Session error in asp net

Please support our ASP.NET advertiser: Intel Parallel Studio Home

Thread Solved

•

Join Date: Jul 2009

Posts: 36

Reputation: chrispaul8676 is an unknown quantity at this point

Solved Threads: 0

chrispaul8676 chrispaul8676 is offline

Offline

Light Poster

Session error in asp net

Jul 6th, 2009

hi,

there , i am coming up with a login page and i am having error when i run the programme. It says 'Invalid attempt to read when no data is present'.

Session("ses_uname") = rdr("FirstName") + " " + rdr("LastName")

Help with Code Tags

(Toggle Plain Text)

Imports System.Data.Sql
Imports System.Data.SqlClient
Imports System.Web
Partial Class _Default
    Inherits System.Web.UI.Page
    Dim str As String = ConfigurationManager.ConnectionStrings("CourierSystemConnectionString").ConnectionString
    Dim con As SqlConnection
    Dim cmd As SqlCommand
    Dim rdr As SqlDataReader
    Dim sql As String
    Dim t As String
    Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
    End Sub
    Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnlogin.Click
        con = New SqlConnection(str)
        con.Open()
        Dim type As String
        type = ddltype.SelectedValue
        If type = "Customer" Then
            sql = "select * from CusRegis_Table where CusID='" + tuname.Text + "' and password2='" + tupass.Text + "'"

        Else
            sql = "select * from StaffRegis_Table where StaffID='" + tuname.Text + "' and Password='" + tupass.Text + "'"
        End If
        cmd = New SqlCommand(sql, con)
        rdr = cmd.ExecuteReader

        If rdr.HasRows Then
            If ddltype.SelectedValue = "Customer" Then
                Session("ses_dname") = rdr("CusFName") + " " + rdr("CusLName")
                Session("ses_uid") = rdr("Cusid")
                Response.Redirect("Home1.aspx")
                'ElseIf 
                '   ddltype.SelectedValue = "Delivery Boy" Then
                '  Session("ses_dname") = rdr("FirstName") + " " + rdr("Lastname")
                ' Session("ses_uid") = rdr("staffid")
                'Session("ses_utype") = rdr("Designation")
                'Response.Redirect("DeliveryBoyDirection.aspx")
            Else
                ddltype.SelectedValue = "DeliveryBoy"
                Session("ses_uname") = rdr("FirstName") + " " + rdr("LastName")                Session("ses_uid") = rdr("staffid")
                Session("ses_utype") = rdr("Designation")
                Response.Redirect("DeliveryBoyDirection.aspx")

            End If
        End If
    End Sub
End Class

Imports System.Data.Sql
Imports System.Data.SqlClient
Imports System.Web
Partial Class _Default
    Inherits System.Web.UI.Page
    Dim str As String = ConfigurationManager.ConnectionStrings("CourierSystemConnectionString").ConnectionString
    Dim con As SqlConnection
    Dim cmd As SqlCommand
    Dim rdr As SqlDataReader
    Dim sql As String
    Dim t As String
    Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
    End Sub
    Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnlogin.Click
        con = New SqlConnection(str)
        con.Open()
        Dim type As String
        type = ddltype.SelectedValue
        If type = "Customer" Then
            sql = "select * from CusRegis_Table where CusID='" + tuname.Text + "' and password2='" + tupass.Text + "'"

        Else
            sql = "select * from StaffRegis_Table where StaffID='" + tuname.Text + "' and Password='" + tupass.Text + "'"
        End If
        cmd = New SqlCommand(sql, con)
        rdr = cmd.ExecuteReader

        If rdr.HasRows Then
            If ddltype.SelectedValue = "Customer" Then
                Session("ses_dname") = rdr("CusFName") + " " + rdr("CusLName")
                Session("ses_uid") = rdr("Cusid")
                Response.Redirect("Home1.aspx")
                'ElseIf 
                '   ddltype.SelectedValue = "Delivery Boy" Then
                '  Session("ses_dname") = rdr("FirstName") + " " + rdr("Lastname")
                ' Session("ses_uid") = rdr("staffid")
                'Session("ses_utype") = rdr("Designation")
                'Response.Redirect("DeliveryBoyDirection.aspx")
            Else
                ddltype.SelectedValue = "DeliveryBoy"
                Session("ses_uname") = rdr("FirstName") + " " + rdr("LastName")                Session("ses_uid") = rdr("staffid")
                Session("ses_utype") = rdr("Designation")
                Response.Redirect("DeliveryBoyDirection.aspx")

            End If
        End If
    End Sub
End Class

•

Join Date: Apr 2009

Posts: 217

Reputation: mail2saion is an unknown quantity at this point

Solved Threads: 31

mail2saion mail2saion is offline

Offline

Posting Whiz in Training

Re: Session error in asp net

Jul 7th, 2009

Include the read method first.

Help with Code Tags

(Toggle Plain Text)

rdr.read();
if(rdr.hasrows)
..............................

MARK AS SOLVED if its help you.

REGARDS
MCTS - Shawpnendu bikash maloroy
http://shawpnendu.blogspot.com

•

Join Date: Jul 2009

Posts: 36

Reputation: chrispaul8676 is an unknown quantity at this point

Solved Threads: 0

chrispaul8676 chrispaul8676 is offline

Offline

Light Poster

Re: Session error in asp net

Jul 8th, 2009

thank you for replying.
I am not sure where to key in the read method

•

Join Date: Jun 2009

Posts: 432

Reputation: Ramesh S will become famous soon enough

Solved Threads: 82

Ramesh S

Offline

Posting Pro in Training

Re: Session error in asp net

Jul 8th, 2009

Just change 'If rdr.HasRows' to 'If rdr.Read()'

Therefore your code should be as follows

Help with Code Tags

(Toggle Plain Text)

If rdr.Read() Then
            If ddltype.SelectedValue = "Customer" Then
                Session("ses_dname") = rdr("CusFName") + " " + rdr("CusLName")
                Session("ses_uid") = rdr("Cusid")
                Response.Redirect("Home1.aspx")
                'ElseIf 
                '   ddltype.SelectedValue = "Delivery Boy" Then
                '  Session("ses_dname") = rdr("FirstName") + " " + rdr("Lastname")
                ' Session("ses_uid") = rdr("staffid")
                'Session("ses_utype") = rdr("Designation")
                'Response.Redirect("DeliveryBoyDirection.aspx")
            Else
                ddltype.SelectedValue = "DeliveryBoy"
                Session("ses_uname") = rdr("FirstName") + " " + rdr("LastName")                Session("ses_uid") = rdr("staffid")
                Session("ses_utype") = rdr("Designation")
                Response.Redirect("DeliveryBoyDirection.aspx")

            End If
        End If

Last edited by Ramesh S; Jul 8th, 2009 at 3:05 am.

•

Join Date: May 2008

Posts: 164

Reputation: dnanetwork has a little shameless behaviour in the past

Solved Threads: 24

dnanetwork dnanetwork is offline

Offline

Junior Poster

Re: Session error in asp net

Jul 10th, 2009

i think you are VB.net...but i'm the C# guy...

i guess you are missing toSting() function which is required...

in your code instead storing the string,you are storing the reader object...

 Help with Code Tags 
 ASP.NET Syntax (Toggle Plain Text) 
string finaltext = rdr["FirstName"].tostring() + "" + rdr["LastName"].toString();
 
Session.add("ses_uname",) = rdr("FirstName") + " " + rdr("LastName")
string finaltext = rdr["FirstName"].tostring() + "" + rdr["LastName"].toString();

Session.add("ses_uname",) = rdr("FirstName") + " " + rdr("LastName")

hope it helps...and if i'm wrong please let me know...

Last edited by peter_budo; Jul 10th, 2009 at 6:26 am. Reason: Keep It Organized - For easy readability, always wrap programming code within posts in [code] (code blocks) and [icode] (inline code) tags.