private void button1_Click(object sender, EventArgs e) { if (textBox1.Text == "") { MessageBox.Show("Please enter SELECT query"); return; } try { string strConn = @"Provider=SQLOLEDB;server=.;database=northwind;integrated security=SSPI"; SqlXmlCommand cmd = new SqlXmlCommand(strConn); cmd.CommandText = textBox1.Text; Stream stream = cmd.ExecuteStream(); StreamReader reader = new StreamReader(stream); StreamWriter writer = File.CreateText($"{Application.StartupPath}\\sqlxmlresults.xml"); writer.Write(reader.ReadToEnd()); writer.Close(); webBrowser1.Navigate($"{Application.StartupPath}\\sqlxmlresults.xml"); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
static void Main(string[] args) { SqlXmlCommand cmd = new SqlXmlCommand(connectionString); SqlXmlParameter parm; cmd.CommandText = "SELECT FirstName, LastName FROM Person.Contact WHERE LastName=? For XML Auto"; parm = cmd.CreateParameter(); parm.Value = "Achong"; string strResult; try { Stream strm = cmd.ExecuteStream(); strm.Position = 0; using (StreamReader sr = new StreamReader(strm)) { Console.WriteLine(sr.ReadToEnd()); } } catch (SqlXmlException e) { //in case of an error, this prints error returned. e.ErrorStream.Position = 0; strResult = new StreamReader(e.ErrorStream).ReadToEnd(); System.Console.WriteLine(strResult); } }
static void ReadFromXMLView() { SqlXmlCommand cmd = new SqlXmlCommand("Provider=sqloledb;Data Source=DEMOS;Initial Catalog=TK431Chapter8;User Id=sa;"); cmd.CommandText = "UniversalLogView.xml"; cmd.CommandType = SqlXmlCommandType.TemplateFile; PrintXML(cmd.ExecuteStream(), true, "ReadFromXMLView.xml"); }
static void ReadFromAnnotatedSchema() { string XPATH = "UniversalLog/Log[@ID='3']"; SqlXmlCommand cmd = new SqlXmlCommand("Provider=sqloledb;Data Source=DEMOS;Initial Catalog=TK431Chapter8;User Id=sa;"); cmd.CommandText = XPATH; cmd.CommandType = SqlXmlCommandType.XPath; cmd.SchemaPath = "UniversalLogSchema.xsd"; PrintXML(cmd.ExecuteStream(), true, "ReadFromAnnotatedSchema.xml"); }
private void button1_Click(object sender, EventArgs e) { string strConn = @"Provider=SQLOLEDB;server=.\sqlexpress;database=northwind;integrated security=SSPI"; SqlXmlCommand cmd = new SqlXmlCommand(strConn); cmd.CommandText = textBox1.Text; Stream stream = cmd.ExecuteStream(); StreamReader reader = new StreamReader(stream); StreamWriter writer = File.CreateText(Application.StartupPath + @"\sqlxmlresults.xml"); writer.Write(reader.ReadToEnd()); writer.Close(); webBrowser1.Navigate(Application.StartupPath + @"\sqlxmlresults.xml"); }
private Stream GetXml(string filterTemplate) { SqlXmlCommand catalogCommand = new SqlXmlCommand(connString); catalogCommand.CommandType = SqlXmlCommandType.XPath; catalogCommand.CommandText = filterTemplate; catalogCommand.RootTag = dataRootTag; catalogCommand.Namespaces = dataNamespaces; catalogCommand.SchemaPath = catalogSchemaFile; return(catalogCommand.ExecuteStream()); /* For the time being * Stream xmlStream = File.OpenRead(@"D:\Reusable Components\DataAccessLogic\ProofOfConcept\ProofOfConcept\TestPUNCatalog.xml"); * return xmlStream; */ }
static void Main(string[] args) { FileStream xmlQuery = new FileStream("command.xml", FileMode.Open); SqlXmlCommand cmd = new SqlXmlCommand(connectionString); cmd.CommandStream = xmlQuery; cmd.CommandType = SqlXmlCommandType.Template; SqlXmlParameter parm; parm = cmd.CreateParameter(); parm.Name = "@LastName"; parm.Value = "Achong"; cmd.ClientSideXml = true; cmd.RootTag = "Person"; string strResult; try { Stream strm = cmd.ExecuteStream(); strm.Position = 0; using (StreamReader sr = new StreamReader(strm)) { Console.WriteLine(sr.ReadToEnd()); } } catch (SqlXmlException e) { //in case of an error, this prints error returned. e.ErrorStream.Position = 0; strResult = new StreamReader(e.ErrorStream).ReadToEnd(); System.Console.WriteLine(strResult); } }