创建一个新表 [英] Create a new table

问题描述

嗨
我们如何从C#数据库中的现有表创建新表.如何仅复制该表中的选定行.

Hi
How do we create new table from a existing table in database in c#. How to copy only selected rows from that table.

推荐答案

嗨
请尝试以下操作:

//具有两列Id和Name的数据表
昏暗的dtbook作为DataTable；
//过滤那些书号为< = 10
的行 DataView dvbook = dtbook.DefaultView.RowFilter ="Id< = 10";

//仅复制原始书本表的结构
DataTable dtFilterBook = dtbook.Clone();
//创建新表以存储过滤器记录
foreach(dvbook中的DataRowView rowView)
{
dtFilterBook.ImportRow(rowView);
}

:)
谢谢&问候，
Imdad

Hi
please try following:

//Datatable with two column Id and Name
Dim dtbook As DataTable;
//Filter those rows having book id <= 10
DataView dvbook = dtbook.DefaultView.RowFilter = "Id<=10";

//Copy only structured of orizinal book table
DataTable dtFilterBook = dtbook.Clone();
//Create new table to store filter records
foreach(DataRowView rowView in dvbook)
{
dtFilterBook.ImportRow(rowView);
}

:)
Thanks & Regards,
Imdad

您可以在此处使用ImportRows.选中此 [ ^ ]链接.

You can make use of ImportRows here. Check this[^] link.

这篇关于创建一个新表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！