EXT.NET 绑定XML数据源

来源：互联网发布：下载戏曲的软件编辑：程序博客网时间：2024/06/05 09:12

<ext:ComboBox ID="ComboBox_DB" runat="server" FieldLabel="数据库"
LabelWidth="50" LabelAlign="Right" DisplayField="DBName" ValueField="DBName" QueryMode="Local"
Width="150">
<Store>
<ext:Store ID="Store_DB" runat="server">
<Model>
<ext:Model ID="Model_DB" runat="server">
<Fields>
<ext:ModelField Name="DBName" />
<ext:ModelField Name="ConStr" />
</Fields>
</ext:Model>
</Model>
<Proxy>
<ext:AjaxProxy Url="/Main/GetDBConn">
<Reader>
<ext:ArrayReader Root="data" TotalProperty="total" />
</Reader>
</ext:AjaxProxy>
</Proxy>
</ext:Store>
</Store>

</ext:ComboBox>

XML：

<?xml version="1.0" encoding="utf-16"?>
<Config>
<DB DBName="JL" ConStr="server=TEST;user id=SYS;password=123">
<Tablespace>SYS</Tablespace>
<pctfree>10</pctfree>
<initrans>2</initrans>
<maxtrans>255</maxtrans>
<initial>64K</initial>
<next>1M</next>
<minextents>1</minextents>
<maxextents>unlimited</maxextents>
</DB>
<DB DBName="BJ" ConStr="server=TEST;user id=SYS;password=123">
<Tablespace>SYS</Tablespace>
<pctfree>10</pctfree>
<initrans>2</initrans>
<maxtrans>255</maxtrans>
<initial>64K</initial>
<next>1M</next>
<minextents>1</minextents>
<maxextents>unlimited</maxextents>
</DB>
</Config>

后台代码

#region 获取所有数据连接串
/// <summary>
/// 获取所有数据连接串
/// </summary>
/// <returns></returns>
public StoreResult GetDBConn()
{
StoreResult SR = new StoreResult();
string XmlUrl = Server.MapPath(@"/Config/DBConfig.xml");
XmlNodeList XNL = XMLHelper.GetXmlNodeListByXpath(XmlUrl, "/Config/DB");
if (XNL.Count == 0)
{
SR.Message = "没有找到子节点";
SR.Success = false;
SR.Data = null;
SR.Total = 0;
return SR;
}
object[] obj = new object[XNL.Count];
int i = 0;
foreach (XmlNode node in XNL)
{
obj[i] = new object[] { ((XmlElement)node).GetAttribute("DBName"), ((XmlElement)node).GetAttribute("ConStr") };
i++;
}
SR.Data = obj;
SR.Total = obj.Length;
return SR;
}
#endregion

注：此处运用的XMLHelper 地址 http://blog.csdn.net/zhannabiedong/article/details/48463763

0 0