有xml内容如下:
<?xml version="1.0" encoding="utf-8"?>
<Report>
<DataSets>
<DataSet Name="DataSet0">
<Query>
<CommandType>StoredProcedure</CommandType>
<CommandText>fxf_GetResource</CommandText>
<QueryParameters>
<QueryParameter Name="@p_ResourceID">
<Value>=Parameters!p_ResourceID.Value</Value>
</QueryParameter>
<QueryParameter Name="@p_LCID">
<Value>=Parameters!p_LCID.Value</Value>
</QueryParameter>
</QueryParameters>
</Query>
</DataSet>
<DataSet Name="DataSet1">
<Query>
<CommandType>StoredProcedure</CommandType>
<CommandText>[fxf_GetStaffInfo]</CommandText>
<QueryParameters>
<QueryParameter Name="@IsPersonal_p">
<Value>=Parameters!IsPersonal_p.Value</Value>
</QueryParameter>
<QueryParameter Name="@UserID_p">
<Value>=Parameters!UserID_p.Value</Value>
</QueryParameter>
</QueryParameters>
</Query>
</DataSet>
</DataSets>
</Report>
怎么放进如下格式的DataTable??
myData = new DataTable();
myData.Columns.Add(new DataColumn("DataSetName", System.Type.GetType("System.String")));
myData.Columns.Add(new DataColumn("CommandType", System.Type.GetType("System.String")));
myData.Columns.Add(new DataColumn("CommandText", System.Type.GetType("System.String")));
myData.Columns.Add(new DataColumn("QueryParameterName", System.Type.GetType("System.String")));最后DataTable结果为
DataSet0 StoredProcedure fxf_GetResource @p_ResourceID @p_LCID
DataSet1 StoredProcedure [fxf_GetStaffInfo] @IsPersonal_p @UserID_p
<?xml version="1.0" encoding="utf-8"?>
<Report>
<DataSets>
<DataSet Name="DataSet0">
<Query>
<CommandType>StoredProcedure</CommandType>
<CommandText>fxf_GetResource</CommandText>
<QueryParameters>
<QueryParameter Name="@p_ResourceID">
<Value>=Parameters!p_ResourceID.Value</Value>
</QueryParameter>
<QueryParameter Name="@p_LCID">
<Value>=Parameters!p_LCID.Value</Value>
</QueryParameter>
</QueryParameters>
</Query>
</DataSet>
<DataSet Name="DataSet1">
<Query>
<CommandType>StoredProcedure</CommandType>
<CommandText>[fxf_GetStaffInfo]</CommandText>
<QueryParameters>
<QueryParameter Name="@IsPersonal_p">
<Value>=Parameters!IsPersonal_p.Value</Value>
</QueryParameter>
<QueryParameter Name="@UserID_p">
<Value>=Parameters!UserID_p.Value</Value>
</QueryParameter>
</QueryParameters>
</Query>
</DataSet>
</DataSets>
</Report>
怎么放进如下格式的DataTable??
myData = new DataTable();
myData.Columns.Add(new DataColumn("DataSetName", System.Type.GetType("System.String")));
myData.Columns.Add(new DataColumn("CommandType", System.Type.GetType("System.String")));
myData.Columns.Add(new DataColumn("CommandText", System.Type.GetType("System.String")));
myData.Columns.Add(new DataColumn("QueryParameterName", System.Type.GetType("System.String")));最后DataTable结果为
DataSet0 StoredProcedure fxf_GetResource @p_ResourceID @p_LCID
DataSet1 StoredProcedure [fxf_GetStaffInfo] @IsPersonal_p @UserID_p
解决方案 »
- AutoToolboxPopulate=false无效,VS2010的BUG?
- 关于lucene.net里面的 Indexmodifier的效率问题,请大侠指教啊
- 安装了VS.NET,建了一个网站,可以用localhost:1316正常运行,可是用IIS调试时(localhost)却出错?
- 【高分求助】寻16进制编辑控件,或高分求高手给做一个,像UltraEdit,或者金山游侠那样的。
- 送分来拉 字符串反转
- WinForm中的TextBox的Ctrl+C,Ctrl+V快捷键不能用,帮忙解决一下
- 求vs.net2005正式版的HTTP下载地址
- 在一个类里面操作一个窗体的问题
- 简单的问题,在winform 中操作excel必须引用那些namespace或者reference?
- 求教高手:有没有什么好的办法捕获程序每次向MS SQL服务器提交的数据容量?
- treeview 节点值
- c#中如何卸载U盘???????
最后DataTable结果为
DataSet0 StoredProcedure fxf_GetResource @p_ResourceID
DataSet0 StoredProcedure fxf_GetResource @p_LCID
DataSet1 StoredProcedure [fxf_GetStaffInfo] @IsPersonal_p
DataSet1 StoredProcedure [fxf_GetStaffInfo] @UserID_p
<rd:DrawGrid>true</rd:DrawGrid>
会报错:{"'rd' is an undeclared namespace. Line 6, position 8."}
怎么得到这两个DataSet?
我用
XmlNodeList nodes = xmlDoc.SelectNodes("//DataSets");
只返回1个DataSet
会报错:{"'rd' is an undeclared namespace. Line 6, position 8."}怎么解决阿
FileStream filestm = new FileStream("filename", FileMode.Open, FileAccess.Read);
byte[] buffer = new byte[(int)filestm.Length];
filestm.Read(buffer, 0, buffer.Length);
string ls_temp = buffer.ToString();
ls_temp = ls_temp.Replace("rd:", "");
xmlDoc.l.LoadXml(ls_temp);问题是 buffer.ToString();并不是我想得到的
怎么把byte[]里的内容转成string 呢?
XmlDocument xmlDoc = new XmlDocument();
string ls_temp = "";
StreamReader srm = new StreamReader(filepath,Encoding.Default);
ls_temp = srm.ReadToEnd();
ls_temp = ls_temp.Replace("rd:", "");
xmlDoc.LoadXml(ls_temp);DataTable myData = new DataTable();
myData.Columns.Add(new DataColumn("DataSetName", System.Type.GetType("System.String")));
myData.Columns.Add(new DataColumn("CommandType", System.Type.GetType("System.String")));
myData.Columns.Add(new DataColumn("CommandText", System.Type.GetType("System.String")));
myData.Columns.Add(new DataColumn("QueryParameterName", System.Type.GetType("System.String")));XmlNodeList nodes = xmlDoc.SelectNodes("//DataSets/DataSet");
XmlNodeList subnodes = null;
string ls_DataSetName = "";
string ls_CommandType = "";
string ls_CommandText = "";
string ls_QueryParameterName = "";for (int i = 0; i < nodes.Count; i++)
{
XmlElement xe = (XmlElement)nodes[i];
ls_DataSetName = xe.GetAttribute("Name"); xe = null;
xe = (XmlElement)nodes[i].SelectSingleNode("Query").SelectSingleNode("CommandType");
ls_CommandType = xe.InnerText; xe = (XmlElement)nodes[i].SelectSingleNode("Query").SelectSingleNode("CommandText");
ls_CommandText = xe.InnerText;
subnodes = nodes[i].SelectSingleNode("Query").SelectSingleNode("QueryParameters").SelectNodes("QueryParameter");
for (int j = 0; j < subnodes.Count; j++)
{
xe = (XmlElement)subnodes[j];
ls_QueryParameterName = xe.GetAttribute("Name");
myData.Rows.Add(ls_DataSetName, ls_CommandType, ls_CommandText, ls_QueryParameterName); }
}不知道有没有更简单的写法?