《数据操作form》word版.doc

数据库操作form1 牛皮癣发病部位/npxbw/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(); / / 插入操作 / / / 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(); / / 查询操作 / / / private void button1_Click(object sender, EventArgs e) dbhelp.connection.Open(); update(); dbhelp.connection.Close(); / / 选中某列，在控件中显示数据 / / / private void dataGridView1_SelectionChanged(object sender, EventArgs e) if (dataGridView1 .SelectedRows .Count 0) textBox1.Text = dataGridView1.SelectedRows0.Cells1.Value.ToString(); textBox2.Text = dataGridView1.SelectedRows0.Cells2.Value.ToString(); / / 修改操作 / / / private void button2_Click(object sender, EventArgs e) try dbhelp.connection.Open(); string sql = update RM_admin set UserName= + textBox1.Text + ,UserPwd= + textBox2.Text + where id= + dataGridView1.SelectedRows0.Cells0.Value.ToString() + ; dbhelp.sql_work(sql); catch (Exception ex) MessageBox.Show(ex.Message); finally dbhelp.connection.Close(); update(); / / 删除操作 / / / private void button3_Click(object sender, EventArgs e) dbhelp.connection.Open(); string sql = delete RM_admin where id= + dataGridView1.SelectedRows0.Cells0.Value.ToString() + ; dbhelp.sql_work(sql ); dbhelp.connection.Close(); update(); textBox1.Text = ; textBox2.Text = ; / / 更新DataGridView中的数据 / private void update() string sql = select * from RM_admin; SqlCommand comm = new SqlCommand(sql, dbhelp.connection); SqlDataAdapter dat = new SqlDataAdapter(comm); DataSet das = new DataSet(); dat.Fill(das, select); da