<%@ Import Namespace="SysTem.Data"%>
<%@ Import Namespace="System.Data.OleDb"%>
<%
Dim strConnString as String
strConnString = "Provider=SQLOLEDB;Data Source=(local);Initial Catalog=wy;User ID=sa;pwd=800328"
Dim ObjConn as OleDbConnection
ObjConn = New OleDbconnection
ObjConn.ConnectionString = strConnString
ObjConn.Open()
Dim strSQL as String="Selsect * FROM wyy"
Dim ObjDSCommand as OleDbCommand Dim ObjDataset as Dataset = New Dataset
ObjDsCommand = New OleDbCommand(strSQL,ObjConn) Dim ObjDA as OleDb.OleDbDataAdapter = New OleDb.OleDbDataAdapter(strSQL,ObjConn)
ObjDA.Fill(ObjDataset,"Author Information")
ObjConn.Close()
ObjConn = Nothing Authors.DataSource =_objDataset.Tables("Author Information").DefaultView
Authors.DataBind()
%>
<Html>
<Body>
<asp:DataGrid id="Authors" runat="server"/>
</body>
</html>系统提示错误:
编译错误
说明: 在编译向该请求提供服务所需资源的过程中出现错误。请检查下列特定错误详细信息并适当地修改源代码。 编译器错误信息: BC30451: 名称“_objDataset”未声明。源错误: 行 25: ObjConn = Nothing
行 26:
行 27: Authors.DataSource =_objDataset.Tables("Author Information").DefaultView
行 28: Authors.DataBind()
行 29:
这句是不是有问题Authors.DataSource =_objDataset.Tables("Author Information").DefaultView
请问正确的写法!!!从数据库中输出数据,并显示!!多谢了!!!
<%@ Import Namespace="System.Data.OleDb"%>
<%
Dim strConnString as String
strConnString = "Provider=SQLOLEDB;Data Source=(local);Initial Catalog=wy;User ID=sa;pwd=800328"
Dim ObjConn as OleDbConnection
ObjConn = New OleDbconnection
ObjConn.ConnectionString = strConnString
ObjConn.Open()
Dim strSQL as String="Selsect * FROM wyy"
Dim ObjDSCommand as OleDbCommand Dim ObjDataset as Dataset = New Dataset
ObjDsCommand = New OleDbCommand(strSQL,ObjConn) Dim ObjDA as OleDb.OleDbDataAdapter = New OleDb.OleDbDataAdapter(strSQL,ObjConn)
ObjDA.Fill(ObjDataset,"Author Information")
ObjConn.Close()
ObjConn = Nothing Authors.DataSource =_objDataset.Tables("Author Information").DefaultView
Authors.DataBind()
%>
<Html>
<Body>
<asp:DataGrid id="Authors" runat="server"/>
</body>
</html>系统提示错误:
编译错误
说明: 在编译向该请求提供服务所需资源的过程中出现错误。请检查下列特定错误详细信息并适当地修改源代码。 编译器错误信息: BC30451: 名称“_objDataset”未声明。源错误: 行 25: ObjConn = Nothing
行 26:
行 27: Authors.DataSource =_objDataset.Tables("Author Information").DefaultView
行 28: Authors.DataBind()
行 29:
这句是不是有问题Authors.DataSource =_objDataset.Tables("Author Information").DefaultView
请问正确的写法!!!从数据库中输出数据,并显示!!多谢了!!!
Authors.DataSource =ObjDataset .Tables("Author Information").DefaultView
OleDbConnection myConnection = new OleDbConnection(conn);
OleDbCommand myCommand = new OleDbCommand("SELECT * from lib", myConnection);
myConnection.Open();
OleDbDataReader result = myCommand.ExecuteReader(CommandBehavior.CloseConnection);
OleDbConnection myConnection = new OleDbConnection(conn);
DataSet ds = new DataSet(); OleDbDataAdapter adapter = new OleDbDataAdapter("select * from classlist order by 大类名称", myConnection);
adapter.Fill(ds, "classlist"); OleDbDataReader result = myCommand.ExecuteReader(CommandBehavior.CloseConnection);