How to bind GridView with sql server database

Question

Hi How to bind GridView with sql server database ?

Satyapriya Nayak · Answer

Hi Nikos 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 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() End Sub End Class Thanks If this post helps you mark it as answer