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

Total Post:96

Points:676
 1028  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. 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();

      Modified On Apr-07-2018 01:26:39 AM

Answer