ASP.Net/Data Binding/DataGrid
Содержание
Bind ArrayList to asp datagrid (C#)
<source lang="csharp">
<%@Page Language="C#"%> <html> <body> <asp:datagrid id="dgrTest" runat="server"
forecolor="#000000"
backcolor="#ffffff"
cellpadding="3"
gridlines="none"
width="50%"
font-name="tahoma,arial,sans-serif"
font-size="14px">
<headerstyle forecolor="#ffffff"
backcolor="#808080"
font-name="tahoma,arial,sans-serif"
font-size="12px"
font-bold="true"
wrap="false" />
<itemstyle font-name="tahoma,arial,sans-serif"
font-size="10px" />
<alternatingitemstyle font-name="tahoma,arial,sans-serif"
font-size="16px"
backcolor="#ffff00" />
</asp:datagrid> </body> </html> <script Language="C#" runat="server"> void Page_Load() {
// create an ArrayList of values to bind to
ArrayList arrValues = new ArrayList(4);
arrValues.Add("A");
arrValues.Add("B");
arrValues.Add("C");
arrValues.Add("D");
arrValues.Add("E");
// set the DataSource property of the control to the
// array and bind it to display the values
dgrTest.DataSource = arrValues;
dgrTest.DataBind();
} </script>
</source>
Bind data to asp:datagrid (VB.net)
<source lang="csharp">
<%@ Page Language="vb" %> <%@ Import Namespace="System.Data" %> <html> <head>
<title>Databound Control Example</title>
<script runat="server">
Sub Page_Load()
MyDataGrid.DataSource = CreateData()
MyDataGrid.DataBind()
MyDataList.DataSource = CreateData()
MyDataList.DataBind()
MyRepeater.DataSource = CreateData()
MyRepeater.DataBind()
End Sub
Function CreateData() As DataTable
Dim DT As New DataTable()
Dim Row1, Row2, Row3, Row4 As DataRow
DT.Columns.Add(New DataColumn("name", System.Type.GetType("System.String")))
DT.Columns.Add(New DataColumn("city", System.Type.GetType("System.String")))
Row1 = DT.NewRow()
Row1("name") = "Name 1"
Row1("city") = "City 1"
DT.Rows.Add(Row1)
Row2 = DT.NewRow()
Row2("name") = "Name 2"
Row2("city") = "City 2"
DT.Rows.Add(Row2)
Row3 = DT.NewRow()
Row3("name") = "Name 3"
Row3("city") = "City 3"
DT.Rows.Add(Row3)
Row4 = DT.NewRow()
Row4("name") = "Name 4"
Row4("city") = "City 4"
DT.Rows.Add(Row4)
Return DT
End Function
</script>
</head> <body>
Databound Control Example
<form runat="server">
<asp:table id="MyTable" border="1" cellpadding="5" cellspacing="0" runat="server">
<asp:tablerow runat="server">
<asp:tablecell runat="server">
DataGrid Control:
</asp:tablecell>
<asp:tablecell runat="server">
<asp:datagrid id="MyDataGrid"
allowpaging="true"
allowsorting="true"
alternatingitemstyle-backcolor="LightSkyBlue"
backcolor="Blue"
forecolor="White"
cellpadding="2"
cellspacing="0"
headerstyle-backcolor="DarkBlue"
headerstyle-forecolor="Yellow"
pagerstyle-mode="NumericPages"
pagesize="5"
runat="server"/>
</asp:tablecell>
</asp:tablerow>
<asp:tablerow runat="server">
<asp:tablecell runat="server">
DataList Control:
</asp:tablecell>
<asp:tablecell runat="server">
<asp:datalist id="MyDataList"
alternatingitemstyle-backcolor="LightSkyBlue"
backcolor="Blue"
bordercolor="Black"
cellpadding="2"
cellspacing="0"
forecolor="White"
headerstyle-backcolor="DarkBlue"
headerstyle-forecolor="Yellow"
repeatcolumns="1"
repeatdirection="vertical"
repeatlayout="table"
runat="server">
<headertemplate>
Composers
</headertemplate>
<itemtemplate>
<%# databinder.eval(container.dataitem, "name") %>
</itemtemplate>
</asp:datalist>
</asp:tablecell>
</asp:tablerow>
<asp:tablerow runat="server">
<asp:tablecell runat="server">
Repeater Control:
</asp:tablecell>
<asp:tablecell runat="server">
<asp:repeater id="MyRepeater" runat="server">
<headertemplate>
| Name |
City |
| <%# DataBinder.Eval(Container.DataItem, _ "name") %> | <%# DataBinder.Eval(Container.DataItem, _ "city") %> |
</footertemplate>
</asp:repeater>
</asp:tablecell>
</asp:tablerow>
</asp:table>
</form>
</body> </html>
</source>
Bind hashtable to asp datagrid (C#)
<source lang="csharp">
<%@Page Language="C#"%> <html> <body> <asp:datagrid id="dgrTest" runat="server"
autogeneratecolumns="false"
forecolor="#000000"
backcolor="#ffffff"
cellpadding="3"
gridlines="none"
width="50%"
font-name="tahoma,arial,sans-serif">
<headerstyle forecolor="#ffffff"
backcolor="#808080"
font-name="tahoma,arial,sans-serif"
font-size="12px"
font-bold="true"
wrap="false" />
<itemstyle font-name="tahoma,arial,sans-serif" />
<alternatingitemstyle font-name="tahoma,arial,sans-serif"
backcolor="#ffff00" />
<columns>
<asp:boundcolumn headertext="Key" datafield="Key" dataformatstring="{0}" />
<asp:boundcolumn headertext="Value" datafield="Value" dataformatstring="${0:f2}" />
</columns>
</asp:datagrid> </body> </html> <script Language="C#" runat="server"> void Page_Load() {
// create a HashTable of values to bind to
Hashtable tabValues = new Hashtable(4);
tabValues.Add("A", 49.56);
tabValues.Add("B", 28.33);
tabValues.Add("C", 55);
tabValues.Add("D", 20.74);
tabValues.Add("E", 41.1);
// set the DataSource property of the control to the
// hashtable and bind it to display the values
dgrTest.DataSource = tabValues;
dgrTest.DataBind();
} </script>
</source>
