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

Question

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

Madhawas · Accepted Answer · 2014-03-10 08:52:22Z

1

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

answered Mar 10, 2014 at 8:52

Madhawas

3911 gold badge3 silver badges16 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

user635545 Over a year ago

while i am trying to use datatable it is showing me an error

Chris L · Accepted Answer · 2014-03-10 08:46:03Z

0

You need to DataBind your GridView after providing the datasource:

GridView1.DataBind();

answered Mar 10, 2014 at 8:46

Chris L

2,2921 gold badge19 silver badges34 bronze badges

Collectives™ on Stack Overflow

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

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related