C#对sqlserver数据库访问、操作的代码

以下是调用例子：

public static DataTable GetUserInfo(string UserID)
        {
            string sql = "select * from V_User where UserID = @UserID";
            List<SqlParameter> paras = new List<SqlParameter>(){
                new SqlParameter("@UserID",UserID),
            };
            return Util.DBHelper.Select(sql, paras);
        }

public static string Add(string Title, byte[] Body, string UserID)
        {
            if (Title == "")
            {
                return "标题不能为空";
            }
            string sql = "insert into Notice(ID,Title,Body,Enable,UserID) values(newid(),@Title,@Body,'Y',@UserID)";
            List<SqlParameter> paras = new List<SqlParameter>() {
                new SqlParameter("@Title",Title),
                new SqlParameter("@Body",Body),
                new SqlParameter("@UserID",UserID),
            };

            return Util.DBHelper.Action(sql, paras);
        }

List<string> sqlList = new List<string>();
            List<List<SqlParameter>> values = new List<List<SqlParameter>>();
            for (int i = 0; i < dgv.Rows.Count; i++)
            {
                if ((bool)dgv.Rows[i].Cells[0].EditedFormattedValue == true)
                {
                    if (this.dgv.Rows[i].Cells["KW"].Value == null || this.dgv.Rows[i].Cells["KW"].Value.ToString() == "")
                    {
                        MessageBox.Show("您存在物料没有填写库位", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
                        return;
                    }
                    sqlList.Add("insert into BG_CWLC(DJH,SCDD,GX,GZZX,LPSL,BLPSL,RGGS,JQGS,WLBM,WLMS,YDLX,GC,KW,PCGL,PC,SL,DW,CFSL,STATUS,UserID,BZSL) " +
                        "values('" + DJH + "','" + SCDD + "','" + GX + "','" + GZZX + "','" + LPSL + "','" + BLPSL + "','" + RGGS + "','" + JQGS 
                        + "','" + Convert.ToString(this.dgv.Rows[i].Cells[1].Value)
                        + "','" + Convert.ToString(this.dgv.Rows[i].Cells[2].Value)
                        + "','" + Convert.ToString(this.dgv.Rows[i].Cells[3].Value)
                        + "','" + Convert.ToString(this.dgv.Rows[i].Cells[4].Value)
                        + "','" + Convert.ToString(this.dgv.Rows[i].Cells[5].Value)
                        + "','" + Convert.ToString(this.dgv.Rows[i].Cells[6].Value)
                        + "','" + Convert.ToString(this.dgv.Rows[i].Cells[7].Value)
                        + "','" + Convert.ToString(this.dgv.Rows[i].Cells["SL"].Value)
                        + "','" + Convert.ToString(this.dgv.Rows[i].Cells["DW2"].Value)
                        + "','" + Convert.ToString(this.dgv.Rows[i].Cells["CFSL"].Value)
                        + "','" + "财务审批"
                        + "','" + Util.Configure.UserID
                        + "','" + Convert.ToString(this.dgv.Rows[i].Cells["BZSL"].Value) + "')");
                    values.Add(new List<SqlParameter>() {
                    });

                    cnt++;
                }
            }
            string rst = Util.DBHelper.ExecuteSqlTran(sqlList, values);
            if (rst != "")
            {
                MessageBox.Show(rst, "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
                return;
            }            

有查询、操作的方法，已封装好：

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

namespace LIPSystem.Util
{
    public class DBHelper
    {
        /// <summary>