string connStr = String.Format("server=127.0.0.1;user id=root; database=test; pooling=false;port=3306");
MySqlConnection myConn = new MySqlConnection(connStr);
myConn.Open(); MySqlCommand cmd = new MySqlCommand();
cmd.Connection = myConn;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "pre_name";
MySqlParameter ind = new MySqlParameter("?index_name", MySqlDbType.Int16, 15);
ind.Value=1;
cmd.Parameters.Add(ind);
MySqlParameter id = new MySqlParameter("?",MySqlDbType.VarChar,40);
id.Direction = ParameterDirection.Output;
cmd.Parameters.Add(id);
cmd.ExecuteNonQuery();
textBox4.Text = id.Value.ToString();
myConn.Close();
这是代码。
希望高手解决下,谢谢了!!
MySqlConnection myConn = new MySqlConnection(connStr);
myConn.Open(); MySqlCommand cmd = new MySqlCommand();
cmd.Connection = myConn;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "pre_name";
MySqlParameter ind = new MySqlParameter("?index_name", MySqlDbType.Int16, 15);
ind.Value=1;
cmd.Parameters.Add(ind);
MySqlParameter id = new MySqlParameter("?",MySqlDbType.VarChar,40);
id.Direction = ParameterDirection.Output;
cmd.Parameters.Add(id);
cmd.ExecuteNonQuery();
textBox4.Text = id.Value.ToString();
myConn.Close();
这是代码。
希望高手解决下,谢谢了!!
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货