110,534
社区成员
发帖
与我相关
我的任务
分享
DataSet aa = new DataSet();
//填充dataset代码
//...
//最后
aa.WriteXml("bb.xml");
DataSet dsdata=new DataSet();
private void button3_Click(object sender, EventArgs e)
{
string con = "server=localhost;Integrated Security=SSPI;database=Common";
string sqlstr = "select id,name from table ";
SqlConnection connect = new SqlConnection(con);
SqlCommand cmd = new SqlCommand();
cmd.CommandText = sqlstr;
cmd.Connection = connect;
SqlDataAdapter dap = new SqlDataAdapter();
dap.SelectCommand = cmd;
dap.Fill(dsdata);
dsdata.WriteXml("temp.xml");
}