public partial class Form1 : Form
{
DataSet ds = new DataSet();
public Form1()
{
InitializeComponent();
}
private void button1_Click(object sender, EventArgs e)
{
string str = ds.GetXml();
SaveToXml(str);
}
/// <summary>
/// 输出指定文件到指定文件
/// </summary>
/// <param name="str"></param>
private void SaveToXml(string str)
{
string path = "d://Customers.xml";
FileInfo fi = new FileInfo(path);
if (!fi.Exists)
{
using (StreamWriter sw = fi.CreateText())
{
sw.WriteLine(@"<?xml version='1.0' encoding='UTF-8'?>");
sw.WriteLine("" + str.Trim() + "");
sw.Close();
}
}
else
{
StreamWriter fw = new StreamWriter(path);
fw.WriteLine(@"<?xml version='1.0' encoding='UTF-8'?>");
fw.WriteLine("" + str.Trim() + "");
fw.Close();
}
}
private void Form1_Load(object sender, EventArgs e)
{
string MyConnectionString = "Server=127.0.0.1;Database=testdb;User ID=sa;Password=newman2007;Connect Timeout=20;Pooling=True;Min Pool Size=1;Max Pool Size=100;Persist Security Info=False;Asynchronous Processing=true;Integrated Security=false;";
SqlDataAdapter da = new SqlDataAdapter("SELECT * FROM CashBillInfo", MyConnectionString);
try
{
ds.DataSetName = "SCSAT-E1";
da.Fill(ds, "record");
}
catch (Exception ex)
{
MessageBox.Show("Operation failed: " + ex.ToString(), Application.ProductName + " - Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
dataGridView1.DataSource = ds;
dataGridView1.DataMember = "record";
}
}
输出效果:
<?xml version='1.0' encoding='UTF-8'?>
<SCSAT-E1>
<record>
<xh>1</xh>
<nsrsbh>12344777</nsrsbh>
<skjbh>00001</skjbh>
<sklsh>201092222</sklsh>
<sksj>2233333</sksj>
<hjje>23.00</hjje>
</record>
<record>
<xh>2</xh>
<nsrsbh>33334</nsrsbh>
<skjbh>5555</skjbh>
<sklsh>66666</sklsh>
<sksj>6666</sksj>
<hjje>33.00</hjje>
</record>
<record>
<xh>3</xh>
<nsrsbh>5555</nsrsbh>
<skjbh>6677</skjbh>
<sklsh>7788</sklsh>
<sksj>555</sksj>
<hjje>66.00</hjje>
</record>
</SCSAT-E1>