简单的c#增删改查.doc

using System;using System.Collections.Generic;using System.ComponentModel;using System.Data;using System.Drawing;using System.Text;using System.Windows.Forms;using System.Data.SqlClient;namespace WindowsApplication11 public partial class Form1 : Form public Form1() InitializeComponent(); public void Form1_Load(object sender, EventArgs e) private void fillByToolStripButton_Click(object sender, EventArgs e) try this.basicTableAdapter.FillBy(DataSet.Basic); catch (System.Exception ex) System.Windows.Forms.MessageBox.Show(ex.Message); private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e) private void button1_MouseClick(object sender, MouseEventArgs e) private void button1_Click(object sender, EventArgs e) string str_con = Server=GSMSQLEXPRESS;Uid=sa;Pwd=hxrt;Database=Name; /定义SQL语句字符串 string sql = select * from dbo.Basic; /定义并实例化数据库连接类型变量 SqlConnection conn = new SqlConnection(str_con); /打开数据库连接 SqlCommand comm = new SqlCommand(sql, conn); / SqlDataAdapter da = new SqlDataAdapter(comm); DataTable dt = new DataTable(); /执行读操作 SqlDataAdapter da = new SqlDataAdapter(comm); Console.WriteLine(读取成功); da.Fill(dt); / conn.Open(); this.dataGridView1.DataSource = null; this.dataGridView1.DataSource = dt; this.dataGridView1.Refresh(); / conn.Close(); public void button2_Click(object sender, EventArgs e) string str_con = Server=GSMSQLEXPRESS;Uid=sa;Pwd=hxrt;Database=Name; string sql = SELECT * FROM dbo.Basic WHERE (Id= + textBox1.Text + or Name= + textBox1.Text + or Age= + textBox1.Text + or Sex= + textBox1.Text + ); /定义并实例化数据库连接类型变量 SqlConnection conn = new SqlConnection(str_con); /打开数据库连接 SqlCommand comm = new SqlCommand(sql, conn); / SqlDataAdapter da = new SqlDataAdapter(comm); DataTable dt = new DataTable(); /执行读操作 SqlDataAdapter da = new SqlDataAdapter(comm); da.Fill(dt); / conn.Open(); this.dataGridView1.DataSource = null; this.dataGridView1.DataSource = dt; this.dataGridView1.Refresh(); int i = comm.ExecuteNonQuery(); private void button4_Click(object sender, EventArgs e) string str_con = Server=GSMSQLEXPRESS;Uid=sa;Pwd=hxrt;Database=Name; SqlConnection ss = new SqlConnection(str_con); ss.Open(); /string sql = delete from dbo.Basic where( Name = + textBox2.Text + );这行是删除下一行是添加 string sql = insert dbo.Basic (Name,Id,Age,Sex) values( + textBox2.Text + , + textBox3.Text + , + textBox4.Text + , + textBox5.Text + ); /打开数据库连接 SqlCommand comm = new SqlCommand(sql, ss); int i = comm.ExecuteNonQuery(); if (i 0) MessageBox.Show(成功); else MessageBox.Show(失败); private void button5_Click(object sender, EventArgs e) this.dataGridView1.EndEdit(); string str_con = Server=GSMSQLEXPRESS;Uid=sa;Pwd=hxrt;Database=Name; string sql = select * from dbo.Basic; SqlConnection conn = new SqlConnection(str_con); SqlCommand comm = new SqlCommand(sql, conn); SqlDataAdapter da = new SqlDataAdapter(comm); DataTable dt = new DataTable(); try SqlCommandBuilder scb = new SqlCommandBuilder(da);/构造SqlCommandBuilder对象 da.Update(dt); /Form1_Load(); /修改后刷新 catch (Exception ex) MessageBox.Show(ex.ToString(); private void button6_Click(object sender, EventArgs e) string str_con = Server=GSMSQLEXPRESS;Uid=sa;Pwd=hxrt;Database=Name; string sql = SELECT * FROM dbo.Basic WHERE (Id= + textBox1.Text + or Name= + textBox1.Text + or Age= + textBox1.Text + or Sex= + textBox1.Text + ); /定义并实例化数据库连接类型变量 SqlConnection conn = new SqlConnection(str_con); /打开数据库连接 SqlCommand comm = new SqlCommand(sql, conn); / SqlDataAdapter da = new SqlDataAdapter(comm); DataTable dt = new DataTable();