winfrom点击按钮修改数据_C#在winform中操作数据库，实现数据增删改查

usingSystem;usingSystem.Collections.Generic;usingSystem.ComponentModel;usingSystem.Data;usingSystem.Drawing;usingSystem.Linq;usingSystem.Text;usingSystem.Threading.Tasks;usingSystem.Windows.Forms;namespaceData

{public partial classForm1 : Form

{publicForm1()

{

InitializeComponent();

}

DataSet ds= newDataSet();

DataTable dt= newDataTable();private voidTextBoxNull()

{

textBox1.Text= "";

textBox2.Text= "";

textBox3.Text= "";

textBox4.Text= "";

}private void 用户ToolStripMenuItem_Click(objectsender, EventArgs e)

{

TextBoxNull();

ds= SqlDesigner.ExecuteDataSet("select * from dtuser");

dt= ds.Tables[0];

dataGridView1.DataSource=dt;

labelshow();

}private void 角色ToolStripMenuItem_Click(objectsender, EventArgs e)

{

TextBoxNull();

ds= SqlDesigner.ExecuteDataSet("select *from dtrole");

dt= ds.Tables[0];

dataGridView1.DataSource=dt;

label4.Text= "None";

textBox4.Text= "None";

labelshow();

}private void 对象ToolStripMenuItem_Click(objectsender, EventArgs e)

{

TextBoxNull();

ds= SqlDesigner.ExecuteDataSet("select * from dtfunction");

dt= ds.Tables[0