C#实现增删改查原代码

类

 using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.SqlClient;

namespace asas
{
    class Class1
    {
        private SqlConnection con;

        public Class1(string connectionString)
        {
            if (con == null)
            {
                con = new SqlConnection(connectionString);
            }
        }

        public Class1()
        {
            string connectionString = System.Configuration.ConfigurationSettings.AppSettings["connectionstring"];
            if (con == null)
            {
                con = new SqlConnection(connectionString);
            }
        }

        public SqlCommand CreateCommand(string sql, CommandType type, SqlParameter[] prams)
        {
            SqlCommand cmd = new SqlCommand();
            cmd.CommandText = sql;
            cmd.CommandType = type;
            cmd.Connection = con;
            foreach (SqlParameter parameter in prams)
            {
                cmd.Parameters.Add(parameter);
            }
            return cmd;

        }

        public void RunProc(string procedureName, SqlParameter[] prams)
        {
            SqlCommand cmd = CreateCommand(procedureName, CommandType.StoredProcedure, prams);

            con.Open();
            cmd.ExecuteNonQuery();
            con.Close();
            cmd.Dispose();
        }

        public DataSet RunProcReturn(string procName, SqlParameter[] prams)
        {
            SqlDataAdapter dap = CreateDataAdaper(procName, prams);
            DataSet ds = new DataSet();
            dap.Fill(ds, procName);

            //得到执行成功返回值
            return ds;
        }
        private SqlDataAdapter CreateDataAdaper(string procName, SqlParameter[] prams)
        {

            SqlDataAdapter dap = new SqlDataAdapter(procName, con);
            dap.SelectCommand.CommandType = CommandType.Text;  //执行类型：命令文本
            if (prams != null)
            {
                foreach (SqlParameter parameter in prams)
                    dap.SelectCommand.Parameters.Add(parameter);
            }
            //加入返回参数
            //dap.SelectCommand.Parameters.Add(new SqlParameter("ReturnValue", SqlDbType.Int, 4,
            //    ParameterDirection.ReturnValue, false, 0, 0,
            //    string.Empty, DataRowVersion.Default, null));

            return dap;
        }

        public class asas
        {
            Class1 c1 = new Class1();
            //增
            public void Insert(string id, string name, string sex, string age, string subject)
            {
                SqlParameter[] prams ={
                    new SqlParameter("@sysid",SqlDbType.VarChar,10),
                    new SqlParameter("@sysname",SqlDbType.Char,10),
                    new SqlParameter("@syssex",SqlDbType.Char,10),
                    new SqlParameter("@sysage",SqlDbType.VarChar,20),
                    new SqlParameter ("@syssubject",SqlDbType.Char,20)
           };
                prams[0].Value = id;
                prams[1].Value = name;
                prams[2].Value = sex;
                prams[3].Value = age;
                prams[4].Value = subject;
                c1.RunProc("Insertinfo", prams);
            }

 

            //删除
            public void delete(string id)
            {
                SqlParameter[] prams ={
                      new SqlParameter("@sysid",SqlDbType.VarChar,10)
               };
                prams[0].Value = id;
                c1.RunProc("Deleteinfo", prams);
            }

 

            //修改
            public void update(string id, string name, string sex, string age, string subject)
            {
                SqlParameter[] prams ={
                    new SqlParameter("@sysid",SqlDbType.VarChar,10),
                    new SqlParameter("@sysname",SqlDbType.Char,10),
                    new SqlParameter("@syssex",SqlDbType.Char,10),
                    new SqlParameter("@sysage",SqlDbType.VarChar,20),
                    new SqlParameter("@syssubject",SqlDbType.Char,20)
               };
                prams[0].Value = id;
                prams[1].Value = name;
                prams[2].Value = sex;
                prams[3].Value = age;
                prams[4].Value = subject;
                c1.RunProc("Updateinfo", prams);
            }

            public DataSet select(string id)
            {
                SqlParameter[] prams ={
                new SqlParameter("@sysid",SqlDbType.VarChar,10)
            };
                prams[0].Value = id;
                return (c1.RunProcReturn("select * from student where id like @sysid", prams));

            }

 

        }

    }
}

窗体

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 asas
{
    public partial class Form1 : Form
    {
        Class1 c1 = new Class1();
        Class1.asas ad = new Class1.asas();
        public Form1()
        {
            InitializeComponent();
        }
        private void SetdgvWorkerText()
        {
            dataGridView1.Columns[0].HeaderText = "id";
            dataGridView1.Columns[1].HeaderText = "姓名";
            dataGridView1.Columns[2].HeaderText = "性别";
            dataGridView1.Columns[3].HeaderText = "年龄";
            dataGridView1.Columns[4].HeaderText = "专业";
        }
        private void  dgv()
        {
            SqlConnection con = new SqlConnection("server=.;uid=sa;pwd=sa;database=zsgc");
            SqlDataAdapter ads = new SqlDataAdapter("select * from student", con);
            DataTable dt = new DataTable();
            ads.Fill(dt);
            dataGridView1.DataSource = dt.DefaultView;
            con.Close();
            con.Dispose();
            con = null;
        }
        private void button1_Click(object sender, EventArgs e)
        {
            ad.Insert(textBox1.Text.Trim(), textBox2.Text.Trim(), textBox3.Text.Trim(), textBox4.Text.Trim(), textBox5.Text.Trim());
            textBox1.Text = "";
            textBox2.Text = "";
            textBox3.Text = "";
            textBox4.Text = "";
            textBox5.Text = "";
            MessageBox.Show("添加成功");
            dgv();
            SetdgvWorkerText();
        }

        private void button2_Click(object sender, EventArgs e)
        {
            ad.delete(textBox1.Text.Trim());
            textBox1.Text = "";
            MessageBox.Show("删除成功");
            dgv();
            SetdgvWorkerText();
        }

        private void button3_Click(object sender, EventArgs e)
        {
            ad.update(textBox1.Text.Trim(), textBox2.Text.Trim(), textBox3.Text.Trim(), textBox4.Text.Trim(),textBox5.Text.Trim());
            textBox1.Text = "";
            textBox2.Text = "";
            textBox3.Text = "";
            textBox4.Text = "";
            textBox5.Text = "";
            MessageBox.Show("修改成功");
            dgv();
            SetdgvWorkerText();
        }

        private void button4_Click(object sender, EventArgs e)
        {
            DataSet ds = null;
            SetdgvWorkerText();
            ds = ad.select(textBox1.Text.Trim());
            dataGridView1.DataSource = ds.Tables[0].DefaultView;
            MessageBox.Show("id查询成功");
        }

        private void button5_Click(object sender, EventArgs e)
        {
            this.Close();
        }

        private void Form1_Load(object sender, EventArgs e)
        {
            dgv();
            SetdgvWorkerText();
        }
    }
}