动态生成Table、DataSet
来源:互联网 发布:出国游经济好玩知乎 编辑:程序博客网 时间:2024/06/05 19:48
QueryMSMQList queryMSMQ = new QueryMSMQList(".//private$//coreexchange"); List<QueryMSMQCommon> queryList = queryMSMQ.mReceive(); DataSet dsQueueMSMQ = new DataSet(); DataTable dsQueueTable = new DataTable(); DataColumn cTransactionId = new DataColumn("事务ID"); DataColumn cSender = new DataColumn("文档发送方"); DataColumn cReceive = new DataColumn("文档接收方"); DataColumn cReceiveTime = new DataColumn("文档接收时间"); dsQueueTable.Columns.Add(cTransactionId); dsQueueTable.Columns.Add(cSender); dsQueueTable.Columns.Add(cReceive); dsQueueTable.Columns.Add(cReceiveTime); dsQueueMSMQ.Tables.Add(dsQueueTable); DataRow[] dataRow = new DataRow[queryList.Count]; for (int i = 0; i < queryList.Count; i++) { dataRow[i] = dsQueueTable.NewRow(); dataRow[i][0] = queryList[i].TransactionID; dataRow[i][1] = queryList[i].Sender; string sReceive = null; for (int iReceive = 0; iReceive < queryList[i].Receive.Count; iReceive++) { sReceive = queryList[i].Receive[iReceive] + "," + sReceive; } dataRow[i][2] = sReceive; dataRow[i][3] = queryList[i].ReceiveTime; dsQueueTable.Rows.Add(dataRow[i]); } dataGridView1.DataSource = dsQueueMSMQ.Tables[0];第一步:创建dataset对象:DataSet dsQueueMSMQ = new DataSet();第二步创建table对象:DataTable dsQueueTable = new DataTable();第三步:创建DataColumn 对象: DataColumn cTransactionId = new DataColumn("事务ID"); DataColumn cSender = new DataColumn("文档发送方"); DataColumn cReceive = new DataColumn("文档接收方"); DataColumn cReceiveTime = new DataColumn("文档接收时间");第四步:把所有的列加入table中,把table加入dataset中: dsQueueTable.Columns.Add(cTransactionId); dsQueueTable.Columns.Add(cSender); dsQueueTable.Columns.Add(cReceive); dsQueueTable.Columns.Add(cReceiveTime); dsQueueMSMQ.Tables.Add(dsQueueTable);第五步:创建dataRow对象并且把rows加入table中:for (int i = 0; i < queryList.Count; i++) { dataRow[i] = dsQueueTable.NewRow(); dataRow[i][0] = queryList[i].TransactionID; dataRow[i][1] = queryList[i].Sender; string sReceive = null; for (int iReceive = 0; iReceive < queryList[i].Receive.Count; iReceive++) { sReceive = queryList[i].Receive[iReceive] + "," + sReceive; } dataRow[i][2] = sReceive; dataRow[i][3] = queryList[i].ReceiveTime; dsQueueTable.Rows.Add(dataRow[i]); }
- 动态生成Table、DataSet
- DataSet动态生成字段
- javascript动态生成table
- 动态生成table
- 动态生成table列表
- 动态生成table
- 动态生成Table
- Jquery动态生成table
- jsp动态生成table
- ajax动态生成table
- ajax动态生成table
- JS动态生成Table
- 动态生成table
- ajax动态生成table
- js动态生成table【转】js动态生成table【转】
- 用DWRUtil动态生成Table
- js动态生成table 经典
- 动态生成HTMLTable,table,DataTable
- Java面向对象
- QT4.4.3与VS2005集成开发环境
- 深入浅出REST
- 大脚车——破坏之旅 (Monster Jam Path of Destruction)
- Netty通讯小框架-测试服务器支持用户数量
- 动态生成Table、DataSet
- 日本的人才观:胸无大志,国家栋梁
- VB2005中按照16进制读取串口缓冲区数据
- STL vector用法介绍
- Linux 系统操作
- 来信, 创业 和 移动互联网
- window service时遇到的问题
- linux ubuntu10.10 文件解压之后乱码问题汇总
- C#条形码生成(三)----简单的三种Code128实现