Data Grid asp Data Grid idmy Data Grid
- Slides: 19
Data. Grid 元件外觀 <asp: Data. Grid id=“my. Data. Grid” runat=“server” Back. Image. Url=“. /bg. gif” Grid. Lines=“none” Cell. Padding=“ 5” Cell. Spacing=“ 0” Show. Header=“True” Header. Style-Back. Color=“#BBBBBB” Item. Style-Hoeizontal. Align=“Center” Alternating. Item. Style-Back. Color=“#CCCCFF”/> style 物件
可分頁查詢的Data. Grid元件 <%@ Import Namespace="System. Data. Sql. Client" %> <%@ Import Namespace="System. Data" %> <Script Runat="Server"> Sub Page_Load If Not is. Post. Back Then Bind. Data. Grid End If End Sub Bind. Data. Grid Dim con. Pubs As Sql. Connection Dim dad. Titles As Sql. Data. Adapter Dim dst. Titles As Data. Set con. Pubs = New Sql. Connection( "Server=localhost; UID=sa; PWD=secret; Database=Pubs" ) dad. Titles = New Sql. Data. Adapter( "Select * From Titles Order By Title", con. Pubs ) dst. Titles = New Data. Set dad. Titles. Fill( dst. Titles ) dgrd. Titles. Data. Source = dst. Titles dgrd. Titles. Data. Bind() End Sub
可分頁查詢的Data. Grid元件 Sub dgrd. Titles_Page. Index. Changed( s As Object, e As Data. Grid. Page. Changed. Event. Args ) dgrd. Titles. Current. Page. Index = e. New. Page. Index Bind. Data. Grid End Sub </Script> <html> <head><title>Data. Grid. Paging. aspx</title></head> <body> <form Runat="Server"> <asp: Data. Grid ID="dgrd. Titles" Allow. Paging="True" Page. Size="5" On. Page. Index. Changed="dgrd. Titles_Page. Index. Changed" Cell. Padding="3" Runat="Server" /> </form> </body> </html>
可分頁查詢的Data. Grid元件 Pager. Style-Pre. Page. Text=“上一頁” Pager. Style-Next. Page. Text=“下一頁” Pager. Style-Position=“Top” Pager. Style-Mode=“Numeric. Pages”
自訂Data. Grid元件中顯示的資料欄位 <%@ Import Namespace="System. Data. Sql. Client" %> <Script Runat="Server"> Sub Page_Load Dim con. Pubs As Sql. Connection Dim cmd. Select As Sql. Command con. Pubs = New Sql. Connection( "Server=localhost; UID=sa; PWD=secret; Database=Pubs" ) cmd. Select = New Sql. Command( "Select * From Titles", con. Pubs ) con. Pubs. Open() dgrd. Titles. Data. Source = cmd. Select. Execute. Reader() dgrd. Titles. Data. Bind() con. Pubs. Close() End Sub </Script>
自訂Data. Grid元件中顯示的資料欄位 <html> <head><title>Data. Grid. Bound. Columns. aspx</title></head> <body> <asp: Data. Grid ID="dgrd. Titles" Auto. Generate. Columns="False" Runat="Server"> <Columns> <asp: Bound. Column Data. Field="Title“ Item. Style-Width=“ 120” /> <asp: Bound. Column Data. Field="Price" Item. Style-Width=“ 120”/> </Columns> </asp: Data. Grid> </body> </html>
Data. Grid元件中的資料欄位聯結功能 <asp: Data. Grid ID="dgrd. Authors" Auto. Generate. Columns="False" Cell. Padding="10" Runat="Server"> <Columns> <asp: Hyper. Link. Column Data. Text. Field=“植物名稱” Header. Text="植物名稱" Data. Navigate. Url. Field=“英文名稱“ Data. Navigate. Url. Format. String=“http: //127. 0. 0. 1/{0}. aspx" <asp: bound. Column data. Field=“英文名稱” Header. Text==“英文名稱” /> </Columns> </asp: Data. Grid> Note: {0} 為游標所在欄位對應之Data. Navigate. Url. Field屬性值
Data. Grid元件中的排序功能 <%@ Import Namespace="System. Data. Sql. Client" %> <Script Runat="Server"> Sub Page_Load If Not is. Post. Back Then Bind. Data. Grid( "Title" ) End If End Sub Bind. Data. Grid( str. Sort. Field As String ) Dim con. Pubs As Sql. Connection Dim cmd. Select As Sql. Command con. Pubs = New Sql. Connection( "Server=localhost; UID=sa; PWD=secret; Database=Pubs" ) cmd. Select = New Sql. Command( "Select * From Titles Order By " & str. Sort. Field, con. Pubs ) con. Pubs. Open() dgrd. Titles. Data. Source = cmd. Select. Execute. Reader() dgrd. Titles. Data. Bind() con. Pubs. Close() End Sub dgrd. Titles_Sort. Command( s As Object, e As Data. Grid. Sort. Command. Event. Args ) Bind. Data. Grid( e. Sort. Expression ) End Sub </Script>
Data. Grid元件中的排序功能 <html> <head><title>Data. Grid. Sort. Expression. aspx</title></head> <body> <form Runat="Server"> <asp: Data. Grid ID="dgrd. Titles" Allow. Sorting="True" On. Sort. Command="dgrd. Titles_Sort. Command" Auto. Generate. Columns="False" Cell. Padding="10" Runat="Server"> <Columns> <asp: Bound. Column Data. Field="Title“ Header. Text="Sort Titles“ Sort. Expression="title"/> <asp: Bound. Column Header. Text="Sort Price“ Data. Field="price“ Sort. Expression="price"/> <asp: Bound. Column Data. Field="Notes" /> </Columns> </asp: Data. Grid> </form> </body> </html>
Repeater資料庫輸出控制項 <%@ Import Namespace="System. Data. Sql. Client" %> <Script Runat="Server"> Sub Page_Load Dim con. Pubs As Sql. Connection Dim cmd. Select As Sql. Command Dim dtr. Authors As Sql. Data. Reader ' Retrieve records from database con. Pubs = New Sql. Connection( "Server=localhost; UID=sa; PWD=secret; Database=Pubs" ) cmd. Select = New Sql. Command( "Select * From Authors", con. Pubs ) con. Pubs. Open() dtr. Authors = cmd. Select. Execute. Reader() ' Bind to Repeater rpt. Authors. Data. Source = dtr. Authors rpt. Authors. Data. Bind() dtr. Authors. Close() con. Pubs. Close() End Sub </Script>
Repeater資料庫輸出控制項 <html> <head><title>Repeater. aspx</title></head> <body> <form Runat="Server"> <asp: Repeater ID="rpt. Authors" Runat="Server"> <Item. Template> <%# Container. Data. Item( "au_lname" ) %> </Item. Template> </asp: Repeater> </form> </body> </html> Note: <%# %> Data binding tag
Repeater資料庫輸出控制項 <%@ Import Namespace="System. Data. Sql. Client" %> <Script Runat="Server"> Sub Page_Load Dim con. Pubs As Sql. Connection Dim cmd. Select As Sql. Command Dim dtr. Authors As Sql. Data. Reader ' Retrieve records from database con. Pubs = New Sql. Connection( "Server=localhost; UID=sa; PWD=secret; Database=Pubs" ) cmd. Select = New Sql. Command( "Select * From Authors", con. Pubs ) con. Pubs. Open() dtr. Authors = cmd. Select. Execute. Reader() ' Bind to Repeater rpt. Authors. Data. Source = dtr. Authors rpt. Authors. Data. Bind() dtr. Authors. Close() con. Pubs. Close() End Sub </Script>
Repeater資料庫輸出控制項 <html> <head><title>Repeater. Table. aspx</title></head> <body> <form Runat="Server"> <asp: Repeater ID="rpt. Authors“ Enable. View. State=“False” Runat="Server"> <Header. Template> <table border=1 cellpadding=4> <tr bgcolor="#eeeeee"> <th>First Name</th> <th>Last Name</th> <th>Phone</th> </tr> </Header. Template>
Repeater資料庫輸出控制項 <Item. Template> <tr> <td><%# Container. Data. Item( "au_fname" ) %></td> <td><%# Container. Data. Item( "au_lname" ) %></td> <td><%# Container. Data. Item( "phone" ) %></td> </tr> </Item. Template> <Alternating. Item. Template> <tr bgcolor="lightyellow"> <td><%# Container. Data. Item( "au_fname" ) %></td> <td><%# Container. Data. Item( "au_lname" ) %></td> <td><%# Container. Data. Item( "phone" ) %></td> </tr> </Alternating. Item. Template> <Footer. Template> </table> </Footer. Template> </asp: Repeater> </form> </body> </html>
Data. List資料庫輸出控制項 <%@ Import Namespace="System. Data. Sql. Client" %> <Script Runat="Server"> Sub Page_Load Dim con. Pubs As Sql. Connection Dim cmd. Select As Sql. Command Dim dtr. Authors As Sql. Data. Reader con. Pubs = New Sql. Connection( "Server=localhost; UID=sa; PWD=secret; Database=Pubs" ) cmd. Select = New Sql. Command( "Select * From Authors", con. Pubs ) con. Pubs. Open() dtr. Authors = cmd. Select. Execute. Reader() dlst. Authors. Data. Source = dtr. Authors dlst. Authors. Data. Bind() dtr. Authors. Close() con. Pubs. Close() End Sub </Script>
Data. List資料庫輸出控制項 <html> <head><title>Data. List. Template. aspx</title></head> <body> <form Runat="Server"> <asp: Data. List ID="dlst. Authors“ Runat="Server"> <Header. Template> <h 2>Author Phone Numbers: </h 2> </Header. Template> <Item. Template> <table> <tr> <td align="right">First Name: </td> <td><%# Container. Data. Item( "au_fname" )%></td> </tr> <td align="right">Last Name: </td> <td><%# Container. Data. Item( "au_lname" )%></td> </tr> <td align="right">Phone: </td> <td><%# Container. Data. Item( "phone" )%></td> </tr> </table> </Item. Template> <Separator. Template> <hr> </Separator. Template> </asp: Data. List> </form> </body> </html>
Data. List資料庫輸出控制項 <asp: Data. List ID="dlst. Products" Repeat. Columns="4" Repeat. Direction="Horizontal" Cell. Spacing="10" Runat="Server"> <Item. Template> <asp: Link. Button Text='<%# Container. Data. Item( "Product. Name" )%>' Runat="Server"/> </Item. Template> </asp: Data. List>
Classic asp to asp.net migration
Asp-all-route-data
Lga vs pga socket
Request validation bypass
Mauritius police force hierarchy
Client server architecture in asp net
Système de libre accès aux employeurs
Session tracking in asp.net
Asp.net execution model
Apa itu asp
Chargé de cours
Need for madness car maker codes
Asp.net agenda
5 back blows
Stercolithe asp
Azure bug bounty
Asp net session state
Asp.net timeline
Asp 102
Quiero ser bombera juntos seconde
