liuyinlong

摘要： //设置边距 /pd.OriginAtMargins = true; 阅读全文

摘要： //DataRow[] 转换成DataTableDataTable dtInsert = dtSource.Select("goodrecever = '" + strgoodrecever + "'").CopyToDataTable(); 阅读全文

摘要： 编辑器加载中... DataTable dt = I_IDOM_DyIntQuery.QueryDyInt(SelectedInfo()); dgvDynQuery.DataSource = dt; DataTable dd = new DataTable(); dd = dt.Clone();//赋值结构 foreach (DataGridViewRow dgvr in dgvDynQuery.Rows) { DataRow dr = dd.NewRow(); dr = (dgvr.DataBoundItem as DataRowView).Row;//微软提供的唯一的转换DataRow d 阅读全文

摘要： 今天写了个SQL语句，但是速度总是很慢，后来做些改动速度提升了几倍，记录下来心得，一起分享讨论！如：（1） select * from Aleft join Bon A.b = B.b left join C on A.c = C.c where 1=1and A.d = 'XXXXX' and A.e = 'SSSSS'和（2）select * from (select * from Aleft join Bon A.b = B.b left join C on A.c = C.c ) aa where aa.d = 'XXXXX' and a 阅读全文

摘要： 1、 (数据库设计如上)2、代码： private void SetArea() { DataTable dt = new DataTable(); dt = customer.GetArea(); DataView dv = dt.DefaultView; DataTable dtProvince = dv.ToTable(true, "province", "provinceid"); for (int i = 0; i < dtProvince.Rows.Count; i++) { TreeNode nd = new TreeNode(); 阅读全文

摘要： DataTable dt = new DataTable(); dt = customer.GetArea(); DataView dv = dt.DefaultView; DataTable dtProvince = dv.ToTable(true, "province", "provinceid"); 阅读全文