forum

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

Ask Question

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

Anonymous User 1589 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

asp.net asp.net  database 
Updated on 28-Nov-2014
Anonymous User

Anonymous User

Follow
I am a content writter !

Can you answer this question?

Answer

1 Answers

Anonymous User

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

Liked By