01.using System;
02.using System.Collections;
03.using System.Configuration;
04.using System.Data;
05.using System.Linq;
06.using System.Web;
07.using System.Web.Security;
08.using System.Web.UI;
09.using System.Web.UI.HtmlControls;
10.using System.Web.UI.WebControls;
11.using System.Web.UI.WebControls.WebParts;
12.using System.Xml.Linq;
13.
14.using System.Data.SqlClient;
15.using System.Web.Configuration;
16.
17.public partial class SelectSqlCommand : System.Web.UI.Page
18.{
19. private string sqlCommandString;
20. private string TableID;
21. private string TableData;
22.
23. protected void Page_Load(object sender, EventArgs e)
24. {
25. sqlCommandString = "Select * From [TableDay]";
26. TableID = "DayID";
27. TableData = "DayName";
28.
29. if (!IsPostBack)
30. {
31.
32. DropDownList1.Items.Add(new ListItem("ตารางวัน", "Day"));
33. DropDownList1.Items.Add(new ListItem("ตารางเดือน", "Month"));
34.
35. DropDownList1.Items[0].Selected = true;
36. }
37.
38. DropDownList1.AutoPostBack = true;
39. DropDownList1.SelectedIndexChanged += new EventHandler(DropDownList1_SelectedIndexChanged);
40.
41. DataList1.ItemDataBound += new DataListItemEventHandler(DataList1_ItemDataBound);
42.
43. BindData();
44. }
45.
46. protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
47. {
48. switch (DropDownList1.SelectedItem.Value)
49. {
50. case "Day":
51. sqlCommandString = "Select * From [TableDay]";
52. TableID = "DayID";
53. TableData = "DayName";
54. break;
55. case "Month":
56. sqlCommandString = "Select * From [TableMonth]";
57. TableID = "MonthID";
58. TableData = "MonthName";
59. break;
60. }
61.
62. BindData();
63. }
64.
65. protected void DataList1_ItemDataBound(object sender, DataListItemEventArgs e)
66. {
67. Label LabelBind1 = (Label)(e.Item.FindControl("Label1"));
68. Label LabelBind2 = (Label)(e.Item.FindControl("Label2"));
69.
70. if (LabelBind1 != null)
71. LabelBind1.Text = DataBinder.Eval(e.Item.DataItem, TableID).ToString();
72.
73. if (LabelBind2 != null)
74. LabelBind2.Text = DataBinder.Eval(e.Item.DataItem, TableData).ToString();
75. }
76.
77. private void BindData()
78. {
79. string sqlConnectionString = WebConfigurationManager.ConnectionStrings["SqlConnectionString"].ToString();
80. SqlConnection sqlConnection = new SqlConnection(sqlConnectionString);
81.
82. SqlCommand sqlCommand = new SqlCommand(sqlCommandString, sqlConnection);
83. SqlDataAdapter sqlDataAdapter = new SqlDataAdapter(sqlCommand);
84.
85. DataTable Dt = new DataTable();
86. sqlDataAdapter.Fill(Dt);
87.
88. DataList1.DataSource = Dt;
89. DataList1.DataBind();
90. }
91.}
