摘要: /// /// 对DataTable进行分页,起始页为1 /// /// /// /// /// public static DataTable ... 阅读全文
posted @ 2015-01-30 10:01 bobo-bobo 阅读(666) 评论(0) 推荐(0) 编辑
摘要: public static DataTable ToDataTable(this DataGridView dataGridView, string tableName = null) { DataGridView dgv = dataGridVi... 阅读全文
posted @ 2014-12-26 16:28 bobo-bobo 阅读(2040) 评论(0) 推荐(0) 编辑
摘要: 方法一:代码 /// /// 删除指定控件的指定事件 /// /// /// public void ClearEvent(System.Windows.Forms.Control control, stri... 阅读全文
posted @ 2014-12-25 10:24 bobo-bobo 阅读(6699) 评论(0) 推荐(0) 编辑
摘要: select distinct name from syscomments a,sysobjects b where a.id=b.id and b.xtype='p' --and text like '%my_sp%' 阅读全文
posted @ 2014-12-22 10:36 bobo-bobo 阅读(614) 评论(0) 推荐(0) 编辑
摘要: 1、在面试的时候碰到一个 问题,就是让写一张表中有id和name 两个字段,查询出name重复的所有数据,现在列下:select * from xi a where (a.username) in (select username from xi group by username having... 阅读全文
posted @ 2014-12-12 14:51 bobo-bobo 阅读(412) 评论(0) 推荐(0) 编辑
摘要: public class Converter { private static String keys = "0123456789abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ";//编码,可加一些字符也可以实现7... 阅读全文
posted @ 2014-12-12 14:14 bobo-bobo 阅读(331) 评论(0) 推荐(0) 编辑
摘要: System.Guid.NewGuid().ToString() 阅读全文
posted @ 2014-12-11 11:18 bobo-bobo 阅读(140) 评论(0) 推荐(0) 编辑
摘要: public static bool SearchDGV(DataGridView DGV, string strTxt, bool UpSearch = true, bool Show = false) { int row = DGV.Rows.... 阅读全文
posted @ 2014-12-11 08:58 bobo-bobo 阅读(1930) 评论(0) 推荐(0) 编辑
摘要: public static bool ContrastColumns(DataColumnCollection co1, DataGridViewColumnCollection co2) { bool aa = false; ... 阅读全文
posted @ 2014-12-10 15:54 bobo-bobo 阅读(322) 评论(0) 推荐(0) 编辑
摘要: static class ClassExtension { public static string NullableToString(this object o) { try { r... 阅读全文
posted @ 2014-12-10 15:52 bobo-bobo 阅读(124) 评论(0) 推荐(0) 编辑