//---------------------------------------------------------------------
void OtherSnips1()
{
//---------------------------------------------
System.Data.SqlClient.SqlDataAdapter SqlDataAdapter1 = new System.Data.SqlClient.SqlDataAdapter();
System.Data.DataSet Dataset1 = new System.Data.DataSet();
Dataset1.Tables.Add(new System.Data.DataTable("Table1"));
//<Snippet26>
try
{
SqlDataAdapter1.Update(Dataset1.Tables["Table1"]);
}
catch (Exception e)
{
// Error during Update, add code to locate error, reconcile
// and try to update again.
}
//</Snippet26>
//---------------------------------------------
NorthwindDataSet northwindDataSet = new NorthwindDataSet();
//<Snippet12>
string xmlData = northwindDataSet.GetXml();
//</Snippet12>
//<Snippet13>
string filePath = "ENTER A VALID FILEPATH";
northwindDataSet.WriteXml(filePath);
//</Snippet13>
//---------------------------------------------
//<Snippet15>
NorthwindDataSetTableAdapters.RegionTableAdapter regionTableAdapter =
new NorthwindDataSetTableAdapters.RegionTableAdapter();
regionTableAdapter.Insert(5, "NorthWestern");
//</Snippet15>
//---------------------------------------------
//<Snippet16>
System.Data.SqlClient.SqlConnection sqlConnection1 =
new System.Data.SqlClient.SqlConnection("YOUR CONNECTION STRING");
System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = "INSERT Region (RegionID, RegionDescription) VALUES (5, 'NorthWestern')";
cmd.Connection = sqlConnection1;
sqlConnection1.Open();
cmd.ExecuteNonQuery();
sqlConnection1.Close();
//</Snippet16>
}
