C#实现添加记录

来源：互联网发布：音乐慢放编辑软件编辑：程序博客网时间：2024/05/22 15:59

类

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

namespace WindowsApplication1.Classes
{
    class DataAccess
    {
        private SqlConnection sqlConn;

        public DataAccess(string connectionString)
        {
            if(sqlConn==null)
            {
                sqlConn = new SqlConnection(connectionString);
            }
        }

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

        #region 生成SqlCommand
        private SqlCommand BuildCommand(string sen, CommandType Type, SqlParameter[] parameters)
        {
            SqlCommand command = new SqlCommand();

            command.Connection = sqlConn;
            command.CommandText = sen;
            command.CommandType = Type;

            foreach (SqlParameter parameter in parameters)
            {
                command.Parameters.Add(parameter);
            }
            return command;
        }
        #endregion

        #region 运行存储过程，对数据表进行操作
        public void RunProcedure(string ProcedureName, SqlParameter[] parameters)
        {
            SqlCommand command = BuildCommand(ProcedureName, CommandType.StoredProcedure, parameters);

            sqlConn.Open();
            command.ExecuteNonQuery();
            sqlConn.Close();

command.Dispose();
}

#endregion

        public class hahadata
        {
            DataAccess da = new DataAccess();
            public void InsertData(string userName, string userPass)
            {
                SqlParameter[] parameters ={
                    new SqlParameter("@userName",SqlDbType.NVarChar,20),
                    new SqlParameter("@userPass",SqlDbType.NVarChar,20)};
                parameters[0].Value = userName;
                parameters[1].Value = userPass;

da.RunProcedure("InsertUser", parameters);

}
}

}
}
窗体

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using WindowsApplication1.Classes;

//这里你不管，我用的是Oracle数据库
//using System.Data.OracleClient;

namespace WindowsApplication1
{
    public partial class Form1 : Form
    {
        Classes.DataAccess.hahadata ud = new DataAccess.hahadata();
        public Form1()
        {
            InitializeComponent();
        }

        private void button1_Click(object sender, EventArgs e)
        {
            try
            {
                ud.InsertData(textBox1.Text.Trim(), textBox2.Text.Trim());
                textBox1.Text = "";
                textBox2.Text = "";
                MessageBox.Show("添加成功！");
            }
            catch
            { }
        }
    }
}