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

ASKER CERTIFIED SOLUTION

Neun123

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

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

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

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

sindhuxyz

ASKER

Thanks