string NewConn = Server.MapPath("DB1.MDB");
string ConnectionStr = "Data Source =" + NewConn + ";Mode = Share Deny None;Jet OLEDB:Engine Type = 5;Provider =Microsoft.Jet.OLEDB.4.0";
OleDbConnection Conn = new OleDbConnection(ConnectionStr);
Conn.Open();
string sql = "select * from member";
//string sql = "update member set id = ' "+100+" ' where name = ' "+Mary+" '";
OleDbDataAdapter Comm = new OleDbDataAdapter(sql, Conn);
DataSet ds = new DataSet();
Comm.Fill(ds,"member");
Conn.Close();红色部分应该要怎么写呢?想更新数据库中name为Mary的id为100...但是提示上下文中没有Mary..怎么办?求解
string ConnectionStr = "Data Source =" + NewConn + ";Mode = Share Deny None;Jet OLEDB:Engine Type = 5;Provider =Microsoft.Jet.OLEDB.4.0";
OleDbConnection Conn = new OleDbConnection(ConnectionStr);
Conn.Open();
string sql = "select * from member";
//string sql = "update member set id = ' "+100+" ' where name = ' "+Mary+" '";
OleDbDataAdapter Comm = new OleDbDataAdapter(sql, Conn);
DataSet ds = new DataSet();
Comm.Fill(ds,"member");
Conn.Close();红色部分应该要怎么写呢?想更新数据库中name为Mary的id为100...但是提示上下文中没有Mary..怎么办?求解
解决方案 »
- 一个神奇的数据库连接的问题,大家遇到过没有
- 求C#大神,求指导。。急。。!!!
- C#EXE引用DLL中的参数为什么不对
- 如何控制程序一打开光标就在textbox1里闪烁,focus方法我知道,这个有点诡异~~
- ReportViewer 绑定外部数据源的问题 请大家帮下忙
- 大虾帮看一下,有点小错误,关于存储过程分页的,在线等。
- WindowsForm下如何更新DataGrid控件包含的数据?
- 关于TreeView同级节点排序的问题?
- datagridview 添加新行的问题
- 写了将近一年的程序,觉得很没劲,没有挑战性.不知各位同行有何看法
- 请教一个关于图像动态显示的问题
- C#写个数据监视功能,类似CommView软件的功能,谁知道啊? 没分了:(
那些是固定的不用+去加了!ID是INT型,还变字符型??
string sql = "update member set id = 100 where name = 'Mary'";
public void GetSet(string Mary)
{
string NewConn = Server.MapPath("DB1.MDB");
string ConnectionStr = "Data Source =" + NewConn + ";Mode = Share Deny None;Jet OLEDB:Engine Type = 5;Provider =Microsoft.Jet.OLEDB.4.0";
OleDbConnection Conn = new OleDbConnection(ConnectionStr);
Conn.Open();
string sql = "select * from member";
//string sql = "update member set id = ' "+100+" ' where name = ' "+Mary+" '";
OleDbDataAdapter Comm = new OleDbDataAdapter(sql, Conn);
DataSet ds = new DataSet();
Comm.Fill(ds,"member");
Conn.Close(); }