系统报:
BC30456: 'FillDataSet' is not a member of 'System.Data.SqlClient.SqlDataAdapter'.
源代码:<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SQL" %>
<%@ Import Namespace="System.Data.SQLClient" %>
<script language="VB" runat="server">
Sub Page_Load(sender As Object,e As EventArgs)
Dim StrConnection As String
StrConnection="server=localhost;uid=sa;pwd=;database=BookShop"
Dim MyCommand As SqlDataAdapter=New SqlDataAdapter("SelectAllBooks",strConnection)
Dim DS As DataSet=New DataSet()
MyCommand.SelectCommand.CommandType=CommandType.StoredProcedure
MyCommand.FillDataSet(DS,"BookStore") CreateDataView=New DataView(DS.tables("BookStore"))
End Function
</script>
BC30456: 'FillDataSet' is not a member of 'System.Data.SqlClient.SqlDataAdapter'.
源代码:<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SQL" %>
<%@ Import Namespace="System.Data.SQLClient" %>
<script language="VB" runat="server">
Sub Page_Load(sender As Object,e As EventArgs)
Dim StrConnection As String
StrConnection="server=localhost;uid=sa;pwd=;database=BookShop"
Dim MyCommand As SqlDataAdapter=New SqlDataAdapter("SelectAllBooks",strConnection)
Dim DS As DataSet=New DataSet()
MyCommand.SelectCommand.CommandType=CommandType.StoredProcedure
MyCommand.FillDataSet(DS,"BookStore") CreateDataView=New DataView(DS.tables("BookStore"))
End Function
</script>
解决方案 »
- jquery的简单问题
- 求一个数据库结构和思路!
- xmlHttpRequest的问题
- Repeater分页不显示,高手帮我看一下啊,解决立刻给分!
- 抓字符问题 立马揭贴
- 在网上找了一天了!在vs.net调试时,如果查看DataSet堆栈
- .net 的前端可以写入逻辑代码吗?
- 超级基础问题:页面转向问题和函数调用问题
- 如何把.aspx文件响应到前台的html内容在服务器端存成一个.html文件
- 我在原ASP中用的COM组件,在ASP.NET中不能调用!怎么办?
- 这里有人看WROX的ASP.NET Website Programming Problen-Design-Solution.我问题求救???
- 初学者
系统没有提供这个方法你当然不能用了。
不是'FillDataSet' 而是Fill
<%@ Import Namespace="System.Data.SqlClient" %>
<script language="VB" runat="server">
Sub Page_Load(sender As Object,e As EventArgs)
Dim StrConnection As String
StrConnection="server=localhost;uid=sa;pwd=;database=BookShop"
dim sqlConn as new SqlConnection(StrConnection)
Dim MyCommand As SqlDataAdapter=New SqlDataAdapter("SelectAllBooks",sqlConn)
Dim DS As DataSet=New DataSet()
MyCommand.SelectCommand.CommandType=CommandType.StoredProcedure
MyCommand.Fill(DS,"BookStore") CreateDataView=New DataView(DS.tables("BookStore"))
End Function
</script>
OleDbConnection oldconn = new OleDbConnection();
OleDbCommand com = new OleDbCommand(,);
com.CommandType=CommandType.StoredProcedure ;
com.CommandText = "storename";
再用dataset
public DataSet GetDocumentSlave(string docseq)
{
SqlConnection myConnection = new SqlConnection(strConn);
SqlDataAdapter myCommand = new SqlDataAdapter("GetDocSlave", myConnection); myCommand.SelectCommand.CommandType = CommandType.StoredProcedure; myCommand.SelectCommand.Parameters.Add(new SqlParameter("@doc_seq",SqlDbType.Char,20));
myCommand.SelectCommand.Parameters["@doc_seq"].Value = docseq; DataSet ds = new DataSet();
myCommand.Fill(ds, "sea");
try
{
return ds;
}
catch(System.Data.SqlClient.SqlException er)
{
throw new Exception(er.Message);
}
finally
{
myCommand.Dispose() ;
myConnection.Close() ;
}
}