如何将多个数据表添加到单个数据集 [英] How to add more than one datatable to single DataSet

问题描述

dtAllProducts ， dtAllUnits，

Hai,

  I need to add following datatable(dtAllProducts,dtAllUnits,dtFinancialYear)in single data set, how can i do it?

public

 

GetRatingAndLimitsDetails( 字符串

DataSet GetRatingAndLimitsDetails(string strUserId)

 

{

 

数据集 dsRatingLimits = 数据集

DataSet dsRatingLimits = new DataSet();

 

数据集 ds = 数据集

DataSet ds=new DataSet();

 

数据库 db = ;

 

Database db = null;

 

DbCommand dbCommand = ;

 

DbCommand dbCommand = null;

 

DataTable dtFinancialYear = ;

 

DataTable dtFinancialYear = null;

 

DataTable dtAllUnits = ;

 

DataTable dtAllUnits = null;

 

DataTable dtAllProducts = ;

 

DataTable dtAllProducts = null;

 

尝试

{

db =

DatabaseFactory .CreateDatabase();

dbCommand = db.GetStoredProcCommand(

DatabaseFactory.CreateDatabase();

dbCommand = db.GetStoredProcCommand(

"PK_ORS_BUDGET_ENTRY.PR_GET_FINANCIAL_YEAR" ，

"PK_ORS_BUDGET_ENTRY.PR_GET_FINANCIAL_YEAR", "");

ds = db.ExecuteDataSet(dbCommand);

dtFinancialYear = ds.Tables [0];

dtFinancialYear = ds.Tables[0];

 

//dsRatingLimits.Tables.Add(dtFinancialYear );

ds.AcceptChanges();

ds.AcceptChanges();

dtFinancialYear.AcceptChanges();

dtFinancialYear.AcceptChanges();

ds =

新 ();

dbCommand = db.GetStoredProcCommand(

new DataSet();

dbCommand = db.GetStoredProcCommand(

" PK_ORS_COUNTER_PARTY.PR_Get_All_Units" ，strUserId，

"PK_ORS_COUNTER_PARTY.PR_Get_All_Units", strUserId, "");

ds = db.ExecuteDataSet(dbCommand);

dtAllUnits = ds.Tables [0];

dtAllUnits = ds.Tables[0];

 

//dsRatingLimits.Tables.Add(dtAllUnits );

ds.AcceptChanges();

ds.AcceptChanges();

dtAllUnits.AcceptChanges();

dtAllUnits.AcceptChanges();

ds =

新 ();

 

new DataSet();

 

//dsRatingLimits.Tables.Add(dtFinancialYear );

dbCommand = db.GetStoredProcCommand(

dbCommand = db.GetStoredProcCommand(

"PK_ORS_COUNTER_PARTY.PR_Products" ，strUserId，

"PK_ORS_COUNTER_PARTY.PR_Products", strUserId, "");

ds = db.ExecuteDataSet(dbCommand);

dtAllProducts = ds.Tables [0];

dtAllProducts = ds.Tables[0];

 

//dsRatingLimits.Tables.Add(dtAllProducts );

 

//返回dsRatingLimits;

 

返回 ds;

}

return ds;

}

 

捕获 ( e)

{

catch (Exception e)

{

 

扔 e;

}

throw e;

}

 

最终

{

db =

空 ;

}

null;

}

 

返回 dsRatingLimits;

 

return dsRatingLimits;

 

}

#endregion

#endregion

 

 

公共 GetPartyUnits( 字符串

public DataTable GetPartyUnits(string strUserId)

{

 

数据库 db = ;

 

Database db = null;

 

DataTable dt = 数据表 单位" );

 

DataTable dt = new DataTable("Units");

 

DbCommand dbCommand = ;

 

DbCommand dbCommand = null;

 

StringBuilder sb = ;

 

StringBuilder sb = null;

 

数据集 ds = 数据集

DataSet ds = new DataSet();

 

尝试

{

db =

DatabaseFactory .CreateDatabase();

dbCommand = db.GetStoredProcCommand(

DatabaseFactory.CreateDatabase();

dbCommand = db.GetStoredProcCommand(

" PK_ORS_COUNTER_PARTY.PR_Get_All_Units" ，strUserId，

"PK_ORS_COUNTER_PARTY.PR_Get_All_Units", strUserId, "");

ds = db.ExecuteDataSet(dbCommand);

 

dt = ds.Tables [0];

dt = ds.Tables[0];

 

返回 dt;

 

return dt;

 

}

 

捕获 ( e)

{

catch (Exception e)

{

 

扔 e;

}

throw e;

}

 

最终

{

db =

空 ;

}

null;

}

}

推荐答案

Uday，

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