Writing to a Database

private void PlaceOrder(XmlReader order) {

// Load XML into a document

XmlDocument xmlOrder = new XmlDocument();

xmlOrder.Load(order);

// Create a Command to insert the order

SQLConnection sqlConn = new SQLConnection(ConnStr);

sqlConn.Open();

SQLCommand sqlCommand = new SQLCommand(

"Insert into Orders(OrderInfo)Values(@xmlInfo)", sqlConn);

// Add a parameter for the order

sqlCommand.Parameters.Add(

new SQLParameter("@XmlInfo", typeof(String), 1024));

sqlCommand.Parameters["@xmlInfo"].Value = xmlOrder.OuterXml;

// Execute the Command

sqlCommand.Execute();

sqlConn.Close();

}