static void Main(string[] args)
{
Console.WriteLine("-----------STARTING APPLICATION-----------");
Console.WriteLine("EXECUTING XML VIEW FILE");
SqlXmlCommand cmd = new SqlXmlCommand("Provider=sqloledb; Data Source=(local);Initial Catalog=TK431Chapter8;UID=sa");
Console.WriteLine("Loading Updategram");
cmd.CommandStream = new FileStream("NewLogRecordUpdategram.xml", FileMode.Open, FileAccess.Read);
cmd.CommandType = SqlXmlCommandType.DiffGram;
Console.WriteLine("Creating parameters");
SqlXmlParameter ID = cmd.CreateParameter();
ID.Name = "@ID";
ID.Value = "6";
SqlXmlParameter appName = cmd.CreateParameter();
appName.Name = "@AppName";
appName.Value = "CustomerAssistance";
SqlXmlParameter message = cmd.CreateParameter();
message.Name = "@Message";
message.Value = @"<logRecord machine='WebHostingServer' timestamp='2000-01-01T06:00:00Z'>
<post eventType='appStart'>
<moreInformation>The web server is under attack</moreInformation>
</post>
</logRecord>";
Console.WriteLine("Executing!");
cmd.ExecuteNonQuery();
Console.WriteLine("-----------APPLICATION FINISHED-----------");
Console.ReadLine();
}
static void Main(string[] args)
{
FileStream xmlQuery = new FileStream("updategram.xml", FileMode.Open);
SqlXmlCommand cmd = new SqlXmlCommand(connectionString);
cmd.CommandStream = xmlQuery;
cmd.CommandType = SqlXmlCommandType.UpdateGram;
cmd.ExecuteNonQuery();
xmlQuery.Close();
}
public void CleanDatabase()
{
SqlXmlCommand command = new SqlXmlCommand(_SqlXmlconnectionString);
command.CommandType = SqlXmlCommandType.Sql;
command.CommandText = "delete address;delete Employee";
SqlXmlParameter param = command.CreateParameter();
command.ExecuteNonQuery();
}
private void button1_Click(object sender, EventArgs e)
{
StreamReader reader = File.OpenText(Application.StartupPath + @"\employees.xml");
SqlXmlCommand cmd = new SqlXmlCommand(strConn);
cmd.CommandType = SqlXmlCommandType.DiffGram;
cmd.CommandText = reader.ReadToEnd();
cmd.SchemaPath = Application.StartupPath + @"\employees.xsd";
cmd.ExecuteNonQuery();
MessageBox.Show("DiffGram updated to database successfully!");
}
private void PersistChanges(string serializedEmployees, bool delete)
{
SqlXmlCommand command = new SqlXmlCommand(_SqlXmlconnectionString);
command.CommandType = SqlXmlCommandType.Sql;
command.CommandText = "exec PersistEmployees ?, ?";
SqlXmlParameter param = command.CreateParameter();
param.Value = serializedEmployees;
SqlXmlParameter param2 = command.CreateParameter();
param2.Value = delete ? 1 : 0;
command.ExecuteNonQuery();
}
