> 
- Home Page
- > Script C#
- > Script C# Web Controls
- > Reader Datagrid
Reader Datagrid - << VERSIONE VB.NET >>
Popolare un Datagrid utilizzando un 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>
