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

Anonymous User 2013 27 Nov 2014

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

Ask by Anonymous User

Updated 28 Nov 2014

1 Answers

Anonymous User 28 Nov 2014

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

Markdown for AI

A clean, structured version of this page for AI assistants and LLMs.

Open .md

forum

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

Can you answer this question?

1 Answers