VS2017中运行MySQL的存储过程

最新推荐文章于 2021-01-19 06:55:08 发布

zls365365

最新推荐文章于 2021-01-19 06:55:08 发布

阅读量99

点赞数

文章标签： mysql 数据库 python linux sql

原文链接：https://mp.weixin.qq.com/s?__biz=MzI0NDE0MDgyNg==&mid=2649591280&idx=1&sn=f121e06da1246ada0de2a9ab078553fd&chksm=f17b7385c60cfa93e26590aad70d4e6c40520f126ac2c2687f915188412d52419864a60357af

版权

using System;
using System.Data;
using MySql.Data.MySqlClient;
using System.Windows.Forms;


namespace WindowsFormsApp7
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }
        MySqlConnection conn;
        //string str = "server=DESKTOP-F3U79IB\\MySQL;database=test;uid=root;pwd=a123456.";
        string str = "server=127.0.0.1;database=test;uid=root;pwd=a123456.";
        private void Form1_Load(object sender, EventArgs e)
        {
            conn = new MySqlConnection(str);
            conn.Open();
            if (conn.State == ConnectionState.Open)
               MessageBox.Show( "数据库连接\n状态：成功");
            else
                MessageBox.Show("数据库连接\n状态：失败");


             /*执行mysql命令*/
            string sql1 = "insert into stu(Name,Sex,Age) values('zyr7','man', 28)";
            MySqlCommand cmd = new MySqlCommand(sql1,conn);
            cmd.ExecuteNonQuery();




            /*执行存储过程*/
            MySqlCommand  cmd1 = new MySqlCommand();
            cmd1.Connection = conn;
            cmd1.CommandType = CommandType.StoredProcedure;
            cmd1.CommandText = "new_procedure";//存储过程名..
            cmd1.ExecuteNonQuery();


        }
    }
}

mysql：