Home > DeveloperSection > Forums > Not able to fetch data from sql database in asp.net web application using vb
ben reitman
ben reitman

Total Post:96

Points:676
Posted on    November-27-2014 10:36 PM

 ASP.Net ASP.Net  Database 
Ratings:


 1 Reply(s)
 570  View(s)
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



Kamlakar Singh
Kamlakar Singh

Total Post:194

Points:1396
Posted on    November-28-2014 7:03 AM

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();


Don't want to miss updates? Please click the below button!

Follow MindStick