mysql存储过程及c#调用标准版_数据库技巧

MySqlParameter email_parameter = new MySqlParameter("?xemail", MySqlDbType.VarChar, 100);//mysql的存储过程参数是以?打头的！！！！

email_parameter.Value = email;

mysqldata.SelectCommand.Parameters.Add(email_parameter);

//++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

MySqlParameter password_parameter = new MySqlParameter("?xpassword", MySqlDbType.VarChar, 100);//mysql的存储过程参数是以?打头的！！！！

password_parameter.Value = password;

mysqldata.SelectCommand.Parameters.Add(password_parameter);

//++++++++++++++++++++++++++返回值++++++++++++++++++++++++++++++++++++++++++

MySqlParameter id_parameter = new MySqlParameter("?xid", MySqlDbType.Int16,15);//mysql的存储过程参数是以?打头的！！！！

id_parameter.Direction=ParameterDirection.Output;

mysqldata.SelectCommand.Parameters.Add(id_parameter);

//+++++++++++++++++++++++++打开数据库，插入数据，返回id值+++++++++++++++++++

try

{

mysqldata.Fill(dataset, "yuan_user_cc");

id = (Int16)id_parameter.Value;

return id.ToString();

}

catch (MySqlException ex)

{

MessageBox.Show(ex.Message);

return String.Empty;

}

}