C#与mySql实战七：在界面中输入参数；
时间：2021-07-01 10:21:17
帮助过：3人阅读
System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using MySql.Data;
using MySql.Data.MySqlClient;
namespace WindowsFormsApplication1
{
public partial class Form1 : Form
{
string MyConnectionString =
"server=localhost;uid=root;pwd=1234;database=student";
public Form1()
{
InitializeComponent();
}
//在每个按钮或其他动作里面添加数据库的打开、操作、关闭；这样可以连续不断的独立的运行；
private void button1_Click(
object sender, EventArgs e)
{
int studentScore;
string score =
textBox3.Text;
int.TryParse(score,
out studentScore);
MySqlConnection connection =
new MySqlConnection(MyConnectionString);
MySqlCommand cmd;
connection.Open();
try
{
cmd =
connection.CreateCommand();
cmd.CommandText =
"INSERT INTO student_score(Id,Name,Score) VALUES(@Id,@Name,@Score)";
cmd.Parameters.AddWithValue("@Id",
int.Parse(textBox1.Text));
cmd.Parameters.AddWithValue("@Name", textBox2.Text);
cmd.Parameters.AddWithValue("@Score", studentScore);
cmd.ExecuteNonQuery();
}
catch(Exception)
{
throw;
}
finally
{
//最后是关闭操作；
if(connection.State==
ConnectionState.Open)
{
connection.Close();
LoadData();
}
}
}
private void LoadData()
{
MySqlConnection connection =
new MySqlConnection(MyConnectionString);
connection.Open();
try
{
MySqlCommand cmd =
connection.CreateCommand();
cmd.CommandText =
"SELECT * FROM student_score";
//对数据库的读出和写入可以单独操作；
MySqlDataAdapter adap =
new MySqlDataAdapter(cmd);
DataSet ds =
new DataSet();
adap.Fill(ds);
//表示显示ds中第一个数据表，默认设置（全部显示）；
dataGridView1.DataSource = ds.Tables[
0].DefaultView;
}
catch (Exception)
{
throw;
}
finally
{
if(connection.State==
ConnectionState.Open)
{
connection.Close();
}
}
}
}
}
图像：
C#与mySql实战七：在界面中输入参数；
标签：
