01.using System;
02.using System.Data;
03.using System.Configuration;
04.using System.Collections;
05.using System.Web;
06.using System.Web.Security;
07.using System.Web.UI;
08.using System.Web.UI.WebControls;
09.using System.Web.UI.WebControls.WebParts;
10.using System.Web.UI.HtmlControls;
11.using MySql.Data.MySqlClient;
12.
13.public partial class FormView1 : System.Web.UI.Page
14.{
15. protected void Page_Load(object sender, EventArgs e)
16. {
17. BindData();
18. }
19.
20. protected void BindData()
21. {
22. MySqlConnection objConn;
23. MySqlCommand objCmd;
24. MySqlDataAdapter dtAdapter = new MySqlDataAdapter();
25. String strConnString;
26. strConnString = "Server=localhost;User Id=root; Password=root; Database=mydatabase; Pooling=false";
27. objConn = new MySqlConnection(strConnString);
28. objConn.Open();
29.
30. String strSQL;
31. DataSet ds = new DataSet();
32. strSQL = "SELECT * FROM gallery ";
33. objCmd = new MySqlCommand();
34. objCmd.Connection = objConn;
35. objCmd.CommandText = strSQL;
36. objCmd.CommandType = CommandType.Text;
37.
38. dtAdapter.SelectCommand = objCmd;
39.
40. dtAdapter.Fill(ds);
41.
42.
43. myFormView.DataSource = ds;
44. myFormView.DataBind();
45.
46. ds = null;
47.
48. objConn.Close();
49. objConn = null;
50.
51. }
52.
53. protected void myFormView_PageIndexChanging(object sender, FormViewPageEventArgs e)
54. {
55. myFormView.PageIndex = e.NewPageIndex;
56. BindData();
57. }
58.
59. protected void myFormView_DataBound(Object sender, System.EventArgs e)
60. {
61.
62. Image Image1 = (Image)(myFormView.FindControl("Image1"));
63. if(Image1 != null)
64. {
65. Image1.ImageUrl = "images/"+(string)DataBinder.Eval(myFormView.DataItem, "Picture");
66. Image1.Attributes.Add("OnClick", "window.open('images/"+(string)DataBinder.Eval(myFormView.DataItem, "Picture")+"')");
67. Image1.Style.Add("cursor","hand");
68. Image1.ToolTip = (string)DataBinder.Eval(myFormView.DataItem, "GalleryName");
69. }
70.
71.
72. Label lblGalleryName = (Label)(myFormView.FindControl("lblGalleryName"));
73. if(lblGalleryName != null)
74. {
75. lblGalleryName.Text = (string)DataBinder.Eval(myFormView.DataItem, "GalleryName");
76. }
77. }
78.
79.}
C#
ช่วยกันสนับสนุนรักษาเว็บไซต์ความรู้แห่งนี้ไว้ด้วยการสนับสนุน 
