本文整理汇总了C#中System.Data.DataSet.Merge方法的典型用法代码示例。如果您正苦于以下问题:C# DataSet.Merge方法的具体用法?C# DataSet.Merge怎么用?C# DataSet.Merge使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类System.Data.DataSet
的用法示例。
在下文中一共展示了DataSet.Merge方法的15个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: Fill
public override int Fill(DataSet dataSet)
{
int filled = 0;
foreach (DataTable table in dataSet.Tables)
{
DateTime lastModified;
if (lastModifiedDict.ContainsKey(table.TableName))
{
lastModified = lastModifiedDict[table.TableName];
}
else
{
lastModified = DateTime.Now - TimeSpan.FromDays(90); // TODO: 90 days is arbitrary
}
int modifiedTime = dateTimeConverter.ToUnixTime(lastModified);
JToken token = webServiceClient.DoSync(modifiedTime.ToString(), table.TableName);
if (token != null)
{
DataTable dataTable = ToDataTable(token["updated"]);
DataTable mergeTable = dataSet.Tables[table.TableName].Clone();
foreach (DataRow row in dataTable.Rows)
{
if (null != BeforeImport)
{
BeforeImport(mergeTable, row);
}
mergeTable.ImportRow(row);
}
dataSet.Merge(mergeTable);
}
}
return filled;
}
示例2: button1_Click
private void button1_Click(object sender, EventArgs e)
{
string s = Application.StartupPath;
try
{
XmlTextReader xmlreader1 = new XmlTextReader("D:\\Dropboxdata\\Rms\\RMS\\RMS\\bin\\Debug\\MyXmlFile.xml");
XmlTextReader xmlreader2 = new XmlTextReader("D:\\Dropboxdata\\Rms\\RMS\\RMS\\bin\\Debug\\XML2.xml");
DataSet ds = new DataSet();
ds.ReadXml(xmlreader1);
DataSet ds2 = new DataSet();
ds2.ReadXml(xmlreader2);
ds.Merge(ds2);
// ds2.Merge(ds);
ds.WriteXml("D:\\Dropboxdata\\Rms\\RMS\\RMS\\bin\\Debug\\Books.xml");
MessageBox.Show("Completed merging XML documents");
}
catch (System.Exception ex)
{
MessageBox.Show(ex.Message);
}
}
示例3: ThreadProc
public void ThreadProc() {
//The thread procedure performs the data access, and then invokes the callback
//delegate with the filled dataset
Debug.Write("ThreadWithState::ThreadProc()\n");
Debug.Write("Thread= " + Thread.CurrentThread.Name + "\n");
DataSet ds = new DataSet();
ds.Merge(this.m_oViewer.GetReportData(this.m_oDataMgr));
if(this.m_oCallBack != null)
this.m_oCallBack(ds);
}
示例4: LookupCityState
public DataSet LookupCityState(string zip5) {
//
DataSet response = new DataSet();
try {
DataSet ds = new USPSGateway().LookupCityState(zip5);
if (ds != null) response.Merge(ds);
}
catch(Exception ex) { throw new FaultException<USPSFault>(new USPSFault(ex.Message), "Service Error"); }
return response;
}
示例5: LookupZipCode
public DataSet LookupZipCode(string firmName,string address1,string address2,string city,string state) {
//
DataSet response = new DataSet();
try {
DataSet ds = new USPSGateway().LookupZipCode(firmName,address1,address2,city,state);
if (ds != null) response.Merge(ds);
}
catch (Exception ex) { throw new FaultException<USPSFault>(new USPSFault(ex.Message),"Service Error"); }
return response;
}
示例6: Fill
public override int Fill(DataSet dataSet)
{
if (Configuration.ConfigurationHelper.Instance.TestMode)
{
dataSet.Merge(((MockDriver)Conf.Driver).ds);
return 1;
}
return base.Fill(dataSet);
}
示例7: button1_Click
private void button1_Click(object sender, EventArgs e)
{
robj = RemoteInterface.RemoteBuilder.GetRemoteObj(typeof(RemoteInterface.I_ProcessManager),
RemoteInterface.RemoteBuilder.getRemoteUri(txtIp.Text, (int)RemoteInterface.RemotingPortEnum.ProcessManager, RemoteInterface.RemotingPortEnum.ProcessManager.ToString())) as RemoteInterface.I_ProcessManager;
System.Data.DataSet ds=new DataSet();
ds.Merge(robj.getProcessStatus());
this.dataGridView1.SuspendLayout();
this.dataGridView1.DataSource = ds;
this.dataGridView1.DataMember = "tblProcessInfo";
this.dataGridView1.ResumeLayout();
}
示例8: GetDBSchemas
public DataSet GetDBSchemas()
{
DataSet set = new DataSet();
object[] restrictions = new object[4];
restrictions[3] = "TABLE";
DataTable oleDbSchemaTable = this._connection.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, restrictions);
set.Merge(oleDbSchemaTable);
restrictions = new object[4];
restrictions[3] = "VIEW";
DataTable table = this._connection.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, restrictions);
set.Merge(table);
foreach (DataRow row in set.Tables[0].Rows)
{
restrictions = new object[3];
restrictions[2] = row["TABLE_NAME"];
DataTable table3 = this._connection.GetOleDbSchemaTable(OleDbSchemaGuid.Columns, restrictions);
set.Merge(table3, true, MissingSchemaAction.Add);
}
set.Relations.Add(this._rel, set.Tables["Tables"].Columns["TABLE_NAME"], set.Tables["Columns"].Columns["TABLE_NAME"]);
return set;
}
示例9: GetDBAccess
/// <summary>
/// 查询所有数据
/// </summary>
/// <param name="shopID"></param>
/// <param name="year"></param>
/// <param name="statTypeID"></param>
/// <returns></returns>
public static DataSet GetDBAccess(int shopID, int year)
{
List<int> statTypeList = GetAllStatType(shopID);
DataSet ds = new DataSet();
foreach (int item in statTypeList)
{
ds.Merge(GetSpecialData(shopID, year, item, 1), true, MissingSchemaAction.Add);
}
return ds;
}
示例10: GetListDataSet
public DataSet GetListDataSet(string listName)
{
try
{
DataSet dataSet = new DataSet();
SPList list = GetListItems(listName);
SPView view = list.Views["All Items"];
if (view != null && view.ViewFields.ToStringCollection().Contains("Title"))
{
dataSet.Merge(list.GetItems(view).GetDataTable());
}
else
{
dataSet.Merge(list.Items.GetDataTable());
}
return dataSet;
}
catch (Exception ex)
{
throw ex;
}
}
示例11: Page_Load
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
DataSet dep = new DataSet();
dep = pxy.GetDepartments();
DataSet dep2 = new DataSet();
dep2 = EGpxy.GetDepartments();
dep.Merge(dep2);
ddlDepartments.DataSource = dep;
ddlDepartments.DataTextField = "departmentName";
ddlDepartments.DataValueField = "departmentNumber";
ddlDepartments.DataBind();
ddlDepartments.Items.Insert(0, "-------Choose-------");
}
}
示例12: ConvertDatatableToJson
/*
How to Use:
dtJ = new ConvertDatatableToJson();
JsonString = dtJ.DataTableToJson((DataTable)ViewState["dt"]);
*/
/// <summary>
/// </summary>
/// <param name="dt"></param>
/// <returns></returns>
public static string DataTableToJson(DataTable dt)
{
var ds = new DataSet();
ds.Merge(dt);
var jsonStr = new StringBuilder();
if (ds.Tables[0].Rows.Count > 0)
{
jsonStr.Append("[");
for (int i = 0;
i < ds.Tables[0].Rows.Count;
i++)
{
jsonStr.Append("{");
for (int j = 0;
j < ds.Tables[0].Columns.Count;
j++)
{
if (j < ds.Tables[0].Columns.Count - 1)
{
jsonStr.Append
(
"\"" + ds.Tables[0].Columns[j].ColumnName + "\":" + "\"" + ds.Tables[0].Rows[i][j]
+ "\",");
}
else if (j == ds.Tables[0].Columns.Count - 1)
{
jsonStr.Append
(
"\"" + ds.Tables[0].Columns[j].ColumnName + "\":" + "\"" + ds.Tables[0].Rows[i][j]
+ "\"");
}
}
if (i == ds.Tables[0].Rows.Count - 1)
{
jsonStr.Append("}");
}
else
{
jsonStr.Append("},");
}
}
jsonStr.Append("]");
return jsonStr.ToString();
}
return null;
}
示例13: btnMerge_Click
private void btnMerge_Click(object sender, EventArgs e)
{
Con = new SqlConnection();
Con.ConnectionString = "Server=(local);database=ADOTest;" +
"Integrated Security=true";
Adpt = new SqlDataAdapter("SELECT * FROM tblPeople", Con);
DbADOTest = new DataSet("ADOTest");
Adpt.Fill(DbADOTest, "tblPeople");
tblPeople2 = MakePeopleTable();
//DbADOTest.Merge(tblPeople2);
//DbADOTest.Merge(tblPeople2, true, MissingSchemaAction.Add);
//DbADOTest.Merge(tblPeople2, false, MissingSchemaAction.Add);
DbADOTest.Merge(tblPeople2, false, MissingSchemaAction.Ignore);
dataGridView1.DataSource = DbADOTest.Tables["tblPeople"];
}
示例14: ButtonProcessDocument_Click
private void ButtonProcessDocument_Click(object sender, RoutedEventArgs e)
{
if (FileNameTextBox.Text == "")
{
return;
}
var path = Path.GetDirectoryName(FileNameTextBox.Text);
var fileName = Path.GetFileNameWithoutExtension(FileNameTextBox.Text);
var newFileName = string.Format("{0}\\{1}_cleaned.xlsx", path, fileName);
var dataSet = new DataSet("ExcelData");
using (var spreadsheetDocument = SpreadsheetDocument.Open(FileNameTextBox.Text, false))
{
var workbookPart = spreadsheetDocument.WorkbookPart;
var allSheets = workbookPart.Workbook.Descendants<Sheet>();
foreach (var sheet in allSheets)
{
var worksheetPart = Processor.GetWorksheetFromSheetName(workbookPart, sheet.Name);
using (var reader = OpenXmlReader.Create(worksheetPart))
{
var processor = ProcessorFactory.GetProcessor(sheet.Name, fileName);
if (processor == null)
{
continue;
}
var excelData = processor.GetDataSetFromExcelTab(reader, workbookPart);
if (excelData != null)
{
dataSet.Merge(excelData, false);
}
}
}
}
if (dataSet.Tables.Count != 0)
{
Processor.CreateExcelDocument(dataSet, newFileName);
}
}
示例15: btnExcel_Click
protected void btnExcel_Click(object sender, EventArgs e)
{
BindGridView(GridView1);
if (GridView1.Rows.Count > 0)
{
// string reportName = DbHelper.GetInstance().GetWorkflow_ReportMainEntityByReportID(DNTRequest.GetQueryString("ReportID")).ReportName;
// string fileName = reportName + "_ToExcel.xls";
string fileName = "Report_ToExcel.xls";
DataSet ds = new DataSet();
ds.Merge((DataTable)(ViewState["dtValue"]));
DataTable dtColumn = GetColoumns(ds.Tables[0]);
CreateExcel(dtColumn, ds, "1", fileName, "True");
}
System.Web.UI.ScriptManager.RegisterStartupScript(btnExcel, this.GetType(), "ButtonHideScript", strButtonHideScript, false);
}