asp.net如何連接access

论坛有相关的帖子吧

试试看吧
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.mdb;extended properties=excel 8.0";
conn.Open();
string sql = "UPDATE book SET A='b' WHERE B = 'b'";
OleDbCommand comm = new OleDbCommand(sql, conn);
comm.ExecuteNonQuery();
conn.Close();
}