62,041
社区成员
发帖
与我相关
我的任务
分享新手上路------数据库连接小问题？拜托了。
用adoconnection连上数据库，但是如何把数据显示出来？用adoconnection和dataset怎么连不上啊？
...全文
请发表友善的回复…
发表回复
koa3000 2003-09-29
- 打赏
- 举报
Imports System.Data.OleDb
………
………
Dim objConnection As OleDbConnection
Dim objDataAdapter As New OleDbDataAdapter
Dim objDataset As New DataSet
Dim strConn As String
Dim strSQLAs String
strConn=""
strSQL=""
objConnection = New OleDbConnection(strConn)
objConnection.Open()
objDataAdapter.SelectCommand = New OleDbCommand(strSQL, objConnection)
objDataAdapter.Fill(objDataset)
………
………
Dim objConnection As OleDbConnection
Dim objDataAdapter As New OleDbDataAdapter
Dim objDataset As New DataSet
Dim strConn As String
Dim strSQLAs String
strConn=""
strSQL=""
objConnection = New OleDbConnection(strConn)
objConnection.Open()
objDataAdapter.SelectCommand = New OleDbCommand(strSQL, objConnection)
objDataAdapter.Fill(objDataset)
acewang 2003-09-29
- 打赏
- 举报
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SqlClient" %>
<html>
<script language="VB" runat="server">
Sub Page_Load(Sender As Object, E As EventArgs)
Dim DS As DataSet
Dim MyConnection As SqlConnection
Dim MyCommand As SqlDataAdapter
MyConnection = New SqlConnection("server=(local)\NetSDK;database=pubs;Trusted_Connection=yes")
MyCommand = New SqlDataAdapter("select * from Authors", MyConnection)
DS = new DataSet()
MyCommand.Fill(ds, "作者")
MyDataGrid.DataSource=ds.Tables("作者").DefaultView
MyDataGrid.DataBind()
End Sub
</script>
<body>
<h3><font face="宋体">DataGrid 控件的简单选择</font></h3>
<ASP:DataGrid id="MyDataGrid" runat="server"
Width="700"
BackColor="#ccccff"
BorderColor="black"
ShowFooter="false"
CellPadding=3
CellSpacing="0"
Font-Name="宋体"
Font-Size="8pt"
HeaderStyle-BackColor="#aaaadd"
EnableViewState="false"
/>
</body>
</html>
<%@ Import Namespace="System.Data.SqlClient" %>
<html>
<script language="VB" runat="server">
Sub Page_Load(Sender As Object, E As EventArgs)
Dim DS As DataSet
Dim MyConnection As SqlConnection
Dim MyCommand As SqlDataAdapter
MyConnection = New SqlConnection("server=(local)\NetSDK;database=pubs;Trusted_Connection=yes")
MyCommand = New SqlDataAdapter("select * from Authors", MyConnection)
DS = new DataSet()
MyCommand.Fill(ds, "作者")
MyDataGrid.DataSource=ds.Tables("作者").DefaultView
MyDataGrid.DataBind()
End Sub
</script>
<body>
<h3><font face="宋体">DataGrid 控件的简单选择</font></h3>
<ASP:DataGrid id="MyDataGrid" runat="server"
Width="700"
BackColor="#ccccff"
BorderColor="black"
ShowFooter="false"
CellPadding=3
CellSpacing="0"
Font-Name="宋体"
Font-Size="8pt"
HeaderStyle-BackColor="#aaaadd"
EnableViewState="false"
/>
</body>
</html>
acewang 2003-09-29
- 打赏
- 举报
AdoConnection不会脸上数据库的因为你这是测试版的语法，和正式版有出入。
kuangsha007 2003-09-29
- 打赏
- 举报
你需要定义一个DataAdapter，通过调用DataAdapter的fill方法来填充数据集。
用空的话你可以装个MSDN看看，里面有很多例子会对你有帮助的，。
用空的话你可以装个MSDN看看，里面有很多例子会对你有帮助的，。
暗石绿 2003-09-29
- 打赏
- 举报
已经不存在 System.Data.ADO命名空间了。
应该是
OleDbConnection 或 SqlConnection
应该是
OleDbConnection 或 SqlConnection
