<%@page language="C#"%>
<%@import namespace="System.Data"%>
<%@import namespace="System.Data.OleDb"%>
<script runat="server" language="c#">
void Page_Load(Object sender,EventArgs e)
{
OleDbConnection conn=new OleDbConnection();
conn.ConnectionString="Provider=Microsoft.jet.OLEDB.4.0;"+"Data Source="+Server.MapPath("mydatabase.mdb");
conn.Open();
string sql="UPDATE grade SET 数学=100 WHERE 学号 = '12'";
OleDbCommand comm=new OleDbCommand(sql,conn);
comm.ExecuteNonQuery();

string sql2="select * from grade";
comm.CommandText=sql2;
OleDbDataReader dr=comm.ExecuteReader();
dg.DataSource=dr;
dg.DataBind();
conn.Close();
}
</script>
<asp:DataGrid id="dg" runat="server"/>

高手帮忙,错在哪里??


这是错误信息：

估计是连接字符串有问题，你可以单步跟踪调试看看是哪儿出错

这是我操作excel的，可以正常运行
protected void Button1_Click(object sender, EventArgs e)
{
OleDbConnection conn = new OleDbConnection();
conn.ConnectionString = "provider=Microsoft.Jet.OLEDB.4.0;data source='D:\\excel\\Book1.xls';;extended properties=excel 8.0";
conn.Open();
string sql = "UPDATE [sheet1$] SET A='b' WHERE B = 'b'";
OleDbCommand comm = new OleDbCommand(sql, conn);
comm.ExecuteNonQuery();

string sql2 = "select * from [sheet1$]";
comm.CommandText = sql2;
OleDbDataReader dr = comm.ExecuteReader();
GridView1.DataSource = dr;
GridView1.DataBind();
conn.Close();

}

我试了你的代码，可怎么还是有错啊。我是初学者，不太懂调试程序。
这是我写的代码：
<%@page language="C#" Debug="TRUE"%>
<%@import namespace="System.Data"%>
<%@import namespace="System.Data.OleDb"%>
<script runat="server" language="c#">
void Page_Load(object sender, EventArgs e)
{
OleDbConnection conn = new OleDbConnection();
conn.ConnectionString = "provider=Microsoft.Jet.OLEDB.4.0;data source='D:\\excel\\Book1.xls';;extended properties=excel 8.0";
conn.Open();
string sql = "UPDATE [sheet1$] SET A='b' WHERE B = 'b'";
OleDbCommand comm = new OleDbCommand(sql, conn);
comm.ExecuteNonQuery();

string sql2 = "select * from [sheet1$]";
comm.CommandText = sql2;
OleDbDataReader dr = comm.ExecuteReader();
dg.DataSource = dr;
dg.DataBind();
conn.Close();

}
</script>
<asp:DataGrid id="dg" runat="server"/>


这是错误提示：

有的。
你的完整代码是什么样的啊??