SQLHelper公共类，最好标准版

View Code

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data.SqlClient;
using System.Data;
public class SQlHelper
{
public static string connecting ="Data Source= ;User ID= ;PWD=  ;Initial Catalog=  ";////将自己的数据库填好
 public static int ExcuteNonQuery(string cmdText,params SqlParameter [] parameter)
    {
        using (SqlConnection conn = new SqlConnection(connecting))
        {
            conn.Open();
            using (SqlCommand cmd=conn.CreateCommand ())
            {
                cmd.CommandText = cmdText;
                cmd.Parameters.AddRange(parameter );
                return cmd.ExecuteNonQuery();
            }
        }
    }

    public static DataTable ExcuteDataTable(string cmdText,params SqlParameter [] parameters)
    {
        using (SqlConnection conn = new SqlConnection(connecting))
        {
            conn.Open();
            using (SqlCommand cmd = conn.CreateCommand())
            {
                cmd.CommandText = cmdText;
                cmd.Parameters.AddRange(parameters );
                using (SqlDataAdapter adapter = new SqlDataAdapter(cmd))
                {
                    DataTable dt = new DataTable();
                    adapter.Fill(dt);
                    return dt;
                }
            }
        }
    }
}

目前我所使用的发现就这两个就可以都用了，等再有了新的添加 ，我会继续给加上的。

转载于:https://www.cnblogs.com/nowaycw/archive/2013/03/21/2972553.html