Morpheusweb.it - Risorse per webmaster: script, ASP.NET, C#, Visual Basic .Net, tutorial, asp, javascript, css, php, html, java, ADO, VBScript, forms, frames, Active Server Pages, Dynamic HTML, database, gratis per webmaster e webdesigner

Reader Datagrid - << VB.NET VERSION >>

Pupulate a Datagrid using a Reader

<%@ Import Namespace="System.Data.OleDb" %>
<%@ Import Namespace="System.Data" %>
<HTML>
<script language="C#" runat="server">
protected void Page_Load ( object src, EventArgs e )
{
  OleDbConnection myConn = new OleDbConnection(
    "Provider=Microsoft.Jet.OleDb.4.0; Data Source=" +
    Server.MapPath("database/utenti.mdb"));
  OleDbCommand myCmd = new OleDbCommand("select Nome, Cognome, email from utenti", myConn);
  if (!IsPostBack)
  {
    try
    {
      DataTable dt = new DataTable();
      dt.Columns.Add(new DataColumn("nome"));
      dt.Columns["nome"].DataType = System.Type.GetType("System.String");
      dt.Columns.Add(new DataColumn("cognome"));
      dt.Columns["cognome"].DataType = System.Type.GetType("System.String");
      dt.Columns.Add(new DataColumn("email"));
      dt.Columns["email"].DataType = System.Type.GetType("System.String");
      myConn.Open();
      OleDbDataReader aReader = myCmd.ExecuteReader();
      try
      {
        while (aReader.Read())
        {
          DataRow myDataRow = dt.NewRow();
          myDataRow[0] = aReader["nome"];
          myDataRow[1] = aReader["cognome"];
          myDataRow[2] = aReader["email"];
          dt.Rows.Add(myDataRow);
        }
      }
      finally
      {
        aReader.Close();
      }
      DataView myDataView = new DataView(dt);
      DataGrid1.DataSource = myDataView;
      DataGrid1.DataBind();
    }
    finally
    {
      myConn.Close();
    }
  }
}
</script>
<body>
<form id="Form1" name="Form1" Runat="server">
<asp:DataGrid id="DataGrid1" runat="server" AutoGenerateColumns="False" BorderColor="#CC9966"
BorderStyle="None" BorderWidth="1px" BackColor="White" CellPadding="4">
<FooterStyle ForeColor="#330099" BackColor="#FFFFCC"></FooterStyle>
<SelectedItemStyle Font-Bold="True" ForeColor="#663399" BackColor="#FFCC66"></SelectedItemStyle>
<ItemStyle ForeColor="#330099" BackColor="White"></ItemStyle>
<HeaderStyle Font-Bold="True" ForeColor="#FFFFCC" BackColor="#990000"></HeaderStyle>
<Columns>
<asp:BoundColumn DataField="nome" HeaderText="nome"></asp:BoundColumn>
<asp:BoundColumn DataField="cognome" HeaderText="cognome"></asp:BoundColumn>
<asp:BoundColumn DataField="email" HeaderText="email"></asp:BoundColumn>
</Columns>
<PagerStyle HorizontalAlign="Center" ForeColor="#330099" BackColor="#FFFFCC"></PagerStyle>
</asp:DataGrid></form>
</body>
</HTML>

Download Code...

Page top