本文整理汇总了C#中System.Data.DataSet.Clone方法的典型用法代码示例。如果您正苦于以下问题:C# DataSet.Clone方法的具体用法?C# DataSet.Clone怎么用?C# DataSet.Clone使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类System.Data.DataSet
的用法示例。
在下文中一共展示了DataSet.Clone方法的15个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: Load_catesearch
private void Load_catesearch()
{
var list = per.Load_danhmuc_search(1);
if (list.Count > 0)
{
DataRelation relCat;
DataTable tbl = DataUtil.LINQToDataTable(list);
DataSet ds = new DataSet();
ds.Tables.Add(tbl);
tbl.PrimaryKey = new DataColumn[] { tbl.Columns["CAT_ID"] };
relCat = new DataRelation("Category_parent", ds.Tables[0].Columns["CAT_ID"], ds.Tables[0].Columns["CAT_PARENT_ID"], false);
ds.Relations.Add(relCat);
DataSet dsCat = ds.Clone();
DataTable CatTable = ds.Tables[0];
DataUtil.TransformTableWithSpace(ref CatTable, dsCat.Tables[0], relCat, null);
Drcate_search.DataSource = dsCat.Tables[0];
Drcate_search.DataTextField = "CAT_NAME";
Drcate_search.DataValueField = "CAT_ID";
Drcate_search.DataBind();
}
ListItem l = new ListItem("Tất cả", "0");
l.Selected = true;
Drcate_search.Items.Insert(0, l);
}
示例2: Loadchuyenmuc
public void Loadchuyenmuc()
{
try
{
var CatList = (
from t2 in DB.ESHOP_CATEGORies
where t2.CAT_RANK > 0
select new
{
CAT_ID = t2.CAT_NAME == "------- Root -------" ? 0 : t2.CAT_ID,
CAT_NAME = (string.IsNullOrEmpty(t2.CAT_CODE) ? t2.CAT_NAME : t2.CAT_NAME + "(" + t2.CAT_CODE + ")"),
CAT_NAME_EN = (string.IsNullOrEmpty(t2.CAT_CODE_EN) ? t2.CAT_NAME_EN : t2.CAT_NAME_EN + "(" + t2.CAT_CODE_EN + ")"),
CAT_PARENT_ID = t2.CAT_PARENT_ID,
CAT_RANK = t2.CAT_RANK
}
);
if (CatList.ToList().Count > 0)
{
DataRelation relCat;
DataTable tbl = DataUtil.LINQToDataTable(CatList);
DataSet ds = new DataSet();
ds.Tables.Add(tbl);
tbl.PrimaryKey = new DataColumn[] { tbl.Columns["CAT_ID"] };
relCat = new DataRelation("Category_parent", ds.Tables[0].Columns["CAT_ID"], ds.Tables[0].Columns["CAT_PARENT_ID"], false);
ds.Relations.Add(relCat);
DataSet dsCat = ds.Clone();
DataTable CatTable = ds.Tables[0];
DataUtil.TransformTableWithSpace(ref CatTable, dsCat.Tables[0], relCat, null);
ddlCategory.DataSource = dsCat.Tables[0];
ddlCategory.DataTextField = "CAT_NAME";
ddlCategory.DataValueField = "CAT_ID";
ddlCategory.DataBind();
}
ListItem l = new ListItem("------ Chọn chuyên mục ------", "0", true);
l.Selected = true;
ddlCategory.Items.Insert(0, l);
}
catch (Exception ex)
{
clsVproErrorHandler.HandlerError(ex);
}
}
示例3: GetNhatKyTheoNgay
public static DataSet GetNhatKyTheoNgay(PLMultiCombobox NV_ID, DateTime TuNgay, DateTime DenNgay)
{
DataSet ds = new DataSet();
DatabaseFB db = HelpDB.getDatabase();
DbCommand cmd = db.GetStoredProcCommand("IN_NHAT_KY_CONG_VIEC");
db.AddInParameter(cmd, "@TUNGAY", DbType.DateTime, TuNgay);
db.AddInParameter(cmd, "@DENNGAY", DbType.DateTime, DenNgay);
db.LoadDataSet(cmd, ds, "IN_NHAT_KY_CONG_VIEC");
#region Lọc lại dữ liệu trên DataSet
DataRow[] dsrow = ds.Tables[0].Select("NV_ID in " + NV_ID._getStrSelectedIDs());
DataSet NewDs = ds.Clone();
foreach (DataRow item in dsrow)
NewDs.Tables[0].ImportRow(item);
#endregion
return NewDs;
}
示例4: LoadCat
private void LoadCat()
{
try
{
var AllList = (from g in db.TYPE_COMPANies
where g.TYPE_RANK > 0
select new
{
g.TYPE_ID,
g.TYPE_PARENT,
g.TYPE_RANK,
g.TYPE_ACTIVE,
g.ORDERBY,
g.TYPE_NAME
});
if (AllList.ToList().Count > 0)
{
DataRelation relCat;
Session["companies.listmenucha"] = DataUtil.LINQToDataTable(AllList);
DataTable tbl = Session["companies.listmenucha"] as DataTable;
DataSet ds = new DataSet();
ds.Tables.Add(tbl);
tbl.PrimaryKey = new DataColumn[] { tbl.Columns["TYPE_ID"] };
relCat = new DataRelation("TYPE_PARENT", ds.Tables[0].Columns["TYPE_ID"], ds.Tables[0].Columns["TYPE_PARENT"], false);
ds.Relations.Add(relCat);
DataSet dsCat = ds.Clone();
DataTable CatTable = ds.Tables[0];
unit_data.TransformTableWithSpace(ref CatTable, dsCat.Tables[0], relCat, null);
HttpContext.Current.Session["companies.listmenucha"] = dsCat.Tables[0];
ASPxTreeList_menu.DataSource = dsCat.Tables[0];
ASPxTreeList_menu.DataBind();
}
}
catch (Exception ex)
{
clsVproErrorHandler.HandlerError(ex);
}
}
开发者ID:thanhphung901,项目名称:quanly.ketoanvn.com.vn,代码行数:44,代码来源:danh-sach-loai-hinh-doanh-nghiep.aspx.cs
示例5: GetThoiGianLamViec
public static DataSet GetThoiGianLamViec(PLMultiCombobox NV_ID, bool LoaiLV, bool LoaiDTVS, bool LoaiNP, DateTime TuNgay, DateTime DenNgay)
{
DataSet ds = new DataSet();
DatabaseFB db = HelpDB.getDatabase();
DbCommand cmd = db.GetStoredProcCommand("IN_THOI_GIAN_LAM_VIEC");
db.AddInParameter(cmd, "@ILOAILV", DbType.Byte, LoaiLV == true ? 1 : 0);
db.AddInParameter(cmd, "@ILOAIDTVS", DbType.Byte, LoaiDTVS == true ? 2 : 0);
db.AddInParameter(cmd, "@ILOAINP", DbType.Byte, LoaiNP == true ? 3 : 0);
db.AddInParameter(cmd, "@TUNGAY", DbType.DateTime, TuNgay);
db.AddInParameter(cmd, "@DENNGAY", DbType.DateTime, DenNgay);
db.LoadDataSet(cmd, ds, "IN_THOI_GIAN_LAM_VIEC");
#region Lọc lại dữ liệu trên DataSet
DataRow[] dsrow = ds.Tables[0].Select("NV_ID in " + NV_ID._getStrSelectedIDs());
DataSet NewDs = ds.Clone();
foreach (DataRow item in dsrow)
NewDs.Tables[0].ImportRow(item);
#endregion
return NewDs;
}
示例6: SearchResult
private void SearchResult()
{
try
{
string keyword = txtKeyword.Value;
int _limit = 20;
int _skip = 0;
if (_page != 0)
_skip = _page * _limit - _limit;
var AllList = (from g in DB.MENUs
where "" == keyword || g.MENU_NAME.Contains(keyword)
orderby g.ID descending
select g);
if (AllList.ToList().Count > 0)
{
DataRelation relCat;
DataTable tbl = DataUtil.LINQToDataTable(AllList);
DataSet ds = new DataSet();
ds.Tables.Add(tbl);
tbl.PrimaryKey = new DataColumn[] { tbl.Columns["ID"] };
relCat = new DataRelation("Category_parent", ds.Tables[0].Columns["ID"], ds.Tables[0].Columns["MENU_PARENT_ID"], false);
ds.Relations.Add(relCat);
DataSet dsCat = ds.Clone();
DataTable CatTable = ds.Tables[0];
CpanelUtils.TransformTableWithSpace2(ref CatTable, dsCat.Tables[0], relCat, null);
RplistMenu.DataSource = dsCat.Tables[0];
RplistMenu.DataBind();
//LitPage.Text = pagechange.changePage("customer_list.aspx", AllList.ToList().Count, _limit, _page);
}
}
catch (Exception ex)
{
clsVproErrorHandler.HandlerError(ex);
}
}
示例7: LoadMenu
private void LoadMenu()
{
try
{
var AllList = DB.MENUs.Where(n => n.MENU_ACTIVE == 1);
if (AllList.ToList().Count > 0)
{
DataRelation relCat;
DataTable tbl = DataUtil.LINQToDataTable(AllList);
DataSet ds = new DataSet();
ds.Tables.Add(tbl);
tbl.PrimaryKey = new DataColumn[] { tbl.Columns["ID"] };
relCat = new DataRelation("Category_parent", ds.Tables[0].Columns["ID"], ds.Tables[0].Columns["MENU_PARENT_ID"], false);
ds.Relations.Add(relCat);
DataSet dsCat = ds.Clone();
DataTable CatTable = ds.Tables[0];
CpanelUtils.TransformTableWithSpace2(ref CatTable, dsCat.Tables[0], relCat, null);
Drchuyenmuc.DataValueField = "ID";
Drchuyenmuc.DataTextField = "MENU_NAME";
Drchuyenmuc.DataSource = dsCat.Tables[0];
Drchuyenmuc.DataBind();
}
ListItem l = new ListItem("------- Root -------", "0");
l.Selected = true;
Drchuyenmuc.Items.Insert(0, l);
}
catch (Exception ex)
{
clsVproErrorHandler.HandlerError(ex);
}
}
示例8: LoadTypeReg
private void LoadTypeReg(int _id_prof)
{
try
{
//Kiểm tra type của prof
int _type = Utils.CIntDef(ddlType.SelectedValue);
var AllList = (from g in db.TYPE_COMPANies
where g.TYPE_RANK > 0 && (g.TYPE_REG == null || g.TYPE_REG == _type)
select new
{
g.TYPE_ID,
g.TYPE_PARENT,
g.TYPE_RANK,
g.TYPE_NAME
});
if (AllList.ToList().Count > 0)
{
DataRelation relCat;
Session["companies.listmenucha"] = DataUtil.LINQToDataTable(AllList);
DataTable tbl = Session["companies.listmenucha"] as DataTable;
DataSet ds = new DataSet();
ds.Tables.Add(tbl);
tbl.PrimaryKey = new DataColumn[] { tbl.Columns["TYPE_ID"] };
relCat = new DataRelation("TYPE_PARENT", ds.Tables[0].Columns["TYPE_ID"], ds.Tables[0].Columns["TYPE_PARENT"], false);
ds.Relations.Add(relCat);
DataSet dsCat = ds.Clone();
DataTable CatTable = ds.Tables[0];
unit_data.TransformTableWithSpace(ref CatTable, dsCat.Tables[0], relCat, null);
HttpContext.Current.Session["companies.listmenucha"] = dsCat.Tables[0];
ASPxTreeList_menu.DataSource = dsCat.Tables[0];
ASPxTreeList_menu.DataBind();
}
}
catch (Exception ex)
{
clsVproErrorHandler.HandlerError(ex);
}
}
示例9: CloneCopy
public void CloneCopy ()
{
DataTable table = new DataTable ("pTable");
DataTable table1 = new DataTable ("cTable");
DataSet set = new DataSet ();
set.Tables.Add (table);
set.Tables.Add (table1);
DataColumn col = new DataColumn ();
col.ColumnName = "Id";
col.DataType = Type.GetType ("System.Int32");
table.Columns.Add (col);
UniqueConstraint uc = new UniqueConstraint ("UK1", table.Columns[0] );
table.Constraints.Add (uc);
col = new DataColumn ();
col.ColumnName = "Name";
col.DataType = Type.GetType ("System.String");
table.Columns.Add (col);
col = new DataColumn ();
col.ColumnName = "Id";
col.DataType = Type.GetType ("System.Int32");
table1.Columns.Add (col);
col = new DataColumn ();
col.ColumnName = "Name";
col.DataType = Type.GetType ("System.String");
table1.Columns.Add (col);
ForeignKeyConstraint fc = new ForeignKeyConstraint ("FK1", table.Columns[0], table1.Columns[0] );
table1.Constraints.Add (fc);
DataRow row = table.NewRow ();
row ["Id"] = 147;
row ["name"] = "Row1";
row.RowError = "Error#1";
table.Rows.Add (row);
// Set column to RO as commonly used by auto-increment fields.
// ds.Copy() has to omit the RO check when cloning DataRows
table.Columns["Id"].ReadOnly = true;
row = table1.NewRow ();
row ["Id"] = 147;
row ["Name"] = "Row1";
table1.Rows.Add (row);
//Setting properties of DataSet
set.CaseSensitive = true;
set.DataSetName = "My DataSet";
set.EnforceConstraints = false;
set.Namespace = "Namespace#1";
set.Prefix = "Prefix:1";
DataRelation dr = new DataRelation ("DR", table.Columns [0],table1.Columns [0]);
set.Relations.Add (dr);
set.ExtendedProperties.Add ("TimeStamp", DateTime.Now);
CultureInfo cultureInfo = new CultureInfo( "ar-SA" );
set.Locale = cultureInfo;
//Testing Copy ()
DataSet copySet = set.Copy ();
Assert.AreEqual (set.CaseSensitive, copySet.CaseSensitive, "#A01");
Assert.AreEqual (set.DataSetName, copySet.DataSetName, "#A02");
Assert.AreEqual (set.EnforceConstraints, copySet.EnforceConstraints, "#A03");
Assert.AreEqual (set.HasErrors, copySet.HasErrors, "#A04");
Assert.AreEqual (set.Namespace, copySet.Namespace, "#A05");
Assert.AreEqual (set.Prefix, copySet.Prefix, "#A06");
Assert.AreEqual (set.Relations.Count, copySet.Relations.Count, "#A07");
Assert.AreEqual (set.Tables.Count, copySet.Tables.Count, "#A08");
Assert.AreEqual (set.ExtendedProperties ["TimeStamp"], copySet.ExtendedProperties ["TimeStamp"], "#A09");
for (int i = 0;i < copySet.Tables.Count; i++) {
Assert.AreEqual (set.Tables [i].Rows.Count, copySet.Tables [i].Rows.Count, "#A10");
Assert.AreEqual (set.Tables [i].Columns.Count, copySet.Tables [i].Columns.Count, "#A11");
}
//Testing Clone ()
copySet = set.Clone ();
Assert.AreEqual (set.CaseSensitive, copySet.CaseSensitive, "#A12");
Assert.AreEqual (set.DataSetName, copySet.DataSetName, "#A13");
Assert.AreEqual (set.EnforceConstraints, copySet.EnforceConstraints, "#A14");
Assert.IsFalse (copySet.HasErrors, "#A15");
Assert.AreEqual (set.Namespace, copySet.Namespace, "#A16");
Assert.AreEqual (set.Prefix, copySet.Prefix, "#A17");
Assert.AreEqual (set.Relations.Count, copySet.Relations.Count, "#A18");
Assert.AreEqual (set.Tables.Count, copySet.Tables.Count, "#A19");
Assert.AreEqual (set.ExtendedProperties ["TimeStamp"], copySet.ExtendedProperties ["TimeStamp"], "#A20");
for (int i = 0;i < copySet.Tables.Count; i++) {
Assert.AreEqual (0, copySet.Tables [i].Rows.Count, "#A21");
Assert.AreEqual (set.Tables [i].Columns.Count, copySet.Tables [i].Columns.Count, "#A22");
}
}
示例10: createAudit
private DataSet createAudit(string sortColumn, DataSet dataSet)
{
// Create the query.
var transaction =
from DataRow row in dataSet.Tables["Allocation"].Rows
orderby row[sortColumn] ascending
select row;
DataSet tempDS = dataSet.Clone();
tempDS.ExtendedProperties["user"] = sortColumn;
foreach (var row in transaction)
{
tempDS.Tables["Allocation"].ImportRow(row);
foreach (DataRow sRow in dataSet.Tables["Split"].Rows)
{
//TODO: Does this actually do anything?
if (sRow["ChargeID"] == ((DataRow)row)["ChargeID"])
{
tempDS.Tables["Split"].ImportRow(sRow);
}
}
// try it but it needs to organize splits by company too (no split total)
}
return tempDS;
}
示例11: resolveSplits
private DataSet resolveSplits(DataSet thisDS)
{
DataTable allocation = thisDS.Tables["Allocation"];
DataTable split = thisDS.Tables["Split"];
DataSet newAllocation = thisDS.Clone();
newAllocation.Relations.Clear();
newAllocation.EnforceConstraints = false;
//newAllocation.Tables["Allocation"].PrimaryKey = null;
//newAllocation.Tables["Split"].PrimaryKey = null;
//newAllocation.Tables["Allocation"].Constraints.Clear();
//newAllocation.Tables["Split"].Constraints.Clear();
var query1 = from DataRow o in allocation.Rows
where o["Company"].ToString() != "Split"
select new
{
ChargeID = o["ChargeID"],
Cardholder_Name = o["Cardholder Name"],
Process_Date = o["Process Date"],
Merchant_Name_Location = o["Merchant Name/Location"],
Amount = o["Amount"],
Company = o["Company"],
Account = o["Account"],
Description = o["Description"]
};
//TODO: Clean this up? Use OO?
foreach (var row in query1)
{
DataRow dr = newAllocation.Tables["Allocation"].NewRow();
dr["ChargeID"] = row.ChargeID;
dr["Cardholder Name"] = row.Cardholder_Name;
dr["Process Date"] = row.Process_Date;
dr["Merchant Name/Location"] = row.Merchant_Name_Location;
dr["Amount"] = row.Amount;
dr["Company"] = row.Company;
dr["Account"] = row.Account;
dr["Description"] = row.Description;
newAllocation.Tables["Allocation"].Rows.Add(dr);
}
var query = from DataRow o in allocation.Rows
where o["Company"].ToString() == "Split"
join DataRow ol in split.Rows on o["ChargeID"] equals ol["ChargeID"]
//where ol["Company"].ToString() == company
select new
{
ChargeID = o["ChargeID"],
Cardholder_Name = o["Cardholder Name"],
Process_Date = o["Process Date"],
Merchant_Name_Location = o["Merchant Name/Location"],
Company = ol["Company"],
Account = ol["Account"],
Amount = ol["Amount"],
Description = o["Description"]
};
foreach (var row in query)
{
DataRow dr = newAllocation.Tables["Allocation"].NewRow();
dr["ChargeID"] = row.ChargeID;
dr["Cardholder Name"] = row.Cardholder_Name;
dr["Process Date"] = row.Process_Date;
dr["Merchant Name/Location"] = row.Merchant_Name_Location;
dr["Amount"] = row.Amount;
dr["Company"] = row.Company;
dr["Account"] = row.Account;
dr["Description"] = row.Description;
newAllocation.Tables["Allocation"].Rows.Add(dr);
}
return newAllocation;
}
示例12: Rows_With_Null_Values
public void Rows_With_Null_Values ()
{
DataSet ds = new DataSet ();
DataTable table = ds.Tables.Add ("table1");
table.Columns.Add ("col1", typeof (int));
table.Columns.Add ("col2", typeof (int));
XmlDataDocument doc = new XmlDataDocument (ds);
table.Rows.Add (new object[] {1});
StringWriter sw = new StringWriter ();
doc.Save (sw);
DataSet ds1 = ds.Clone ();
XmlDataDocument doc1 = new XmlDataDocument (ds1);
StringReader sr = new StringReader (sw.ToString());
doc1.Load (sr);
AssertEquals ("#1", 1, ds1.Tables [0].Rows [0][0]);
AssertEquals ("#2", true, ds1.Tables [0].Rows [0].IsNull (1));
}
示例13: categorizeRows
private DataSetCollection categorizeRows(string sortColumn1, string sortColumn2, string sortColumn3, DataSet dataSet)
{
// Create the query.
var transaction =
from DataRow row in dataSet.Tables["Allocation"].Rows
orderby row[sortColumn1] ascending, row[sortColumn2] ascending, row[sortColumn3] ascending
group row by row[sortColumn1] into newGroup
orderby newGroup.Key
select newGroup;
// create a temporary dataset
DataSetCollection dataSetArray = new DataSetCollection();
foreach (var rowGroup in transaction)
{
DataSet tempDS = dataSet.Clone();
tempDS.ExtendedProperties["user"] = rowGroup.Key.ToString();
foreach (var row in rowGroup)
{
tempDS.Tables["Allocation"].ImportRow(row);
foreach(DataRow sRow in dataSet.Tables["Split"].Rows)
{
//TODO: Does this actually do anything?
if(sRow["ChargeID"] == ((DataRow)row)["ChargeID"])
{
tempDS.Tables["Split"].ImportRow(sRow);
}
}
}
dataSetArray.Add(tempDS);
}
return dataSetArray;
}
示例14: LoadCat
private void LoadCat()
{
try
{
var AllList = (from g in DB.ESHOP_CATEGORies
where g.CAT_RANK > 0
select new
{
g.CAT_ID,
g.CAT_PARENT_ID,
g.CAT_RANK,
CAT_NAME = (string.IsNullOrEmpty(g.CAT_CODE) ? g.CAT_NAME : g.CAT_NAME + "(" + g.CAT_CODE + ")")
});
if (AllList.ToList().Count > 0)
{
DataRelation relCat;
Session["CatGroupList"] = DataUtil.LINQToDataTable(AllList);
DataTable tbl = Session["CatGroupList"] as DataTable;
DataSet ds = new DataSet();
ds.Tables.Add(tbl);
tbl.PrimaryKey = new DataColumn[] { tbl.Columns["CAT_ID"] };
relCat = new DataRelation("Category_parent", ds.Tables[0].Columns["CAT_ID"], ds.Tables[0].Columns["CAT_PARENT_ID"], false);
ds.Relations.Add(relCat);
DataSet dsCat = ds.Clone();
DataTable CatTable = ds.Tables[0];
DataUtil.TransformTableWithSpace(ref CatTable, dsCat.Tables[0], relCat, null);
GridItemList.DataSource = CatTable;
GridItemList.DataBind();
}
//var allCat=DB.GetTable<ESHOP_CATEGORy>();
//GridItemList.DataSource = allCat;
//GridItemList.DataBind();
//Session["CatGroupList"] = allCat;
}
catch (Exception ex)
{
clsVproErrorHandler.HandlerError(ex);
}
}
示例15: SearchResult
private void SearchResult()
{
try
{
string keyword = txtKeyword.Value;
var AllList = (from g in DB.ESHOP_PROPERTies
where ("" == keyword || (g.PROP_NAME).Contains(keyword)) && g.PROP_RANK > 0
select new
{
g.PROP_ID,
g.PROP_PARENT_ID,
g.PROP_NAME,
g.PROP_RANK
});
if (AllList.ToList().Count > 0)
{
DataRelation relCat;
Session["PropList"] = DataUtil.LINQToDataTable(AllList);
//DataTable tbl = Session["CatList"] as DataTable;
DataTable tbl = DataUtil.LINQToDataTable(AllList);
DataSet ds = new DataSet();
ds.Tables.Add(tbl);
tbl.PrimaryKey = new DataColumn[] { tbl.Columns["PROP_ID"] };
relCat = new DataRelation("Category_parent", ds.Tables[0].Columns["PROP_ID"], ds.Tables[0].Columns["PROP_PARENT_ID"], false);
ds.Relations.Add(relCat);
DataSet dsCat = ds.Clone();
DataTable CatTable = ds.Tables[0];
CpanelUtils.TransformTableWithSpace(ref CatTable, dsCat.Tables[0], relCat, null);
GridItemList.DataSource = dsCat.Tables[0];
//if (CatTable.Rows.Count > GridItemList.PageSize)
// GridItemList.AllowPaging = true;
//else
// GridItemList.AllowPaging = false;
GridItemList.DataBind();
}
}
catch (Exception ex)
{
clsVproErrorHandler.HandlerError(ex);
}
}