---
title: "Not able to fetch data from sql database in asp.net web application using vb"  
description: "Not able to fetch data from sql database in asp.net web application using vb"  
author: "Anonymous User"  
published: 2014-11-27  
updated: 2014-11-28  
canonical: https://www.mindstick.com/forum/12710/not-able-to-fetch-data-from-sql-database-in-asp-dot-net-web-application-using-vb  
category: "asp.net"  
tags: ["asp.net", "database"]  
reading_time: 1 minute  

---

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

I am using the below [code](https://yourviews.mindstick.com/view/85458/alan-turing-the-mastermind-behind-cracking-the-enigma-code-during-world-war-ii) to [fetch](https://www.mindstick.com/forum/156159/what-is-google-fetch) [data from SQL](https://www.mindstick.com/forum/12885/how-to-retrieving-data-from-sql-server-and-adding-it-to-arraylist), I am not getting any [error](https://yourviews.mindstick.com/view/88527/fixing-quickbooks-error-4120-reinstalling-vs-repairing) but code is not working on [button click](https://www.mindstick.com/forum/790/form-gets-submiited-twice-on-button-click)

```
Dim strSQL As String = String.EmptystrSQL = "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
```

## Replies

### Reply by Anonymous User

I think you have to modify your code as follows,

```
Dim strSQL As String = String.EmptystrSQL = "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();
```


---

Original Source: https://www.mindstick.com/forum/12710/not-able-to-fetch-data-from-sql-database-in-asp-dot-net-web-application-using-vb

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.