62,046
社区成员
发帖
与我相关
我的任务
分享
public static ZaiXian AddUser(ZaiXian zai)
{
ZaiXian xian = null;
OleDbConnection conn = DBHelper.conn();
string sql = "insert into ZaiXian(ZhuT, Massages, Names,LTime,Phones,Emails) values(@ZhuT, @Massages, @Names,@LTime,@Phons,@Emails)";
OleDbCommand cmd = new OleDbCommand(sql, conn);
cmd.Parameters.AddWithValue("@ZhuT", zai.ZhuT);
cmd.Parameters.AddWithValue("@Massages", zai.Massages);
cmd.Parameters.AddWithValue("@Names", zai.Names);
cmd.Parameters.AddWithValue("@LTime", zai.LTime);
cmd.Parameters.AddWithValue("@Phons", zai.Phons);
cmd.Parameters.AddWithValue("@Emails", zai.Emails);
conn.Open();
cmd.ExecuteScalar();
conn.Close();
return xian;
}
OleDbCommand cmd = new OleDbCommand(sql, conn);
OleDbParameter[] parm = new OleDbParameter[1];//这里记得多少个参数就写几
parm[0] = new OleDbParameter("ZhuT", OleDbType.VarChar);
parm[0].Value = zai.ZhuT;