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. if(!Page.IsPostBack)
009. {
010. BindData();
011. }
012. }
013.
014. void BindData()
015. {
016. DataTable dt;
017.
018.
019. dt = CreateDsToDt();
020.
021.
022.
023.
024.
025.
026.
027.
028.
029.
030.
031.
032.
033. myFormView.DataSource = dt;
034. myFormView.DataBind();
035. }
036.
037.
038. protected DataTable CreateDataTable()
039. {
040. System.Data.OleDb.OleDbConnection objConn = new System.Data.OleDb.OleDbConnection();
041. System.Data.OleDb.OleDbDataAdapter dtAdapter = new System.Data.OleDb.OleDbDataAdapter();
042. DataTable dt = new DataTable();
043.
044.
045. String strConnString;
046. strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" +
047. Server.MapPath("database/mydatabase.mdb")+";Jet OLEDB:Database Password=;";
048. objConn = new System.Data.OleDb.OleDbConnection(strConnString);
049. objConn.Open();
050.
051. String strSQL;
052. strSQL = "SELECT * FROM gallery";
053.
054. dtAdapter = new System.Data.OleDb.OleDbDataAdapter(strSQL, objConn);
055. dtAdapter.Fill(dt);
056.
057. dtAdapter = null;
058.
059. objConn.Close();
060. objConn = null;
061.
062. return dt;
063.
064. }
065.
066.
067. protected DataSet CreateDataSet()
068. {
069. System.Data.OleDb.OleDbConnection objConn = new System.Data.OleDb.OleDbConnection();
070. System.Data.OleDb.OleDbCommand objCmd = new System.Data.OleDb.OleDbCommand();
071. System.Data.OleDb.OleDbDataAdapter dtAdapter = new System.Data.OleDb.OleDbDataAdapter();
072.
073. DataSet ds= new DataSet();
074. String strConnString,strSQL;
075.
076. strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" +
077. Server.MapPath("database/mydatabase.mdb")+";Jet OLEDB:Database Password=;";
078.
079. strSQL = "SELECT * FROM gallery ";
080. objConn.ConnectionString = strConnString;
081.
082. objCmd.Connection = objConn;
083. objCmd.CommandText = strSQL;
084. objCmd.CommandType = CommandType.Text;
085.
086. dtAdapter.SelectCommand = objCmd;
087.
088. dtAdapter.Fill(ds);
089.
090. dtAdapter = null;
091. objConn.Close();
092. objConn = null;
093.
094. return ds;
095.
096. }
097.
098.
099.
100. protected DataTable CreateDsToDt()
101. {
102. System.Data.OleDb.OleDbConnection objConn = new System.Data.OleDb.OleDbConnection();
103. System.Data.OleDb.OleDbCommand objCmd = new System.Data.OleDb.OleDbCommand();
104. System.Data.OleDb.OleDbDataAdapter dtAdapter = new System.Data.OleDb.OleDbDataAdapter();
105.
106. DataSet ds = new DataSet();
107. DataTable dt;
108. String strConnString,strSQL;
109.
110.
111. strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" +
112. Server.MapPath("database/mydatabase.mdb")+";Jet OLEDB:Database Password=;";
113. strSQL = "SELECT * FROM gallery";
114.
115. objConn.ConnectionString = strConnString;
116.
117. objCmd.Connection = objConn;
118. objCmd.CommandText = strSQL;
119. objCmd.CommandType = CommandType.Text;
120.
121. dtAdapter.SelectCommand = objCmd;
122.
123. dtAdapter.Fill(ds);
124. dt = ds.Tables[0];
125.
126. dtAdapter = null;
127. objConn.Close();
128. objConn = null;
129.
130. return dt;
131.
132. }
133.
134.
135.
136. protected DataTable DataTableRows()
137. {
138. DataTable dt = new DataTable();
139. DataRow dr;
140.
141.
142. dt.Columns.Add("GalleryID");
143. dt.Columns.Add("GalleryName");
144. dt.Columns.Add("Picture");
145.
146.
147. dr = dt.NewRow();
148. dr["GalleryID"] = "1";
149. dr["GalleryName"] = "My Picture 1";
150. dr["Picture"] = "DSC01683.jpg";
151. dt.Rows.Add(dr);
152.
153.
154. dr = dt.NewRow();
155. dr["GalleryID"] = "2";
156. dr["GalleryName"] = "My Picture 2";
157. dr["Picture"] = "DSC01719.jpg";
158. dt.Rows.Add(dr);
159.
160.
161. dr = dt.NewRow();
162. dr["GalleryID"] = "3";
163. dr["GalleryName"] = "My Picture 3";
164. dr["Picture"] = "DSC01805.jpg";
165. dt.Rows.Add(dr);
166.
167.
168. dr = dt.NewRow();
169. dr["GalleryID"] = "4";
170. dr["GalleryName"] = "My Picture 4";
171. dr["Picture"] = "DSC01806.jpg";
172. dt.Rows.Add(dr);
173.
174. return dt;
175.
176. }
177.
178. void myFormView_DataBound(Object sender, System.EventArgs e)
179. {
180.
181.
182. Image Image1 = (Image)(myFormView.FindControl("Image1"));
183. if(Image1 != null)
184. {
185. Image1.ImageUrl = "images/"+(string)DataBinder.Eval(myFormView.DataItem, "Picture");
186. Image1.Attributes.Add("OnClick", "window.open('images/"+(string)DataBinder.Eval(myFormView.DataItem, "Picture")+"')");
187. Image1.Style.Add("cursor","hand");
188. Image1.ToolTip = (string)DataBinder.Eval(myFormView.DataItem, "GalleryName");
189. }
190.
191.
192. Label lblGalleryName = (Label)(myFormView.FindControl("lblGalleryName"));
193. if(lblGalleryName != null)
194. {
195. lblGalleryName.Text = (string)DataBinder.Eval(myFormView.DataItem, "GalleryName");
196. }
197.
198. }
199.
200. void ShowPageCommand(Object sender , FormViewPageEventArgs e)
201. {
202. myFormView.PageIndex = e.NewPageIndex;
203. BindData();
204. }
205.
206.</script>
207.<html>
208.<head>
209.<title>ThaiCreate.Com ASP.NET - FormView</title>
210.</head>
211.<body>
212. <form id="form1" runat="server">
213. <asp:FormView id="myFormView" runat="server"
214. OnDataBound="myFormView_DataBound"
215. OnPageIndexChanging="ShowPageCommand"
216. AllowPaging="True">
217. <ItemTemplate>
218. <table width="500" cellpadding="5" border="0">
219. <tr>
220. <td valign="top" align="center">
221. <asp:Image id="Image1" runat="server"/>
222. <br />
223. <h2><asp:Label id="lblGalleryName" runat="server"></asp:Label></h2>
224. </td>
225. </tr>
226. </table>
227. </ItemTemplate>
228. </asp:FormView>
229. </form>
230.</body>
231.</html>
C#
ช่วยกันสนับสนุนรักษาเว็บไซต์ความรู้แห่งนี้ไว้ด้วยการสนับสนุน 
