sbgetdata.aspx
来自「用VB实现」· ASPX 代码 · 共 43 行
ASPX
43 行
<%@ 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 + =
减小字号Ctrl + -
显示快捷键?