asp mysql insert_asp.net向Mysql数据库user表中插入数据

stringconstr=ConfigurationManager.ConnectionStrings["jmc"].ConnectionString;//下面使用MySqlConnector/net提供的专用对象MySqlConnectionmycon=newMySqlConnection(constr);myco...

string constr = ConfigurationManager.ConnectionStrings["jmc"].ConnectionString;

//下面使用MySql Connector/net提供的专用对象

MySqlConnection mycon = new MySqlConnection(constr);

mycon.Open();

string sql="INSERT Users ( name, Password, RealName)" +

"VALUES (@UserName, @Password, @RealName)";

MySqlParameter[] para = new MySqlParameter[]

{

new MySqlParameter("@Name", user.Name),

new MySqlParameter("@Password", user.Password),

new MySqlParameter("@RealName", user.RealName)

};

MySqlCommand mycmd = new MySqlCommand(sql, mycon);

mycmd.Parameters.AddRange(para);

int newId = mycmd.ExecuteNonQuery();

Response.Write(newId + "
");

展开