sqldatasetcommand是原来beta版时用的,到正式版的时候用sqldataadapter来替代!
dim mycommand as sqldataadapter
mycommand = new sqldataadapter("select* from infor",myconnection)就行了
dim mycommand as sqldataadapter
mycommand = new sqldataadapter("select* from infor",myconnection)就行了
解决方案 »
- 独立开发的CRM系统 请大师指点
- vs 2003项目
- 如何判断xml文档中一个节点的值是否存在?,详情见内
- imagebutton 如何实现在客户端禁用?
- 关于dll重用问题
- [馨郁星愿]哪里有petshop 1.0的代码下??xdjm们麻烦给偶发个连接偶下下?
- 做这样的asp.net网站(http://www.eating.cn/file/main/),要多少钱?
- 紧急:web.config 中 <allow roles="admin"> 中的 admin 是什么的角色?
- !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! 我想将二维数组每个值导出 应该怎么做呢 如下:
- 如何访问并修改DataGrid中隐藏的列??
- 如何在ASP.net中使用messageBox?
- 数据库路径的问题
Dim strConnect As String
strConnect = ctlConnectStrings.SQLConnectionString
outConnect.innerText = strConnect 'and display it 'specify the SELECT statement to extract the data
Dim strSelect As String
strSelect = "SELECT * FROM BookList WHERE ISBN LIKE '1861003%'"
'declare a variable to hold a DataSet object
'note that we have to create it outside the Try..Catch block
'as this is a separate block and so is a different scope
Dim objDataSet As New DataSet() Try 'create a new Connection object using the connection string
Dim objConnect As New SqlConnection(strConnect) 'create a new DataAdapter using the connection object and select statement
Dim objDataAdapter As New SqlDataAdapter(strSelect, objConnect) 'fill the dataset with data from the DataAdapter object
objDataAdapter.Fill(objDataSet, "Books")
Catch objError As Exception End Try
原先的问题改决了,现在又出现新问题了
报错为“filldataset”不是“System.Data.SqlClient.SqlDataAdapter”的成员。
行 10: mycommand=new sqldataadapter("select * from infor",myconnection)
行 11: ds=new dataset()
行 12: mycommand.filldataset(ds,"infor").defaultview (红字)
行 13: mydatagrid.databind()
行 14: end sub
谢谢大家了。
mydatagrid.databind()
改了这两句,就出现以下错误:
BC30456: “dafaultview”不是“System.Data.DataTable”的成员。
<%@import namespace="system.data.SQLclient"%>
<html>
<script language="vb" runat="server">
sub page_load(src as object,e as eventargs)
dim ds as dataset
dim myconnection as sqlconnection
dim mycommand as sqldataadapter
myconnection=new sqlconnection("server=a;uid=sa;pwd=;database=info")
mycommand=new sqldataadapter("select * from infor",myconnection)
ds=new dataset()
mycommand.Fill(ds,"infor")
mydatagrid.databind()end sub
</script>
<center>
<body>
<h3><font face="verdana">page_load事件演示</font></h3>
<asp:datagrid id="mydatagrid" runat="server" width="600" backcolor="white" bordercolor=black showfooter=false cellpadding=3
cellspacing=0 font-name=verdana font-size=8pt headerstyle-backcolor=#aaaadd maintainstate=false/>
</body>
</center>
</html>
这是最后改的了,就是从数据库里读不出数据。