📄 sbgetdata.aspx
字号:
<%@ Page Language="VB" ContentType="text/html" ResponseEncoding="gb2312" %>
<script runat="server">
Function GetData() AS System.Data.DataSet
Dim objDataSet as New System.Data.DataSet()
Dim conn as String = System.Configuration. _
ConfigurationSettings. _
AppSettings("MM_CONNECTION_STRING_conn")
Dim strSQL as String = _
"Select * From Customers WHERE CustomerID = 1090"
Dim objDataAdapter as New _
System.Data.Oledb.oledbDataAdapter(strSQL,conn)
ObjDataAdapter.Fill(objDataSet)
Return objDataSet
End Function
Sub Page_Load(Src As Object, E As EventArgs)
dgCustomer.DataSource = GetData.Tables(0)
dgCustomer.DataBind()
End Sub
</script>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>测试获取数据集服务器行为</title>
</head>
<body>
<form runat="server">
<asp:DataGrid ID="dgCustomer" runat="server" >
</asp:DataGrid>
</form>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -