注意到这句了吗? 你的comm没有实例化.OleDbCommand comm=null;建议如下修改:
string strConn="Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;Data Source=D:\\test\\authors.mdb";
string strSQL="UPDATE authors SET author='wlshen' WHERE Au_ID='73'";OleDbConnection conn=new OleDbConnection(strConn);conn.Open();OleDbCommand comm = new OleDbCommand(strSQL,conn)comm.ExecuteNonQuery();conn.close();
----------------------------------
To teach a fish how to swim.
string strConn="Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;Data Source=D:\\test\\authors.mdb";
string strSQL="UPDATE authors SET author='wlshen' WHERE Au_ID='73'";OleDbConnection conn=new OleDbConnection(strConn);conn.Open();OleDbCommand comm = new OleDbCommand(strSQL,conn)comm.ExecuteNonQuery();conn.close();
----------------------------------
To teach a fish how to swim.
OleDbCommand comm = new OleDbCommand()
我是用asp.net写的,源码如下:<%@ Page language="c#" CODEPAGE = 936 AutoEventWireup="false"%>
<%@ Import Namespace="System.IO"%>
<%@ Import Namespace="System.Data"%>
<%@ Import Namespace="System.Data.OleDb"%>
<HTML>
<HEAD>
<TITLE>Electronic Business</TITLE>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=gb2312">
<script language="c#" runat="server">
void Page_Load(Object src,EventArgs e)
{
string strConn="Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;Data Source=D:\\test\\authors.mdb";
string strSQL="UPDATE authors SET author='wlshen' WHERE Au_ID='73'"; OleDbConnection conn=new OleDbConnection(strConn);
conn.Open(); OleDbCommand comm = new OleDbCommand(strSQL,conn); comm.ExecuteNonQuery();
conn.Close();
}
</script></head>
<body>
</body>
</html>