c# DbHelper

    class DBHelper
    {
        public static string connstr = "server=;database;uid=;pwd=;";
        public int ExecuteNoQuery(string sql,params SqlParameter[] param)
        {
            using (SqlConnection conn = new SqlConnection(connstr))
            {
                conn.Open();
                using(SqlCommand cmd=conn.CreateCommand())
                {
                    cmd.CommandText = sql;
                    cmd.Parameters.AddRange(param);
                    return cmd.ExecuteNonQuery();
                }
            }
        }
        public Object ExecuteScalar(string sql, params SqlParameter[] param)
        {
            using (SqlConnection conn = new SqlConnection(connstr))
            {
                conn.Open();
                using (SqlCommand cmd = conn.CreateCommand())
                {
                    cmd.CommandText = sql;
                    cmd.Parameters.AddRange(param);
                    return cmd.ExecuteScalar();
                }
            }
        }
        public DataTable ExecuteTable(string sql,params SqlParameter[] param)
        {
            using (SqlConnection conn = new SqlConnection(connstr))
            {
                conn.Open();
                using (SqlCommand cmd = conn.CreateCommand())
                {
                    cmd.CommandText = sql;
                    cmd.Parameters.AddRange(param);
                    SqlDataAdapter adapter = new SqlDataAdapter(cmd);
                    DataTable dt = new DataTable();
                    adapter.Fill(dt);
                    return dt;
                }
            }
        }
        public void FillListView(ListView lv,DataTable dt,params string[] headers)
        {
            lv.Clear();
            lv.BeginUpdate();
            for (int i = 0; i < headers.Length;i++ )
            {
                lv.Columns.Add(headers[i],lv.Width/headers.Length-2);
            }
            for (int i = 0; i < dt.Rows.Count;i++ )
            {
                ListViewItem item = new ListViewItem();
                item.Text = dt.Rows[i][0] + "";
                for(int j=1;j<dt.Columns.Count;j++)
                {
                    item.SubItems.Add(dt.Rows[i][j] + "");
                }
                lv.Items.Add(item);
            }
            lv.EndUpdate();
        }
    }

　　

转载于:https://www.cnblogs.com/liuzhan709/p/scut_dbhelper.html