📄 spparameters_sql.aspx
字号:
<%@ Page Language="VB" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.OleDb" %>
<script runat="server">
'declare connection
dim Conn as new OleDbConnection("Provider=" & _
"SQLOLEDB;user id=sa;pwd=;" & _
"Database=Banking")
sub GetData(obj as Object, e as EventArgs)
dim objCmd as OleDbCommand = new OleDbCommand _
("SelectIDFromName", Conn)
objCmd.CommandType = CommandType.StoredProcedure
dim objReader as OleDbDataReader
dim objParam as OleDbParameter
objParam = objCmd.Parameters.Add("@FirstName", OleDbType.VarChar)
objParam.Direction = ParameterDirection.Input
objParam.Value = tbFirst.Text
objParam = objCmd.Parameters.Add("@LastName", OleDbType.VarChar)
objParam.Direction = ParameterDirection.Input
objParam.Value = tbLast.Text
objParam = objCmd.Parameters.Add("@ID", OleDbType.Integer)
objParam.Direction = ParameterDirection.Output
try
objCmd.Connection.Open()
objReader = objCmd.ExecuteReader
catch ex as OleDbException
Label1.Text = ex.Message
end try
DataGrid1.DataSource = objReader
DataGrid1.DataBind()
objReader.Close
Response.Write("ID = " & objCmd.Parameters("@ID").Value.ToString())
objCmd.Connection.Close()
end sub
</script>
<html><body>
<form runat="server">
<asp:Label id="Label1" runat="server"
maintainstate=false /><br>
Enter a first name: <asp:TextBox id="tbFirst"
runat="server" /><br>
Enter a last name: <asp:TextBox id="tbLast"
runat="server" /><p>
<asp:Button id="Submit" runat="server"
OnClick=GetData
Text="Submit" /><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="#cccccc"
AutoGenerateColumns="true" />
</form>
</body></html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -