001.<%@ Import Namespace="System.Data"%>
002.<%@ Import Namespace="System.Data.Odbc"%>
003.<%@ Page Language="C#" Debug="true" %>
004.<script runat="server">
005. System.Data.Odbc.OdbcConnection objConn;
006. System.Data.Odbc.OdbcCommand objCmd;
007.
008. void Page_Load(object sender, EventArgs e)
009. {
010. String strConnString;
011. strConnString = "DSN=mydatabase;UID=;PWD=;";
012. objConn = new System.Data.Odbc.OdbcConnection(strConnString);
013. objConn.Open();
014.
015. BindData();
016. }
017.
018. void BindData()
019. {
020.
021.
022.
023.
024.
025. DataSet ds;
026. ds = this.CreateDataSet();
027. myRepeater.DataSource = ds.Tables[0].DefaultView;
028. myRepeater.DataBind();
029.
030. }
031.
032.
033.
034. protected DataTable CreateDataTable()
035. {
036. System.Data.Odbc.OdbcConnection objConn = new System.Data.Odbc.OdbcConnection();
037. System.Data.Odbc.OdbcDataAdapter dtAdapter;
038. DataTable dt = new DataTable();
039.
040.
041. String strConnString;
042. strConnString = "DSN=mydatabase;UID=;PWD=;";
043. objConn = new System.Data.Odbc.OdbcConnection(strConnString);
044. objConn.Open();
045.
046. String strSQL;
047. strSQL = "SELECT * FROM customer";
048.
049. dtAdapter = new System.Data.Odbc.OdbcDataAdapter(strSQL, objConn);
050. dtAdapter.Fill(dt);
051.
052. dtAdapter = null;
053.
054. return dt;
055.
056. }
057.
058.
059.
060. protected DataSet CreateDataSet()
061. {
062.
063. System.Data.Odbc.OdbcConnection objConn = new System.Data.Odbc.OdbcConnection();
064. System.Data.Odbc.OdbcCommand objCmd = new System.Data.Odbc.OdbcCommand();
065. System.Data.Odbc.OdbcDataAdapter dtAdapter = new System.Data.Odbc.OdbcDataAdapter();
066.
067. DataSet ds = new DataSet();
068. String strConnString,strSQL;
069.
070. strConnString = "DSN=mydatabase;UID=;PWD=;";
071. strSQL = "SELECT * FROM customer";
072.
073. objConn.ConnectionString = strConnString;
074.
075. objCmd.Connection = objConn;
076. objCmd.CommandText = strSQL;
077. objCmd.CommandType = CommandType.Text;
078.
079. dtAdapter.SelectCommand = objCmd;
080.
081. dtAdapter.Fill(ds);
082.
083. dtAdapter = null;
084.
085. return ds;
086.
087. }
088.
089. void Page_UnLoad()
090. {
091. objConn.Close();
092. objConn = null;
093. }
094.
095.</script>
096.<html>
097.<head>
098.<title>ThaiCreate.Com ASP.NET - System.Data.Odbc</title>
099.</head>
100.<body>
101. <form id="form1" runat="server">
102. <asp:Repeater id="myRepeater" runat="server">
103. <HeaderTemplate>
104. <table border="1">
105. <tr>
106. <th>CustomerID</th>
107. <th>Name</th>
108. <th>Email</th>
109. <th>CountryCode</th>
110. <th>Budget</th>
111. <th>Used</th>
112. </tr>
113. </HeaderTemplate>
114. <ItemTemplate>
115. <tr>
116. <td align="center"><%# DataBinder.Eval(Container.DataItem, "CustomerID") %></td>
117. <td><%# DataBinder.Eval(Container.DataItem, "Name") %></td>
118. <td><%# DataBinder.Eval(Container.DataItem, "Email") %></td>
119. <td align="center"><%# DataBinder.Eval(Container.DataItem, "CountryCode") %></td>
120. <td align="right"><%# DataBinder.Eval(Container.DataItem, "Budget") %></td>
121. <td align="right"><%# DataBinder.Eval(Container.DataItem, "Used") %></td>
122. </tr>
123. </ItemTemplate>
124. </asp:Repeater>
125. </form>
126.</body>
127.</html>
C#
ช่วยกันสนับสนุนรักษาเว็บไซต์ความรู้แห่งนี้ไว้ด้วยการสนับสนุน 
