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

Datagrid BoundColumn - << VB.NET VERSION >>

Use BoundColumn in a Datagrid

<%@ Page Language="c#" Debug="true" %>
<%@ Import namespace="System.Data" %>
<%@ Import namespace="System.Data.OleDb" %>
<HTML>
<head>
<script language="c#" runat="server">
private void Page_Load(System.Object sender, System.EventArgs e)
{
  OleDbConnection dbConn;
  OleDbDataAdapter myAdapter;
  string sqlCmd;
  string strConn;
  DataSet oDataSet = new DataSet();
  strConn =
    "Provider=Microsoft.Jet.OLEDB.4.0;" +
    "Data Source=" + Server.MapPath("database/utenti.mdb") + ";" +
    "Persist Security Info=False";
  sqlCmd =
    "SELECT " +
    " nome, " +
    " cognome, " +
    " email " +
    " FROM utenti";
  dbConn = new OleDbConnection(strConn);
  myAdapter = new OleDbDataAdapter(sqlCmd, dbConn);
  myAdapter.Fill(oDataSet, "utenti");
  myDatagrid.DataSource = oDataSet.Tables["utenti"].DefaultView;
  myDatagrid.DataBind();
}
</script>
</head>
<body>
<form id="Form1" method="post" runat="server">
<asp:DataGrid id="myDatagrid" runat="server" BorderColor="#CC9966" BorderStyle="None" BorderWidth="1px"
BackColor="White" CellPadding="4" Width="460px" AutoGenerateColumns="False">
<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