数据表添加到数据集

2024-01-09

我需要为数据集设置一个表

DataSet ds = EventDal.GetEvents();
DataSet dsReturn = new DataSet();
DataTable dtReturn = dsReturn.Tables.Add();
dtReturn.Columns.Add("id");
dtReturn.Columns.Add("description");
dtReturn.Columns.Add("status");

foreach (DataRow row in ds.Tables[0].Rows)
{
  if(Convert.ToInt32(row[1]) == status )
  {
    DataRow newrowdata = dtReturn.NewRow();
    dsReturn.Tables["dtReturn"].ImportRow((row));///i'm getting object ref not set to an instance of object..
    //DataRow drReturn = dtReturn.NewRow();
    //dsReturn.Tables["dtReturn"].Rows.Add(row);
  }
}
return dsReturn;

DataSet customerOrders = new DataSet("CustomerOrders");

DataTable ordersTable = customerOrders.Tables.Add("Orders");

DataColumn pkOrderID = 
    ordersTable.Columns.Add("OrderID", typeof(Int32));
ordersTable.Columns.Add("OrderQuantity", typeof(Int32));
ordersTable.Columns.Add("CompanyName", typeof(string));

ordersTable.PrimaryKey = new DataColumn[] { pkOrderID };
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)

数据表添加到数据集 的相关文章

随机推荐