从数据库中调用表格数据。显示在xmlstring strcnn="data source=.\\SQLEXPRESS;Integrated Security=SSPI;database=student";
using(SqlConnection sqlcnn=new SqlConnection (strcnn))
{
using (SqlCommand sqlcmm=sqlcnn.CreateCommand())
{
using (XmlWriter writer=XmlWriter.Create(Response.Output,new XmlWriterSettings()))
{
writer.WriteStartElement("students");
sqlcmm.CommandText="SELECT * FROM student FOR XML AUTO,ELEMENTS";
sqlcnn.Open();
XmlReader reader=sqlcmm.ExecuteXmlReader();
writer.WriteNode(reader, true);
writer.WriteEndElement();
}
}
}
与此进行增删改查等。。。