如何将查询出的结果生成一个XML文件
1个回答
推荐于2016-06-22
展开全部
比如说我有一个存储过程
create proc [dbo].[iSno_Select]
@sno nchar(7)
as
select sname,ssex,sage,sdept
from student
where sno=@sno
出一个查询结果,我在.Net里调用这个存储结果
string sno = TextBox1.Text.Trim();
string conStr = "Data Source=PC-20110624IRHP\\SQLEXPRESS;Initial Catalog=";
conStr = conStr + "students2;Integrated Security=sspi";
SqlConnection Con = new SqlConnection(conStr);
Con.Open();
string s = "iSno_Select '" + sno + "'";
SqlCommand cmd = new SqlCommand(s, Con);
SqlDataReader dr = cmd.ExecuteReader();
XmlDocument objDom=new XmlDocument();
create proc [dbo].[iSno_Select]
@sno nchar(7)
as
select sname,ssex,sage,sdept
from student
where sno=@sno
出一个查询结果,我在.Net里调用这个存储结果
string sno = TextBox1.Text.Trim();
string conStr = "Data Source=PC-20110624IRHP\\SQLEXPRESS;Initial Catalog=";
conStr = conStr + "students2;Integrated Security=sspi";
SqlConnection Con = new SqlConnection(conStr);
Con.Open();
string s = "iSno_Select '" + sno + "'";
SqlCommand cmd = new SqlCommand(s, Con);
SqlDataReader dr = cmd.ExecuteReader();
XmlDocument objDom=new XmlDocument();
推荐律师服务:
若未解决您的问题,请您详细描述您的问题,通过百度律临进行免费专业咨询