数据操作form1.docVIP

using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; using System.Data.SqlClient; namespace 数据操作_WForm_5._27 { public partial class Form1 : Form { public Form1() { InitializeComponent(); } /// summary /// 插入操作 /// /summary /// param name=sender/param /// param name=e/param private void button4_Click(object sender, EventArgs e) { dbhelp.connection.Open(); string sql = insert into RM_admin(UserName,UserPwd)values( + textBox1.Text + , + textBox2.Text + ); dbhelp.sql_work(sql); dbhelp.connection.Close(); update(); } /// summary /// 查询操作 /// /summary /// param name=sender/param /// param name=e/param private void button1_Click(object sender, EventArgs e) { dbhelp.connection.Open(); update(); dbhelp.connection.Close(); } /// summary /// 选中某列，在控件中显示数据 /// /summary /// param name=sender/param /// param name=e/param private void dataGridView1_SelectionChanged(object sender, EventArgs e) { if (dataGridView1 .SelectedRows .Count 0) { textBox1.Text = dataGridView1.SelectedRows[0].Cells[1].Value.ToString(); textBox2.Text = dataGridView1.SelectedRows[0].Cells[2].Value.ToString(); } } /// summary /// 修改操作 /// /summary /// param name=sender/param /// param name=e/param private void button2_Click(object sender, EventArgs e) { try { dbhelp.connection.Open(); string sql = update RM_admin set UserName= + textBox1.Text + ,UserPwd= + textBox2.T