using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Xml;
using System.Data.SqlClient;
using System.IO;
namespace xml_ADO.net
{
public partial class Form1 : Form
{
private XmlDocument doc = new XmlDocument();
public Form1()
{
InitializeComponent();
}
private void button1_Click(object sender, EventArgs e)
{
listView1.SelectedIndexChanged += new EventHandler(Example_SelectedindexChanged );
DataSet ds = new DataSet("XMLAuthors");
SqlConnection conn = new SqlConnection("server=(local); integrated security=SSPI;database=Northwind");
SqlDataAdapter da = new SqlDataAdapter("select * from categories ",conn );
MemoryStream memstrm = new MemoryStream();
StreamReader strmRead = new StreamReader(memstrm );
StreamWriter strmWrite = new StreamWriter(memstrm );
da.Fill(ds,"Authors");
dataGridView1.DataSource = ds.Tables[0];
ds.WriteXml(strmWrite ,XmlWriteMode.IgnoreSchema );
memstrm.Seek(0, SeekOrigin.Begin);
doc.Load(strmRead);
doc.Save("mm.xml");
XmlNodeList nodelst = doc.SelectNodes("//CategoryName");
foreach (XmlNode nd in nodelst)
listView1.Items.Add(nd.InnerText );
}
private void Example_SelectedindexChanged(object sender, EventArgs e)
{
if (listView1.SelectedItems.Count == 0)
{
string srch = "XMLAuthors/Authors[CategoryName= '" + listView1.SelectedItems[0].ToString() + "'" + "]";
XmlNode foundNode = doc.SelectSingleNode(srch);
if (foundNode != null)
MessageBox.Show(foundNode.OuterXml);
else
MessageBox.Show("Not found");