Access的参数查询问题？

[keminlau]

我用参数更新一个access数据库里的记录，不报错，但是更新没有成功：看下面代码
using System;
using System.Data;
using System.Data.OleDb;
using System.Collections;

public class MyClass
{
public static void Main()
{
OleDbConnection conn = new OleDbConnection(@"provider=microsoft.jet.oledb.4.0; data source=C:\Inetpub\wwwroot\fiveXdotNet_Oledb\db\fivexdb.mdb");
conn.Open();

string sSQL = "UPDATE [classmates] "+
"SET " +
"[Name] = @vchName, "+
"[Sex] = @bSex, " +
"[IsAgree] = @bIsAgree," +
"[IsMate] = @bIsMate," +
"[Address] = @vchAddress," +
"[LastLogin] = @dtLastLogin," +
"[LoginTimes] = @iLoginTimes, " +
"[IsOnline] = @bIsOnline " +
" WHERE ([ID] = @iID)";

//Console.WriteLine(sSQL);
//Console.Read();
OleDbParameter[] paParams = {
MyClass.GetParam("@iID", OleDbType.Integer,8, 12),
MyClass.GetParam("@vchName", OleDbType.VarWChar, 50, "老孙"),
MyClass.GetParam("@vchAddress", OleDbType.VarWChar, 100, "address111111"),
MyClass.GetParam("@bSex", OleDbType.Boolean,4, false),
MyClass.GetParam("@bIsMate", OleDbType.Boolean,4, false),
MyClass.GetParam("@bIsAgree", OleDbType.Boolean,4, false),
MyClass.GetParam("@bIsOnline", OleDbType.Boolean,4, false),
MyClass.GetParam("@iLoginTimes", OleDbType.Integer, 4, 200),
MyClass.GetParam("@dtLastLogin",OleDbType.Date,4, DateTime.Now)
};

OleDbCommand cmd = new OleDbCommand(sSQL,conn);

foreach (OleDbParameter parameter in paParams)
cmd.Parameters.Add(parameter);

try{
cmd.ExecuteNonQuery();
}
catch(Exception e){
Console.WriteLine(e.Message);
}
finally{
//cmd.Close();
conn.Close();

}
}

public static OleDbParameter GetParam(string sName,OleDbType DbType, int iSize, object oValue){
OleDbParameter para = new OleDbParameter(sName,DbType,iSize);
para.Value = oValue;
return para;
}
}

然后改用只更新一个name字段，用了两个参数@name和@id后，报数据类型不匹配，我已经按照
http://support.microsoft.com/default.aspx?scid=kb;en-us;320435
这个进行数据类型mapping 了,为什么仍报错啊？

[keminlau]

有没有人遇过这样的情况啊？

[keminlau]

顶呀~~

[suntonycomm]

string sql=string.Empty;
sql = "update Members set M_Name='"+txtName.Text+"',M_Code='"+txtCode.Text+"',M_Password='"+txtPwd.Text+"',M_Email='"+txtMail.Text+"',M_Sig='"+txtSig.Text+"',M_Level="+txtLevel.Text+"
where Member_ID="+Request["ID"];
//Response.Write(sql);
cmd.CommandText = sql;
cnHelp.Open();
cmd.ExecuteNonQuery();
cnHelp.Close();


------------------------------
贴的文字太多了，你看看我的例子吧。

[keminlau]

谢谢suntonycomm(小老鼠)关注，我要用参数来查询

[cnblackhawk]

up

[keminlau]

哎，这问题自己搞定了，access数据库原来是按顺序位置来处理，不看名字，和sql server不一样，真野蛮呀！！这50分给谁啊，有谁看了得益后，留个言，版主给我加分吧，哈哈哈~~~，顶呀
帮我看我另一问题吧把分分过去：
http://community.csdn.net/Expert/TopicView.asp?id=3571439

[keminlau]

人多了，顶一下看~~

[yuna110]

access数据库是按顺序位置来处理
SQL 看名字

SQL 一般用@
access 用 ？

[keminlau]

再顶呀~~

[abm1971]

string sSQL = "UPDATE [classmates] "+
"SET " +
"[Name] = ?, "+
"[Sex] = ?, " +
"[IsAgree] = ?," +
"[IsMate] = ?," +
"[Address] = ?," +
"[LastLogin] = ?," +
"[LoginTimes] = ?, " +
"[IsOnline] = ? " +
" WHERE ([ID] = ?)";
OleDbCommand cmd = new OleDbCommand(sSQL,conn);
cmd.Parameters[0].value=12;
cmd.Parameters[0].value="老孙";
cmd.Parameters[4].value="address111111";
cmd.Parameters[1].value= false;
cmd.Parameters[2].value= false;
cmd.Parameters[3].value= false;
cmd.Parameters[5].value= false;
cmd.Parameters[6].value= 200;
cmd.Parameters[7].value= DateTime.Now;
cnHelp.Open();
cmd.ExecuteNonQuery();

[keminlau]

帮我看我另一问题吧把分分过去：
http://community.csdn.net/Expert/TopicView.asp?id=3571439
谢谢

[keminlau]

顶呀~~！

[keminlau]

散分吧~~~

[hreoghost]

mark