Tuesday, August 18, 2009

merging two datasets in csharp

SqlConnection mySqlConnection =new SqlConnection("server=(local)\\SQLEXPRESS;database=MyDatabase;Integrated Security=SSPI;");

SqlCommand mySqlCommand = mySqlConnection.CreateCommand();

mySqlCommand.CommandText =
"SELECT ID, FirstName, LastName, Address " +
"FROM Customers " +
"WHERE ID IN ('001', '002', '003')";
SqlDataAdapter mySqlDataAdapter = new SqlDataAdapter();
mySqlDataAdapter.SelectCommand = mySqlCommand;
DataSet myDataSet = new DataSet();
mySqlConnection.Open();
mySqlDataAdapter.Fill(myDataSet, "Customers");

mySqlCommand.CommandText =
"SELECT ID, FirstName, LastName, Address " +
"FROM Customers " +
"WHERE CustomerID IN ('008', '009')";
DataSet myDataSet2 = new DataSet();
mySqlDataAdapter.Fill(myDataSet2, "Customers2");

mySqlCommand.CommandText =
"SELECT TOP 5 ProductID, ProductName, UnitPrice " +
"FROM Products " +
"ORDER BY ProductID";
DataSet myDataSet3 = new DataSet();
mySqlDataAdapter.Fill(myDataSet3, "Products");

mySqlConnection.Close();

myDataSet.Merge(myDataSet2);

myDataSet.Merge(myDataSet3, true, MissingSchemaAction.Add);

foreach (DataTable myDataTable in myDataSet.Tables) {
Console.WriteLine("\nReading from the " + myDataTable + "DataTable");
foreach (DataRow myDataRow in myDataTable.Rows) {
foreach (DataColumn myDataColumn in myDataTable.Columns) {
Console.WriteLine(myDataColumn + "= " + myDataRow[myDataColumn]);
}
}
}
}

No comments:

Post a Comment