Make life better.

摘要： System.Reflection.Assembly curAssembly = System.Reflection.Assembly.GetExecutingAssembly(); curAssembly.Location取当前目录. 阅读全文

摘要： 代码代码 阅读全文

摘要： DataTable dt = new DataTable(); dt.Columns.Add(new DataColumn("fldHireTime",typeof(DateTime))); DateTime now = DateTime.Now; dt.Rows.Add(now); //dt.Rows.Add(now.ToString());//如果这样输出为1 object obj = dt.Compute("count(fldHireTime)", string.Format("fldHireTime='{0}' ",now) ); Console.WriteLine(obj.ToStr 阅读全文

摘要： --获取SqlServer中表结构 主键，及描述declare @table_name as varchar(max)set @table_name = 'dbTypes' select sys.columns.name, sys.types.name, sys.columns.max_length, sys.columns.is_nullable, (select count(*) from sys.identity_columns where sys.identity_columns.object_id = sys.columns.object_id and sys.columns.co 阅读全文

摘要： DataSet ds = new DataSet(); DataTable dt1 = Common.TestData.StudentTable.Copy(); dt1.TableName = "dt1"; DataTable dt2 = Common.TestData.StudentTable.Copy(); dt2.TableName = "dt2"; ds.Tables.Add(dt1); ds.Tables.Add(dt2); DataRelation relation = new DataRelation("Level2", ds.Tables[0].Columns[0], ds.T 阅读全文

摘要： DevExpress.XtraGrid.StyleFormatCondition StyleFormatCondition1 = new DevExpress.XtraGrid.StyleFormatCondition(); StyleFormatCondition1.Appearance.BackColor = System.Drawing.Color.Red; StyleFormatCondition1.Appearance.BackColor2 = Color.White; StyleFormatCondition1.Appearance.Options.UseBackColor = t 阅读全文

摘要： SET STATISTICS TIME ON--开始SELECT * FROM SYSOBJECTS --你的查询SET STATISTICS TIME OFF--结束/*SQL Server 执行时间: CPU 时间 = 0 毫秒，占用时间 = 2597 毫秒。*/---------------------declare @begin datetimeset @begin=getdate()--你的语句select [花费时间(毫秒)]=datediff(ms,@begin,getdate()) 阅读全文

摘要： //// summary /// 把一般的查询sql处理成分页用的sql 用于sql2005以上 /// /summary /// param name="sql"一般的sql/param /// param name="pn"当前页数/param /// param name="countPerPage"每一页的个数/param /// returns返回分页用的sql/returns public static string SQLFenyeChuli(string sql, int pn, int countPerPage) { try { str 阅读全文

摘要： this.gridView1.GroupSummary.AddRange(new DevExpress.XtraGrid.GridSummaryItem[] { new DevExpress.XtraGrid.GridGroupSummaryItem(DevExpress.Data.SummaryItemType.Count, "Subject", null, "({0} items)")}); 阅读全文

摘要： adapter在填充数据时是通过dataReader来进行的，其分页仍会对所有数据进行读取下面是对Aapter.Fill的测试 DataTable dt1 = new DataTable(); DataTable dt2 = new DataTable(); DataTable dt3 = new DataTable(); SqlDataAdapter adapterA = DbHelperSQL... 阅读全文