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. myGridView.DataSource = dtReader;
034. myGridView.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 myGridView_RowDataBound(Object s, GridViewRowEventArgs e)
048. {
049.
050. Label lblCustomerID = (Label)(e.Row.FindControl("lblCustomerID"));
051. if (lblCustomerID != null)
052. {
053. lblCustomerID.Text = (string)DataBinder.Eval(e.Row.DataItem, "CustomerID");
054. }
055.
056.
057. Label lblName = (Label)(e.Row.FindControl("lblName"));
058. if (lblName != null)
059. {
060. lblName.Text = (string)DataBinder.Eval(e.Row.DataItem, "Name");
061. }
062.
063.
064. Label lblEmail = (Label)(e.Row.FindControl("lblEmail"));
065. if (lblEmail != null)
066. {
067. lblEmail.Text = (string)DataBinder.Eval(e.Row.DataItem, "Email");
068. }
069.
070.
071. Label lblCountryCode = (Label)(e.Row.FindControl("lblCountryCode"));
072. if (lblCountryCode != null)
073. {
074. lblCountryCode.Text = (string)DataBinder.Eval(e.Row.DataItem, "CountryCode");
075. }
076.
077.
078. Label lblBudget = (Label)(e.Row.FindControl("lblBudget"));
079. if (lblBudget != null)
080. {
081. lblBudget.Text = DataBinder.Eval(e.Row.DataItem, "Budget").ToString();
082. }
083.
084.
085. Label lblUsed = (Label)(e.Row.FindControl("lblUsed"));
086. if (lblUsed != null)
087. {
088. lblUsed.Text = DataBinder.Eval(e.Row.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 <= myGridView.Rows.Count - 1; i++)
100. {
101. chkCusID = (CheckBox)myGridView.Rows[i].FindControl("chkCustomerID");
102. lblID = (Label)myGridView.Rows[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 - GridView</title>
115.</head>
116.<body>
117.<form id="form1" runat="server">
118.<asp:GridView id="myGridView" runat="server" AutoGenerateColumns="False" onRowDataBound="myGridView_RowDataBound">
119.
120. <Columns>
121.
122. <asp:TemplateField HeaderText="Select">
123. <ItemTemplate>
124. <asp:CheckBox id="chkCustomerID" runat="server"></asp:CheckBox>
125. </ItemTemplate>
126. </asp:TemplateField>
127.
128. <asp:TemplateField HeaderText="CustomerID">
129. <ItemTemplate>
130. <asp:Label id="lblCustomerID" runat="server"></asp:Label>
131. </ItemTemplate>
132. </asp:TemplateField>
133.
134. <asp:TemplateField HeaderText="Name">
135. <ItemTemplate>
136. <asp:Label id="lblName" runat="server"></asp:Label>
137. </ItemTemplate>
138. </asp:TemplateField>
139.
140. <asp:TemplateField HeaderText="Email">
141. <ItemTemplate>
142. <asp:Label id="lblEmail" runat="server"></asp:Label>
143. </ItemTemplate>
144. </asp:TemplateField>
145.
146. <asp:TemplateField HeaderText="CountryCode">
147. <ItemTemplate>
148. <asp:Label id="lblCountryCode" runat="server"></asp:Label>
149. </ItemTemplate>
150. </asp:TemplateField>
151.
152. <asp:TemplateField HeaderText="Budget">
153. <ItemTemplate>
154. <asp:Label id="lblBudget" runat="server"></asp:Label>
155. </ItemTemplate>
156. </asp:TemplateField>
157.
158. <asp:TemplateField HeaderText="Used">
159. <ItemTemplate>
160. <asp:Label id="lblUsed" runat="server"></asp:Label>
161. </ItemTemplate>
162. </asp:TemplateField>
163.
164. </Columns>
165.</asp:GridView>
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>
