winform dataGridView 自定义模版列 示例源码下载

NPOI 不安装office 创建和读取office文件 包括 excel和word文件 项目完整源码下载

石英时钟实例源码，仅供参考学习使用，效果很不错哦

加密RAR压缩文件后，再打开的时候 需要输入密码才可以

C#制作的 BT种子生成器 含完整源码下载

修改 webbrowser 支持IE8/IE9/IE10/HTML5 (webbrowser默认为IE7模式)

[实例简介] 连接sql数据库 类 [核心代码]using System;using System.Collections.Generic;using System.Linq;using System.Text;using System.Configuration;using System.Data.SqlClient;using System.Data; namespace Itcast.Cn{ public static class SqlHelper { private static readonly string conStr = ConfigurationManager.ConnectionStrings["connStr"].ConnectionString; //执行增删改的 public static int ExecuteNonQuery(string sql, CommandType cmdType, params SqlParameter[] pms) { using (SqlConnection con = new SqlConnection(conStr)) { using (SqlCommand cmd = new SqlCommand(sql, con)) { cmd.CommandType = cmdType; if (pms != null) { cmd.Parameters.AddRange(pms); } con.Open(); return cmd.ExecuteNonQuery(); } } } //封装一个执行返回单个值的方法 public static object ExecuteScalar(string sql, CommandType cmdType, params SqlParameter[] pms) { using (SqlConnection con = new SqlConnection(conStr)) { using (SqlCommand cmd = new SqlCommand(sql, con)) { cmd.CommandType = cmdType; if (pms != null) { cmd.Parameters.AddRange(pms); } con.Open(); return cmd.ExecuteScalar(); } } } //返回SqlDataReader对象的方法 public static SqlDataReader ExecuteReader(string sql, CommandType cmdType, params SqlParameter[] pms) { SqlConnection con = new SqlConnection(conStr); using (SqlCommand cmd = new SqlCommand(sql, con)) { cmd.CommandType = cmdType; if (pms != null) { cmd.Parameters.AddRange(pms); } try { con.Open(); return cmd.ExecuteReader(CommandBehavior.CloseConnection); } catch (Exception) { con.Close(); con.Dispose(); throw; } } } //封装一个返回DataTable的方法 public static DataTable ExecuteDataTable(string sql, CommandType cmdType, params SqlParameter[] pms) { DataTable dt = new DataTable(); using (SqlDataAdapter adapter = new SqlDataAdapter(sql, conStr)) { adapter.SelectCommand.CommandType = cmdType; if (pms != null) { adapter.SelectCommand.Parameters.AddRange(pms); } adapter.Fill(dt); } return dt; } //封装一个带事务的执行Sql语句的方法 public static void ExecuteNonQueryTran(List list) { using (SqlConnection con = new SqlConnection(conStr)) { using (SqlCommand cmd = con.CreateCommand()) { con.Open(); using (SqlTransaction trans = con.BeginTransaction()) { cmd.Transaction = trans; try { foreach (var SqlObject in list) { cmd.CommandText = SqlObject.Sql; if (SqlObject.Parameters != null) { cmd.Parameters.AddRange(SqlObject.Parameters); } cmd.CommandType = SqlObject.CmdType; cmd.ExecuteNonQuery(); cmd.Parameters.Clear(); } trans.Commit(); } catch (Exception) { trans.Rollback(); } } } } } } public class SqlAndParameter { public string Sql { get; set; } public SqlParameter[] Parameters { get; set; } public CommandType CmdType { get; set; } }}

使用方法： 初始化这个列表头 DatagridViewCheckBoxHeaderCell cbHeader = new DatagridViewCheckBoxHeaderCell(); cbHeader.Value = ""; SelectUin.HeaderCell = cbHeader; cbHeader.OnCheckBoxClicked = new CheckBoxClickedHandler(cbHeader_OnCheckBoxClicked); 填写你的全选的业务逻辑 void cbHeader_OnCheckBoxClicked(bool Status) { for (int i = 0; i < this.dataGridView1.Rows.Count; i ) { dataGridView1.Rows[i].Cells["SelectUin"].Value = Status; } }

打印dataGridView内容

c# 动态扩展类型 示例源码

asp.net qq表情功能实现