Display of Data in a Table (Grid) Using SQL Objects (VB.net) : SqlConnection « ADO.net Database « ASP.Net






  1. ASP.Net
  2. ADO.net Database
  3. SqlConnection

Display of Data in a Table (Grid) Using SQL Objects (VB.net)

<%@Import Namespace="System.Data" %>
<%@Import Namespace="System.Data.SqlClient" %>

<html>
<body>
<h2>Display of Data in a Table (Grid) Using SQL Objects</h2>

Northwind Employees:
<asp:datagrid   id="dgrEmployees" runat="server" />

<script language="vb" runat="server">
    Sub Page_Load()
        Dim strSQL as string = "SELECT FirstName,LastName FROM Employees;"
        Dim strConnection as String = "server=EWANB;database=Northwind; User Id=sa;password=;"
        
        Dim objDataSet As New DataSet()
        Dim objConnection As New SqlConnection(strConnection)
        
        Dim objDataAdapter As New SqlDataAdapter(strSQL, objConnection)
        
        objDataAdapter.Fill(objDataSet, "Employees")
        
        Dim objDataView As New DataView(objDataSet.Tables("Employees"))
        
        dgrEmployees.DataSource = objDataView
        dgrEmployees.DataBind()   
    End Sub
</script> 
</body> 
</html>








Related examples in the same category

1.Open Sql connection (VB.net)
2.Catch data binding exception (VB.net)
3.Use Trace to debug (VB.net)
4.Setup SqlConnection (C#)