我刚学的!不知道下面哪出问题了 谢谢!<%@Page Language="C#" Debug="true" %>
<%@Import Namespace="System.Data"%>
<%@Import Namespace="System.Data.OleDb"%>
<script language="C#" runat="server">
void Page_Load(object sender,EventArgs e)
{
string strSQL;
string strConnection;
DataSet objDataSet = new DataSet();
OleDbConnection objConnection = null;
OleDbDataAdapter objAdapter = null;
strSQL = "SELECT id,users,password FROM admin ";
strConnection = "Provider=Microsoft.Jet.OLEDB.4.0;";
strConnection += @"Data Source=D:\X\database\data.mdb";
objConnection = new OleDbConnection(strConnection);
objAdapter = new OleDbDataAdapter(strSQL,objConnection);
objAdapter.Fill(objDataSet,"Employees"); dgNameList.DataSource = objDataSet.Tables["Employees"].DefaultView;
dgNameList.DataBind(); strSQL = "SELECT id,users,password FROM user ";
objAdapter.Fill(objDataSet,"Categories");
dgName.DataSource = objDataSet.Tables["Categories"].DefaultView;
dgName.DataBind();
}</script>
<HTML>
<HEAD>
<TITLE> New Document </TITLE></HEAD><BODY>
<asp:datagrid id="dgNameList" runat="server" /><br><br>
<asp:datagrid id="dgName" runat="server" /></BODY>
</HTML>
<%@Import Namespace="System.Data"%>
<%@Import Namespace="System.Data.OleDb"%>
<script language="C#" runat="server">
void Page_Load(object sender,EventArgs e)
{
string strSQL;
string strConnection;
DataSet objDataSet = new DataSet();
OleDbConnection objConnection = null;
OleDbDataAdapter objAdapter = null;
strSQL = "SELECT id,users,password FROM admin ";
strConnection = "Provider=Microsoft.Jet.OLEDB.4.0;";
strConnection += @"Data Source=D:\X\database\data.mdb";
objConnection = new OleDbConnection(strConnection);
objAdapter = new OleDbDataAdapter(strSQL,objConnection);
objAdapter.Fill(objDataSet,"Employees"); dgNameList.DataSource = objDataSet.Tables["Employees"].DefaultView;
dgNameList.DataBind(); strSQL = "SELECT id,users,password FROM user ";
objAdapter.Fill(objDataSet,"Categories");
dgName.DataSource = objDataSet.Tables["Categories"].DefaultView;
dgName.DataBind();
}</script>
<HTML>
<HEAD>
<TITLE> New Document </TITLE></HEAD><BODY>
<asp:datagrid id="dgNameList" runat="server" /><br><br>
<asp:datagrid id="dgName" runat="server" /></BODY>
</HTML>
strSQL = "SELECT id,users,password FROM user ";
改为
strSQL = "SELECT [id],[users],[password] FROM user ";
因为id,password等是数据库保留字
strSQL = "SELECT [id],[users],[password] FROM [user]";
改为
strSQL = "SELECT [id],[users],[password] FROM admin ";
strSQL = "SELECT id,users,password FROM user ";
改为
strSQL = "SELECT [id],[users],[password] FROM [user] ";