8/8/05

C# lectura access y escritura xml


OleDbConnection con = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=o:\\datos\\datos.mdb;Jet OLEDB:Database Password =****");
OleDbCommand cmd = new OleDbCommand("select * from departamento",con);
XmlTextWriter xmlwriter = new XmlTextWriter(@"d:\pub\web\datos.xml",null);
xmlwriter.Formatting = Formatting.Indented;
xmlwriter.IndentChar = '\t';
xmlwriter.Indentation = 1;
xmlwriter.WriteStartElement("Datos");
xmlwriter.WriteStartElement("Departamentos");
con.Open();
try
{
dr = cmd.ExecuteReader();
while (dr.Read())
{
xmlwriter.WriteStartElement("Departamento");
xmlwriter.WriteString(dr["Nomb"].ToString());
xmlwriter.WriteEndElement();
}
}
finally
{
xmlwriter.WriteEndElement();
xmlwriter.WriteEndElement();
con.Close();
xmlwriter.Close();
}