vlambda博客
学习文章列表

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();
 } }}