How to bind GridView with sql server database in VB.NET

Question

Hi, How to bind GridView with sql server database in VB.NET ?

Satyapriya Nayak · Answer

Hi legolas, If this post helps you mark it as answer Thanks

Nikos Rizos · Answer

Hi, See also our recommended articles section on the right side.

Satyapriya Nayak · Answer

Hi legolas,use the following code also see the attachment and please run it. Imports System.Data Imports System.Data.SqlClient Partial Class _Default Inherits System.Web.UI.Page Dim strConnString As String = System.Configuration.ConfigurationManager.ConnectionStrings.Item("ConnectionString").ToString() Dim con As New SqlConnection(strConnString) Dim str As String Dim com As SqlCommand Dim sqlda As SqlDataAdapter Dim ds As DataSet Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click con.Open() str = "select * from employee" com = New SqlCommand(str, con) Dim reader As SqlDataReader reader = com.ExecuteReader() GridView1.DataSource = reader GridView1.DataBind() con.Close() Button1.Visible = False End Sub End Class Thanks If the post helps you please mark it answer.

Mayur Dighe · Answer

This Articles will useful to you..... http://www.vbdotnetheaven.com/UploadFile/ea36c5/5812/?ArticleID=c137462d-bb27-4237-83b5-cf71db2440d9 http://www.vbdotnetheaven.com/UploadFile/anjudidi/2363/ http://www.vbdotnetheaven.com/UploadFile/raj1979/GridViewExamplesForASPNET2001162009055408AM/GridViewExamplesForASPNET20.aspx http://www.vbdotnetheaven.com/UploadFile/rohatash/7995/

How to bind GridView with sql server database in VB.NET

Answers (4)