Avatar of sindhuxyz
sindhuxyz
 asked on

asp.net chrome problem

Hi,

I am facing very strange case. Below code return data in firefox, safari, IE but always return nothing(zero row) to chrome. What can be issue with chrome. It is working and returning data in all other browsers.


Dim sqlconn As New SqlConnection(ConnectionString)
        Using cmd As New SqlCommand("spGetUserStatus", sqlconn)
            cmd.CommandType = CommandType.StoredProcedure
            cmd.Parameters.Add("@email", SqlDbType.VarChar).Value = email
            
            Try
                sqlconn.Open()
            Catch ex As Exception

            End Try
            Dim dr As SqlDataReader = cmd.ExecuteReader(CommandBehavior.CloseConnection)
            Dim dt As New DataTable()
            dt.Load(dr)

        End Using

Open in new window

ASP.NET.NET ProgrammingVisual Basic.NET

Avatar of undefined
Last Comment
sindhuxyz

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Neun123

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
sindhuxyz

ASKER
I checked using debug, till line 11th


            Dim dr As SqlDataReader = cmd.ExecuteReader(CommandBehavior.CloseConnection)

sqlcommand had all parameters correct and values as well. When it executed sqldatareader had "HasRows" as false. I do not know to to track it. Any advise?

Thanks
SOLUTION
Neun123

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
disrupt

What are you using to display your data?
disrupt

If you are using a required field validator check this out

http://dotnetguts.blogspot.com/2009/05/dropdownlist-autopostback-problem-with.html


Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy
sindhuxyz

ASKER
Thanks