📄 deserializeclass.aspx
字号:
<%@ Import Namespace="myComponents" %>
<%@ Import Namespace="System.IO" %>
<%@ Import Namespace="System.Runtime.Serialization.Formatters.Binary" %>
<%@ Import Namespace="System.Data.SqlClient" %>
<Script runat="Server">
Sub Button_Click( s As Object, e As EventArgs )
Dim objUserInfo As UserInfo
Dim objMemoryStream As MemoryStream
Dim objBinaryFormatter As BinaryFormatter
Dim conMyData As SqlConnection
Dim cmdSelect As SqlCommand
Dim dtrUserInfo As SqlDataReader
Dim arrByte As Byte()
conMyData = New SqlConnection( "Server=localhost;UID=sa;PWD=secret;Database=myData" )
cmdSelect = New SqlCommand( _
"sELECT username, userInfo FROM Userlist WHERE username=@username", _
conMyData )
cmdSelect.Parameters.Add( "@username", txtUsername.Text )
conMyData.Open()
dtrUserInfo = cmdSelect.ExecuteReader()
If dtrUserInfo.Read Then
arrByte = dtrUserInfo( "userinfo" )
objMemoryStream = New MemoryStream( arrByte )
objBinaryFormatter = New BinaryFormatter
objUserInfo = CType( _
objBinaryFormatter.Deserialize( objMemoryStream ), _
UserInfo )
txtPassword.Text = objUserInfo.Password
txtEmail.Text = objUserInfo.Email
End If
conMyData.Close()
End Sub
</Script>
<html>
<head><title>DeserializeClass.aspx</title></head>
<body>
<form runat="Server">
Username:
<br><asp:TextBox
id="txtUsername"
runat="Server" />
<p>
<asp:Button
Text="Retrieve!"
OnClick="Button_Click"
runat="Server" />
<hr>
Password:
<br><asp:Label
id="txtPassword"
EnableViewState="False"
runat="Server" />
<p>
Email:
<br><asp:Label
id="txtEmail"
EnableViewState="False"
runat="Server" />
<p>
</form>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -