📄 7-4.aspx
字号:
<%@ Import Namespace="system.Data" %>
<%@ Import Namespace="system.Data.Sqlclient" %>
<Script Language="VB" runat="Server">
Dim conn as New SqlConnection
Dim com as SqlCommand
Dim rd as SqlDataReader
Sub Page_Load(Sender As object,e As Eventargs)
Dim comStr as String
conn.ConnectionString="Persist Security Info=False;Initial Catalog=Northwind;Data Source=localhost;Integrated Security=SSPI;"
'检索customers数据表
ComStr = "select Address,city from customers where city='Paris'; "
'检索employees数据表
ComStr = ComStr & "select lastname, firstname from employees where Hiredate < '1993-5-1';"
Com = New SqlCommand(ComStr,conn)
try
Conn.Open()
rd = Com.ExecuteReader()
'捕捉异常
catch ex as SqlException
Label1.Text = ex.Message
end try
'绑定网格控件
DataGrid1.DataSource = rd
DataGrid1.DataBind()
'访问下一个数据集
rd.NextResult()
DataGrid2.DataSource = rd
DataGrid2.DataBind()
conn.close
End Sub
</Script>
<Html>
<Head>
<Title></Title>
</Head>
<Body>
<form runat="server">
<asp:Label id="Label1" runat="server"
maintainstate=false /><br>
<asp:DataGrid id="DataGrid1" runat="server"
BorderColor="black"
GridLines="Vertical"
cellpadding="4"
cellspacing="0"
width="100%"
Font-Name="Arial"
Font-Size="8pt"
HeaderStyle-BackColor="#cccc99"
ItemStyle-BackColor="#FFFFFF"
AlternatingItemStyle-Backcolor="#F1F1F1"
AutoGenerateColumns="true" /><br>
<asp:DataGrid id="DataGrid2" runat="server"
BorderColor="black"
GridLines="Vertical"
cellpadding="4"
cellspacing="0"
width="100%"
Font-Name="Arial"
Font-Size="8pt"
HeaderStyle-BackColor="#C1C1C1"
ItemStyle-BackColor="#FFFFFF"
AlternatingItemStyle-Backcolor="#F1F1F1"
AutoGenerateColumns="true" />
</form>
</Body>
</Html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -