C 窗体Mysql增删查改,C#窗体增删改查(入门级数据库操作示例)

【实例简介】 含数据库文件 附加即可

【实例简介】

【实例截图】

【核心代码】

using 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 System.Data.SqlClient;

namespace 增删改查数据窗体

{

public partial class Form1 : Form

{

public Form1()

{

InitializeComponent();

}

private void Form1_Load(object sender, EventArgs e)

{

LoadData();

}

public void LoadData()

{

List list = new List();

string constr = "data source=.;initial catalog=myfirstdatabase;integrated security=true";

using (SqlConnection con = new SqlConnection(constr))

{

string sql = "select * from 员工表";

using (SqlCommand cmd = new SqlCommand(sql, con))

{

con.Open();

using (SqlDataReader Reader = cmd.ExecuteReader())

{

if (Reader.HasRows)

{

while (Reader.Read())

{

Employ newemploy = new Employ();

newemploy.ID = Reader.GetIn