110,561
社区成员
发帖
与我相关
我的任务
分享
DBHelperNB.ExecuteNonQuery("insert into ecs_users(user_name,password,email,question,answer,sex,birthday,frozen_money,pay_points,rank_points,reg_time,last_login,last_ip,visit_count,qq,home_phone,mobile_phone,credit_line) values(?user_name,?password,?email,?question,?answer,?sex,?birthday,?frozen_money,?pay_points,?rank_points,?reg_time,?last_login,?last_ip,?visit_count,?qq,?home_phone,?mobile_phone,?credit_line)",
new MySqlParameter("?user_name", MySqlDbType.VarChar,60) { Value = user_name },
new MySqlParameter("?password", MySqlDbType.VarChar,32) { Value = password },
new MySqlParameter("?email", MySqlDbType.VarChar,60) { Value = email },
new MySqlParameter("?question", MySqlDbType.VarChar,255) { Value = question },
new MySqlParameter("?answer", MySqlDbType.VarChar,255) { Value = answer },
new MySqlParameter("?sex", MySqlDbType.Int16) { Value = sex },
new MySqlParameter("?birthday", MySqlDbType.DateTime) { Value = birthday },
new MySqlParameter("?frozen_money", MySqlDbType.Decimal) { Value = frozen_money },
new MySqlParameter("?pay_points", MySqlDbType.Int16) { Value = pay_points },
new MySqlParameter("?rank_points", MySqlDbType.Int16) { Value = rank_points },
new MySqlParameter("?reg_time", MySqlDbType.DateTime) { Value = reg_time },
new MySqlParameter("?last_login", MySqlDbType.DateTime) { Value = last_login },
new MySqlParameter("?last_ip", MySqlDbType.VarChar,15) { Value = last_ip },
new MySqlParameter("?visit_count", MySqlDbType.Int16) { Value = visit_count },
new MySqlParameter("?qq", MySqlDbType.VarChar,20) { Value = qq },
new MySqlParameter("?home_phone", MySqlDbType.VarChar,20) { Value = home_phone },
new MySqlParameter("?mobile_phone", MySqlDbType.VarChar,20) { Value = mobile_phone },
new MySqlParameter("?credit_line", MySqlDbType.Decimal) { Value = credit_line })
public static int ExecuteNonQuery(string sql, params MySqlParameter[] parameters)
{
using (MySqlConnection conn = new MySqlConnection(connectionString))
{
using (MySqlCommand cmd = new MySqlCommand(sql, conn))
{
cmd.Parameters.AddRange(parameters);
conn.Open();
return cmd.ExecuteNonQuery();
}
}
}