001.<%@ Import Namespace="System.Data"%>
002.<%@ Import Namespace="System.Data.OleDb"%>
003.<%@ Page Language="C#" Debug="true" %>
004.<script runat="server">
005.
006. void Page_Load(object sender,EventArgs e)
007. {
008. DataTable dt;
009.
010.
011. dt = CreateDsToDt();
012.
013.
014.
015.
016.
017.
018.
019.
020.
021.
022.
023.
024.
025. myGridView.DataSource = dt;
026. myGridView.DataBind();
027. }
028.
029.
030.
031.
032. protected DataTable CreateDataTable()
033. {
034. System.Data.OleDb.OleDbConnection objConn = new System.Data.OleDb.OleDbConnection();
035. System.Data.OleDb.OleDbDataAdapter dtAdapter = new System.Data.OleDb.OleDbDataAdapter();
036. DataTable dt = new DataTable();
037.
038.
039. String strConnString;
040. strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" +
041. Server.MapPath("database/mydatabase.mdb")+";Jet OLEDB:Database Password=;";
042. objConn = new System.Data.OleDb.OleDbConnection(strConnString);
043. objConn.Open();
044.
045. String strSQL;
046. strSQL = "SELECT * FROM customer";
047.
048. dtAdapter = new System.Data.OleDb.OleDbDataAdapter(strSQL, objConn);
049. dtAdapter.Fill(dt);
050.
051. dtAdapter = null;
052.
053. objConn.Close();
054. objConn = null;
055.
056. return dt;
057.
058. }
059.
060.
061. protected DataSet CreateDataSet()
062. {
063. System.Data.OleDb.OleDbConnection objConn = new System.Data.OleDb.OleDbConnection();
064. System.Data.OleDb.OleDbCommand objCmd = new System.Data.OleDb.OleDbCommand();
065. System.Data.OleDb.OleDbDataAdapter dtAdapter = new System.Data.OleDb.OleDbDataAdapter();
066.
067. DataSet ds= new DataSet();
068. String strConnString,strSQL;
069.
070. strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" +
071. Server.MapPath("database/mydatabase.mdb")+";Jet OLEDB:Database Password=;";
072.
073. strSQL = "SELECT * FROM customer ";
074. objConn.ConnectionString = strConnString;
075.
076. objCmd.Connection = objConn;
077. objCmd.CommandText = strSQL;
078. objCmd.CommandType = CommandType.Text;
079.
080. dtAdapter.SelectCommand = objCmd;
081.
082. dtAdapter.Fill(ds);
083.
084. dtAdapter = null;
085. objConn.Close();
086. objConn = null;
087.
088. return ds;
089.
090. }
091.
092.
093. protected DataTable CreateDsToDt()
094. {
095. System.Data.OleDb.OleDbConnection objConn = new System.Data.OleDb.OleDbConnection();
096. System.Data.OleDb.OleDbCommand objCmd = new System.Data.OleDb.OleDbCommand();
097. System.Data.OleDb.OleDbDataAdapter dtAdapter = new System.Data.OleDb.OleDbDataAdapter();
098.
099. DataSet ds = new DataSet();
100. DataTable dt;
101. String strConnString,strSQL;
102.
103.
104. strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" +
105. Server.MapPath("database/mydatabase.mdb")+";Jet OLEDB:Database Password=;";
106. strSQL = "SELECT * FROM customer";
107.
108. objConn.ConnectionString = strConnString;
109.
110. objCmd.Connection = objConn;
111. objCmd.CommandText = strSQL;
112. objCmd.CommandType = CommandType.Text;
113.
114. dtAdapter.SelectCommand = objCmd;
115.
116. dtAdapter.Fill(ds);
117. dt = ds.Tables[0];
118.
119. dtAdapter = null;
120. objConn.Close();
121. objConn = null;
122.
123. return dt;
124.
125. }
126.
127.
128.
129.
130. protected DataTable DataTableRows()
131. {
132. DataTable dt = new DataTable();
133. DataRow dr;
134.
135.
136. dt.Columns.Add("CustomerID");
137. dt.Columns.Add("Name");
138. dt.Columns.Add("Email");
139. dt.Columns.Add("CountryCode");
140. dt.Columns.Add("Budget");
141. dt.Columns.Add("Used");
142.
143.
144. dr = dt.NewRow();
145. dr["CustomerID"] = "C001";
146. dr["Name"] = "Win Weerachai";
147. dr["Email"] = "win.weerachai@thaicreate.com";
148. dr["CountryCode"] = "TH";
149. dr["Budget"] = "1000000";
150. dr["Used"] = "600000";
151. dt.Rows.Add(dr);
152.
153.
154. dr = dt.NewRow();
155. dr["CustomerID"] = "C002";
156. dr["Name"] = "John Smith";
157. dr["Email"] = "john.smith@thaicreate.com";
158. dr["CountryCode"] = "EN";
159. dr["Budget"] = "2000000";
160. dr["Used"] = "800000";
161. dt.Rows.Add(dr);
162.
163.
164. dr = dt.NewRow();
165. dr["CustomerID"] = "C003";
166. dr["Name"] = "Jame Born";
167. dr["Email"] = "jame.born@thaicreate.com";
168. dr["CountryCode"] = "US";
169. dr["Budget"] = "3000000";
170. dr["Used"] = "600000";
171. dt.Rows.Add(dr);
172.
173.
174. dr = dt.NewRow();
175. dr["CustomerID"] = "C004";
176. dr["Name"] = "Chalee Angel";
177. dr["Email"] = "chalee.angel@thaicreate.com";
178. dr["CountryCode"] = "US";
179. dr["Budget"] = "4000000";
180. dr["Used"] = "100000";
181. dt.Rows.Add(dr);
182.
183. return dt;
184. }
185.
186.</script>
187.<html>
188.<head>
189.<title>ThaiCreate.Com ASP.NET - GridView</title>
190.</head>
191.<body>
192. <form id="form1" runat="server">
193. <asp:GridView id="myGridView" runat="server">
194. </asp:GridView>
195. </form>
196.</body>
197.</html>
C#
ช่วยกันสนับสนุนรักษาเว็บไซต์ความรู้แห่งนี้ไว้ด้วยการสนับสนุน 
