1. dataset转换成xml格式的string型
Dataset dt=new DataSet();
SqlConnection myconn ;
myconn = new SqlConnection(myconS); //ps:myconS指的是连接数据库的语句
myconn.Open();
SqlCommand cmd = new SqlCommand("select * from CargoJob where JobId='00000000'", myconn);
SqlDataAdapter sda = new SqlDataAdapter(cmd);
sda.Fill(ds);
ds.GetXml().ToString();//将DataSet转换成XML格式的string型
2.XML格式的string型转换成DataSet
命名空间为using System.IO;
private DataTable StrToData(string str)
{
DataSet xmlds = new DataSet();
if (str != "<NewDataSet />")
{
StringReader stream = null;
XmlTextReader reader = null;
try
{
stream = new StringReader(str);
reader = new XmlTextReader(stream);
xmlds.ReadXml(reader);
}
catch (System.Exception e)
{
}
finally
{
if (reader != null)
{
reader.Close();
}
}
DataTable dt = xmlds.Tables[0];
return dt;
}
else
{
DataTable dt = new DataTable();
return dt;
}
}