001.
<%@ Page Language=
"C#"
Debug=
"true"
%>
002.
<%@ import Namespace=
"System.Data"
%>
003.
<%@ import Namespace=
"System.Data.OleDb"
%>
004.
<script runat=
"server"
>
005.
006.
OleDbConnection objConn;
007.
OleDbCommand objCmd;
008.
009.
void
Page_Load(
object
sender,EventArgs e)
010.
{
011.
String strConnString;
012.
strConnString =
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source="
+
013.
Server.MapPath(
"database/mydatabase.mdb"
) +
";"
;
014.
objConn =
new
OleDbConnection(strConnString);
015.
objConn.Open();
016.
017.
if
(!Page.IsPostBack)
018.
{
019.
BindData();
020.
}
021.
}
022.
023.
void
BindData()
024.
{
025.
String strSQL;
026.
strSQL =
"SELECT * FROM customer"
;
027.
028.
OleDbDataReader dtReader;
029.
objCmd =
new
OleDbCommand(strSQL, objConn);
030.
dtReader = objCmd.ExecuteReader();
031.
032.
033.
myDataGrid.DataSource = dtReader;
034.
myDataGrid.DataBind();
035.
036.
dtReader.Close();
037.
dtReader =
null
;
038.
039.
}
040.
041.
void
Page_UnLoad()
042.
{
043.
objConn.Close();
044.
objConn =
null
;
045.
}
046.
047.
void
myDataGrid_ItemDataBound(Object sender, DataGridItemEventArgs e)
048.
{
049.
050.
Label lblCustomerID = (Label)(e.Item.FindControl(
"lblCustomerID"
));
051.
if
(lblCustomerID !=
null
)
052.
{
053.
lblCustomerID.Text = (
string
)DataBinder.Eval(e.Item.DataItem,
"CustomerID"
);
054.
}
055.
056.
057.
Label lblName = (Label)(e.Item.FindControl(
"lblName"
));
058.
if
(lblName !=
null
)
059.
{
060.
lblName.Text = (
string
)DataBinder.Eval(e.Item.DataItem,
"Name"
);
061.
}
062.
063.
064.
Label lblEmail = (Label)(e.Item.FindControl(
"lblEmail"
));
065.
if
(lblEmail !=
null
)
066.
{
067.
lblEmail.Text = (
string
)DataBinder.Eval(e.Item.DataItem,
"Email"
);
068.
}
069.
070.
071.
Label lblCountryCode = (Label)(e.Item.FindControl(
"lblCountryCode"
));
072.
if
(lblCountryCode !=
null
)
073.
{
074.
lblCountryCode.Text = (
string
)DataBinder.Eval(e.Item.DataItem,
"CountryCode"
);
075.
}
076.
077.
078.
Label lblBudget = (Label)(e.Item.FindControl(
"lblBudget"
));
079.
if
(lblBudget !=
null
)
080.
{
081.
lblBudget.Text = DataBinder.Eval(e.Item.DataItem,
"Budget"
).ToString();
082.
}
083.
084.
085.
Label lblUsed = (Label)(e.Item.FindControl(
"lblUsed"
));
086.
if
(lblUsed !=
null
)
087.
{
088.
lblUsed.Text = DataBinder.Eval(e.Item.DataItem,
"Used"
).ToString();
089.
}
090.
}
091.
092.
093.
void
Button1_Click(
object
sender,EventArgs e)
094.
{
095.
CheckBox chkCusID;
096.
Label lblID;
097.
int
i;
098.
lblText.Text =
""
;
099.
for
( i = 0; i <= myDataGrid.Items.Count - 1; i++)
100.
{
101.
chkCusID = (CheckBox)myDataGrid.Items[i].FindControl(
"chkCustomerID"
);
102.
lblID = (Label)myDataGrid.Items[i].FindControl(
"lblCustomerID"
);
103.
if
(chkCusID.Checked)
104.
{
105.
106.
this
.lblText.Text =
this
.lblText.Text +
"<br>"
+ lblID.Text;
107.
}
108.
}
109.
}
110.
111.
</script>
112.
<html>
113.
<head>
114.
<title>ThaiCreate.Com ASP.NET - DataGrid</title>
115.
</head>
116.
<body>
117.
<form id=
"form1"
runat=
"server"
>
118.
<asp:DataGrid id=
"myDataGrid"
runat=
"server"
AutoGenerateColumns=
"False"
onItemDataBound=
"myDataGrid_ItemDataBound"
>
119.
120.
<Columns>
121.
122.
<asp:TemplateColumn HeaderText=
"Select"
>
123.
<ItemTemplate>
124.
<asp:CheckBox id=
"chkCustomerID"
runat=
"server"
></asp:CheckBox>
125.
</ItemTemplate>
126.
</asp:TemplateColumn>
127.
128.
<asp:TemplateColumn HeaderText=
"CustomerID"
>
129.
<ItemTemplate>
130.
<asp:Label id=
"lblCustomerID"
runat=
"server"
></asp:Label>
131.
</ItemTemplate>
132.
</asp:TemplateColumn>
133.
134.
<asp:TemplateColumn HeaderText=
"Name"
>
135.
<ItemTemplate>
136.
<asp:Label id=
"lblName"
runat=
"server"
></asp:Label>
137.
</ItemTemplate>
138.
</asp:TemplateColumn>
139.
140.
<asp:TemplateColumn HeaderText=
"Email"
>
141.
<ItemTemplate>
142.
<asp:Label id=
"lblEmail"
runat=
"server"
></asp:Label>
143.
</ItemTemplate>
144.
</asp:TemplateColumn>
145.
146.
<asp:TemplateColumn HeaderText=
"CountryCode"
>
147.
<ItemTemplate>
148.
<asp:Label id=
"lblCountryCode"
runat=
"server"
></asp:Label>
149.
</ItemTemplate>
150.
</asp:TemplateColumn>
151.
152.
<asp:TemplateColumn HeaderText=
"Budget"
>
153.
<ItemTemplate>
154.
<asp:Label id=
"lblBudget"
runat=
"server"
></asp:Label>
155.
</ItemTemplate>
156.
</asp:TemplateColumn>
157.
158.
<asp:TemplateColumn HeaderText=
"Used"
>
159.
<ItemTemplate>
160.
<asp:Label id=
"lblUsed"
runat=
"server"
></asp:Label>
161.
</ItemTemplate>
162.
</asp:TemplateColumn>
163.
164.
</Columns>
165.
</asp:DataGrid>
166.
<br />
167.
<asp:Button id=
"Button1"
onclick=
"Button1_Click"
runat=
"server"
Text=
"Submit"
></asp:Button>
168.
<hr />
169.
<asp:Label id=
"lblText"
runat=
"server"
></asp:Label>
170.
</form>
171.
</body>
172.
</html>