ASP.Net/Data Binding/DataGrid
Bind ArrayList to asp datagrid (C#)
<%@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>
Bind data to asp:datagrid (VB.net)
<%@ 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>
<h1>Databound Control Example</h1>
<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>
<table cellpadding="5" cellspacing="0">
<tr>
<td>Name<hr/></td>
<td>City<hr/></td>
</tr>
</headertemplate>
<itemtemplate>
<tr>
<td><%# DataBinder.Eval(Container.DataItem, _
"name") %></td>
<td><%# DataBinder.Eval(Container.DataItem, _
"city") %></td>
</tr>
</itemtemplate>
<footertemplate>
</table>
</footertemplate>
</asp:repeater>
</asp:tablecell>
</asp:tablerow>
</asp:table>
</form>
</body>
</html>
Bind hashtable to asp datagrid (C#)
<%@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="<font size="4">{0}</font>" />
<asp:boundcolumn headertext="Value" datafield="Value" dataformatstring="<font size="1">${0:f2}</font>" />
</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>