将数据表分配给数据集 [英] assign datatable to dataset

问题描述

我有数据表dt_vendor

i希望将所有数据从dt_vendor传输到数据集ds [vendor]

解决方案

简单方法：将DataTable添加到DataSet对象：

 DataTable originalData = LoadDataTableFromExcel（path）; 
 DataSet ds =  new  DataSet（）; 
 originalData.TableName =   vendor; 
 ds.Tables.Add（originalData）; 
 DataTable dt = ds.Tables [  vendor]; 
 

Quote：

我想转移所有的数据从dt_vendor到数据集ds [vendor]

我解释这个与其他数据有所不同，并假设您确实希望将每行从dt_vendor传输到数据集ds中名为vendor的表中msgstr（ int i = dt_vendor.Rows.Count - 1 ; i > -1 ; i - = 1 ）
{
ds.Tables [ 供应商] ImportRow（dt_vendor.Rows [I]）。
dt_vendor.Rows [i] .Delete（）;
}

点击此处

I have datatable dt_vendor
i want to transfer all the data from dt_vendor to dataset ds["vendor"]

解决方案

Easy way: Add the DataTable to the DataSet object:

DataTable originalData = LoadDataTableFromExcel(path);
DataSet ds = new DataSet();
originalData.TableName = "vendor";
ds.Tables.Add(originalData);
DataTable dt = ds.Tables["vendor"];

Quote:

i want to transfer all the data from dt_vendor to dataset ds["vendor"]

I am interpreting this a bit differently than the others have and assume that you literally want to transfer each row from dt_vendor into a table named "vendor" in the dataset "ds".

for (int i = dt_vendor.Rows.Count - 1; i > -1; i -= 1)
{
    ds.Tables["vendor"].ImportRow(dt_vendor.Rows[i]);
    dt_vendor.Rows[i].Delete();
}

Click here

这篇关于将数据表分配给数据集的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！