📄 7-6.aspx
字号:
<%@ Import Namespace="system.Data" %>
<%@ Import Namespace="system.Data.Sqlclient" %>
<Script Language="VB" runat="Server">
Dim conn as SqlConnection
Dim com as SqlCommand
Dim ad as New SqlDataAdapter
Dim ds as New Dataset
Sub Page_Load(Sender As object,e As Eventargs)
Dim conStr,comStr as String
conStr="Persist Security Info=False;Initial Catalog=Northwind;Data Source=localhost;Integrated Security=SSPI;"
conn = New SqlConnection(conStr)
ComStr = "select * from shippers order by shipperid;"
Com = New SqlCommand(ComStr,conn)
ad.SelectCommand=Com
try
Conn.Open()
ad.Fill(ds, "Shippers")
catch ex as SqlException
Label1.Text = ex.Message
end try
'下拉列表框dropdownlist1绑定到Northwind数据库的Shipppers数据表的shipperID列上
dropdownlist1.DataSource=ds
dropdownlist1.DataTextField="shipperID"
dropdownlist1.DataValueField="shipperID"
'数据网格控件datagrid1绑定到Northwind数据库的Shipppers数据表上
DataGrid1.DataSource = ds
Page.databind()
End Sub
</Script>
<Html>
<Head>
<Title></Title>
</Head>
<Body>
<form runat="server">
<asp:Label id="Label1" runat="server" maintainstate=false /><br>
订购号：<asp:DropDownList id="dropdownlist1" runat="server"/><BR>
公司名：<asp:TextBox id="textbox1"
Text='<%# ds.Tables("Shippers").rows(0).Item("companyname")%>'
runat="server"/><BR>
电话号码：<asp:TextBox id="textbox2"
Text='<%# DataBinder.Eval(ds.Tables("Shippers").DefaultView(0),"phone")%>'
runat="server"/><P>
<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>
</form>
</Body>
</Html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -