Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load Dim dt As New DataTable() Dim strConnString As String = System.Configuration.ConfigurationManager.ConnectionStrings("ApplicationServices").ConnectionString Dim strQuery As String = "select * from Customer_Details" Dim cmd As New SqlCommand(strQuery) Dim con As New SqlConnection(strConnString) Dim sda As New SqlDataAdapter() cmd.CommandType = CommandType.Text cmd.Connection = con Try con.Open() sda.SelectCommand = cmd sda.Fill(dt) Me.GridView1.DataSource = dt Me.GridView1.DataBind() Catch ex As Exception Response.Write(ex.Message) Finally con.Close() sda.Dispose() con.Dispose() dt.Dispose() End Try End Sub
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)