NOT ABLE TO FETCH DATA FROM SQL DATABASE IN ASP.NET WEB APPLICATION USING VB

ben reitman

Total Post:96

Points:676
Posted by  ben reitman
 784  View(s)
Ratings:
Rate this:

I am using the below code to fetch data from SQL, I am not getting any error but code is not working on button click

 

Dim strSQL As String = String.Empty

strSQL = "SELECT * from jhg"

Using connection As New SqlConnection         (ConfigurationManager.ConnectionStrings("xyz").ConnectionString)

    Dim command As New SqlCommand(strSQL, connection)

    connection.Open()

    reader As SqlDataReader = command.ExecuteReader()

    While reader.Read()

        GridView1.DataSource = reader

    End While

'end connection and using close

  1. Kamlakar Singh

    Post:194

    Points:1396
    Re: Not able to fetch data from sql database in asp.net web application using vb

    I think you have to modify your code as follows,

     

    Dim strSQL As String = String.Empty

    strSQL = "SELECT * from jhg"

    Using connection As New SqlConnection         (ConfigurationManager.ConnectionStrings("xyz").ConnectionString)

        Dim command As New SqlCommand(strSQL, connection)

        connection.Open()

        reader As SqlDataReader = command.ExecuteReader()

     

        DataTable dt = new DataTable();

        dt.Load(reader);

        GridView1.DataSource = dt;

        GridView1.DataBind();

Answer

NEWSLETTER

Enter your email address here always to be updated. We promise not to spam!