liuyinlong

导航

随笔分类 -  winform

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

posted @ 2012-03-28 22:53 liuyinlong 阅读(238) 评论(0) 推荐(1)

DataGridViewRow转换为DataRow
摘要:编辑器加载中... 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 阅读全文

posted @ 2012-03-17 20:44 liuyinlong 阅读(8289) 评论(1) 推荐(0)

TreeView 控件应用
摘要: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(); 阅读全文

posted @ 2011-08-18 17:08 liuyinlong 阅读(473) 评论(2) 推荐(1)

Datatable 去除重复行
摘要:DataTable dt = new DataTable(); dt = customer.GetArea(); DataView dv = dt.DefaultView; DataTable dtProvince = dv.ToTable(true, "province", "provinceid"); 阅读全文

posted @ 2011-08-18 16:35 liuyinlong 阅读(1187) 评论(0) 推荐(2)