110,536
社区成员
发帖
与我相关
我的任务
分享
string connStr = "server=192.168.1.5;database=数据库;uid=sa;pwd=sa";
SqlConnection myConn = new SqlConnection(connStr);
string selStr = "select sTime as 时间,data as 数据值 from 表 by sTime desc";
SqlCommand myCmd = myConn.CreateCommand();
myCmd.CommandText = selStr;
myConn.Open();
SqlDataAdapter sd = new SqlDataAdapter(selStr,myConn);
DataSet ds = new DataSet();
sd.Fill(ds);
ds.WriteXmlSchema("test.xml");
myConn.Close();
myCmd.Dispose();