110,535
社区成员
发帖
与我相关
我的任务
分享
public static XmlDocument ExecuteDataSet(string connectionString, string spName)
{
if (string.IsNullOrEmpty(connectionString))
throw new ArgumentNullException("connectionString");
if (string.IsNullOrEmpty(spName))
throw new ArgumentNullException("spName");
XmlDocument doc = new XmlDocument();
using (SqlConnection connection = new SqlConnection(connectionString))
{
connection.Open();
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = spName;
cmd.Connection = connection;
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
ds.DataSetName = "Result";
ds.Tables[0].TableName = "CompanyList";
string xml = ds.GetXml();
doc.LoadXml(xml);
connection.Close();
}
return doc;
}
public static XmlDocument ExecuteXmlReader(string connectionString, string spName)
{
if (string.IsNullOrEmpty(connectionString))
throw new ArgumentNullException("connectionString");
if (string.IsNullOrEmpty(spName))
throw new ArgumentNullException("spName");
XmlDocument doc = new XmlDocument();
using (SqlConnection connection = new SqlConnection(connectionString))
{
connection.Open();
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = spName;
cmd.Connection = connection;
doc.Load(cmd.ExecuteXmlReader());
connection.Close();
}
return doc;
}
ALTER PROCEDURE [DC].[P_Int_Pub_Company_List]
AS
BEGIN
select snCompID as CompID,vcCompany as Company from Pub_Company order by snOrder asc
END
ALTER PROCEDURE [DC].[P_Int_Pub_Company_List_XML]
AS
BEGIN
select snCompID as CompID,vcCompany as Company from Pub_Company as CompanyList order by snOrder asc FOR XML AUTO,root('Result'),elements
END