ASP.NET DataList Control - DataSet,DataTable,TableRows |
ASP.NET DataList Control - DataSet,DataTable,TableRows การแสดงผลใน DataList ความของสามารถของคอนโทรล DataList สามารถอ่านข้อมูลในรูปแบบของ DataReader , DataSet และ DataTable ทั้งนี้เพื่อความหลากหลายของข้อมูลที่ผู้ใช้ได้นำมาเข้าในระบบ ในตัวอย่างนี้ผมได้ยกตัวอย่างการใช้งานในรูปแบบต่าง ๆ
Language Code : VB.NET || C#
Framework : 1,2,3,4
DataListDataSetDataTable.aspx
<%@ Import Namespace="System.Data"%>
<%@ Import Namespace="System.Data.OleDb"%>
<%@ Page Language="VB" %>
<script runat="server">
Sub Page_Load(sender As Object, e As EventArgs)
Dim dt As DataTable
'*** DataSet To DataTable ***'
'dt = CreateDsToDt()
'*** DataSet ***'
'dt = CreateDataSet.Tables(0) '*** Convert DataSet to DataTable ***'
'*** DataTable ***'
dt = CreateDataTable()
'*** TableRows ***'
'dt = DataTableRows()
'*** BindData to DataList ***'
myDataList.DataSource = dt
myDataList.DataBind()
End Sub
'*** DataTable ***'
Function CreateDataTable() As DataTable
Dim objConn As New OleDbConnection
Dim dtAdapter As OleDbDataAdapter
Dim dt As New DataTable
Dim strConnString As String
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="& _
Server.MapPath("database/mydatabase.mdb")&";"
objConn = New OleDbConnection(strConnString)
objConn.Open()
Dim strSQL As String
strSQL = "SELECT * FROM category"
dtAdapter = New OleDbDataAdapter(strSQL, objConn)
dtAdapter.Fill(dt)
dtAdapter = Nothing
objConn.Close()
objConn = Nothing
Return dt '*** Return DataTable ***'
End Function
'*** DataSet ***'
Function CreateDataSet() As DataSet
Dim objConn As New OleDbConnection
Dim objCmd As New OleDbCommand
Dim dtAdapter As New OleDbDataAdapter
Dim ds As New DataSet
Dim strConnString,strSQL As String
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="& _
Server.MapPath("database/mydatabase.mdb")&";"
strSQL = "SELECT * FROM category"
objConn.ConnectionString = strConnString
With objCmd
.Connection = objConn
.CommandText = strSQL
.CommandType = CommandType.Text
End With
dtAdapter.SelectCommand = objCmd
dtAdapter.Fill(ds)
dtAdapter = Nothing
objConn.Close()
objConn = Nothing
Return ds '*** Return DataSet ***'
End Function
'*** DataSet To DataTable ***'
Function CreateDsToDt() As DataTable
Dim objConn As New OleDbConnection
Dim objCmd As New OleDbCommand
Dim dtAdapter As New OleDbDataAdapter
Dim ds As New DataSet
Dim dt As DataTable
Dim strConnString,strSQL As String
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="& _
Server.MapPath("database/mydatabase.mdb")&";"
strSQL = "SELECT * FROM category"
objConn.ConnectionString = strConnString
With objCmd
.Connection = objConn
.CommandText = strSQL
.CommandType = CommandType.Text
End With
dtAdapter.SelectCommand = objCmd
dtAdapter.Fill(ds)
dt = ds.Tables(0)
dtAdapter = Nothing
objConn.Close()
objConn = Nothing
Return dt '*** Return DataTable ***'
End Function
'*** TableRows (DataTable) ***'
Function DataTableRows() As DataTable
Dim dt As New DataTable
Dim dr As DataRow
'*** Column ***'
dt.Columns.Add("CategoryID")
dt.Columns.Add("CategoryName")
dt.Columns.Add("Picture")
'*** Rows ***'
dr = dt.NewRow
dr("CategoryID") = "1"
dr("CategoryName") = "Category 1"
dr("Picture") = "images/toy1.gif"
dt.Rows.Add(dr)
'*** Rows ***'
dr = dt.NewRow
dr("CategoryID") = "2"
dr("CategoryName") = "Category 2"
dr("Picture") = "images/toy2.gif"
dt.Rows.Add(dr)
'*** Rows ***'
dr = dt.NewRow
dr("CategoryID") = "3"
dr("CategoryName") = "Category 3"
dr("Picture") = "images/toy3.gif"
dt.Rows.Add(dr)
'*** Rows ***'
dr = dt.NewRow
dr("CategoryID") = "4"
dr("CategoryName") = "Category 4"
dr("Picture") = "images/toy4.gif"
dt.Rows.Add(dr)
Return dt '*** Return DataTable ***'
End Function
</script>
<html>
<head>
<title>ThaiCreate.Com ASP.NET - DataList</title>
</head>
<body>
<form id="form1" runat="server">
<asp:DataList id="myDataList" RepeatColumns="2" runat="server">
<HeaderTemplate>
<b>My Category</b>
</HeaderTemplate>
<ItemTemplate>
<div style="width:100px" align="center">
<img src="<%#Container.DataItem("Picture")%>">
<br />
<%#Container.DataItem("CategoryName")%>
</div>
</ItemTemplate>
<SeparatorTemplate>
<hr />
</SeparatorTemplate>
</asp:DataList>
</form>
</body>
</html>
![](/images/adv.jpg)
Screenshot
|
ช่วยกันสนับสนุนรักษาเว็บไซต์ความรู้แห่งนี้ไว้ด้วยการสนับสนุน Source Code 2.0 ของทีมงานไทยครีเอท
|
|
|
By : |
ThaiCreate.Com Team (บทความเป็นลิขสิทธิ์ของเว็บไทยครีเอทห้ามนำเผยแพร่ ณ เว็บไซต์อื่น ๆ) |
|
Score Rating : |
![](/images/resource/startrue.gif) ![](/images/resource/startrue.gif) ![](/images/resource/startrue.gif) |
|
|
Create/Update Date : |
2008-11-05 18:37:31 /
2017-03-28 21:27:09 |
|
Download : |
|
|
Sponsored Links / Related |
|
|
|
|
|
|
|