Binaryworld - Binding SQL Data to a DataGrid ... [ ASP.net -> Datagrid ]

The DataGrid control supports a DataSource property that takes an IEnumerable or ICollection, as well as a DataSet. You can use a DataSet by assigning the DefaultView property of a table contained in the DataSet to the name of the table you wish to use within the DataSet. The DefaultView property represents the current state of a table within a DataSet, including any changes which have been made by application code (row deletions or value changes, for example). After setting the DataSource property, you call DataBind() to populate the control.

Click here to copy the following block

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

<html>
<script language="VB" runat="server">

  Sub Page_Load(Sender As Object, E As EventArgs)

    Dim DS As DataSet
    Dim MyConnection As SqlConnection
    Dim MyCommand As SqlDataAdapter

    MyConnection = New SqlConnection("server=(local);database=pubs;Trusted_Connection=yes")
    MyCommand = New SqlDataAdapter("select * from Authors", MyConnection)

    DS = new DataSet()
    MyCommand.Fill(ds, "Authors")

    MyDataGrid.DataSource=ds.Tables("Authors").DefaultView
    MyDataGrid.DataBind()
  End Sub

</script>

<body>

<h3><font face="Verdana">Simple Select to a DataGrid Control</font></h3>

<ASP:DataGrid id="MyDataGrid" runat="server"
  Width="700"
  BackColor="#ccccff"
  BorderColor="black"
  ShowFooter="false"
  CellPadding=3
  CellSpacing="0"
  Font-Name="Verdana"
  Font-Size="8pt"
  HeaderStyle-BackColor="#aaaadd"
  EnableViewState="false"
/>

</body>
</html>