protectedvoid Page_Load(object sender, EventArgs e)
{
SqlConnection cnn = newSqlConnection(ConfigurationManager.ConnectionStrings["IGMConnectionString"].ConnectionString);
SqlCommand Cmd = newSqlCommand("SELECT Fabrica,CNC,f1,s1,ae1,ap1,chatter1,outros1,f2,s2,ae2,ap2,chatter2,outros2,cod_ferramenta FROM parametros_maquinas", cnn);
cnn.Open();
SqlDataReader Reader = Cmd.ExecuteReader();
while (Reader.Read())
{
TreeView1.Nodes.Add(new TreeNode(Reader.GetString(1), Convert.ToString(Reader.GetInt64(0))));
}
cnn.Close();
}
protectedvoid Onload(EventArgs e)
{
base.OnLoad(e);
XmlReaderSettings setts = newXmlReaderSettings();
setts.Schemas.Add("", this.MapPath("Consultar.xsd"));
setts.ValidationType = ValidationType.Schema;
setts.ValidationEventHandler += newValidationEventHandler(ProcessError);
XmlReader reader = XmlReader.Create(this.MapPath(""), setts);
//XmlReader = XmlReader.Create(this.MapPath("Consultar.xml"), setts);
XmlDocument doc = newXmlDocument();
doc.Load(reader);
}
// if (!ProcessOK)
// {
// TreeView1.DataSourceID = ""; return;}
// Source.data = doc.InnerXml;}
protectedvoid ProcessError (Object sender, ValidationEventArgs args)
{
info.Text=args.Exception.ToString();
//ProcessOK=false;
}
e no aspx
<asp:TreeViewID="TreeView1"runat="server"DataSourceID="XmlDataSource1"ImageSet="Contacts"
NodeIndent="10"ShowLines="True"LineImagesFolder="~/TreeLineImages"Width="135px">
<ParentNodeStyleFont-Bold="True"ForeColor="#5555DD"/>
<HoverNodeStyleFont-Underline="False"/>
<SelectedNodeStyleFont-Underline="True"HorizontalPadding="0px"VerticalPadding="0px"/>
<NodeStyleFont-Names="Verdana"Font-Size="8pt"ForeColor="Black"HorizontalPadding="5px"
NodeSpacing="0px"VerticalPadding="0px"/>
<DataBindings>
<asp:TreeNodeBindingDataMember="Fabrica"TextField="#InnerText"ValueField="#InnerText"/>
<asp:TreeNodeBindingDataMember="Maquina"TextField="#InnerText"ValueField="#InnerText"/>
<asp:TreeNodeBindingDataMember="Operacao"TextField="#InnerText"/>
<asp:TreeNodeBindingDataMember="Estrategia"TextField="#InnerText"/>
<asp:TreeNodeBindingDataMember="Diametro"TextField="#InnerText"/>
<asp:TreeNodeBindingDataMember="Raio"TextField="#InnerText"/>
<asp:TreeNodeBindingDataMember="Altura"TextField="#InnerText"/>
<asp:TreeNodeBindingDataMember="Tipo"TextField="#InnerText"/>
<asp:TreeNodeBindingDataMember="FabricanteCabeca"TextField="#InnerText"/>
<asp:TreeNodeBindingDataMember="pastilhas"TextField="#InnerText"/>
<asp:TreeNodeBindingDataMember="n_pastilhas"TextField="#InnerText"/>
<asp:TreeNodeBindingDataMember="tipopastilhas"TextField="#InnerText"/>
<asp:TreeNodeBindingDataMember="fabricante"TextField="#InnerText"/>
<asp:TreeNodeBindingDataMember="grao"TextField="#InnerText"/>
<asp:TreeNodeBindingDataMember="Parametros"TextField="#InnerText"/>
<asp:TreeNodeBindingDataMember="ParametrosFerramenta"TextField="#InnerText"/>
<asp:TreeNodeBindingDataMember="parametrosfabricante"TextField="#InnerText"/>
<asp:TreeNodeBindingDataMember="parametrosvarios"TextField="#InnerText"/>
<asp:TreeNodeBindingDataMember="parametros2d"TextField="#InnerText"/>
<asp:TreeNodeBindingDataMember="parametros2_3eixos"TextField="#InnerText"/>
<asp:TreeNodeBindingDataMember="parametros5eixos"TextField="#InnerText"/>
<asp:TreeNodeBindingDataMember="parametros_suportes_cone"TextField="#InnerText"/>
<asp:TreeNodeBindingDataMember="ParametrosMaquina"TextField="#InnerText"/>
<asp:TreeNodeBindingDataMember="CNC"TextField="#InnerText"/>
<asp:TreeNodeBindingDataMember="Operacao"TextField="#InnerText"/>
<asp:TreeNodeBindingDataMember="Estrategia"TextField="#InnerText"/>
<asp:TreeNodeBindingDataMember="Nome"TextField="#InnerText"/>
<asp:TreeNodeBindingDataMember="media"TextField="#InnerText"/>
<asp:TreeNodeBindingDataMember="maximo"TextField="#InnerText"/>
<asp:TreeNodeBindingDataMember="Grupo"TextField="#InnerText"/>
<asp:TreeNodeBindingDataMember="media"TextField="#InnerText"/>
<asp:TreeNodeBindingDataMember="maximo"TextField="#InnerText"/>
<asp:TreeNodeBindingDataMember="GrupoSimoldes"TextField="#InnerText"/>
<asp:TreeNodeBindingDataMember="media"TextField="#InnerText"/>
<asp:TreeNodeBindingDataMember="maximo"TextField="#InnerText"/>
<asp:TreeNodeBindingDataMember="outros"TextField="#InnerText"/>
<asp:TreeNodeBindingDataMember="f"TextField="#InnerText"/>
<asp:TreeNodeBindingDataMember="s"TextField="#InnerText"/>
<asp:TreeNodeBindingDataMember="ae"TextField="#InnerText"/>
<asp:TreeNodeBindingDataMember="ap"TextField="#InnerText"/>
<asp:TreeNodeBindingDataMember="chatter"TextField="#InnerText"/>
<asp:TreeNodeBindingDataMember="outros"TextField="#InnerText"/>
<asp:TreeNodeBindingDataMember="uf"TextField="#InnerText"/>
</DataBindings>
</asp:TreeView>
<asp:XmlDataSourceID="XmlDataSource1"runat="server"DataFile="~/Consultar.xml"></asp:XmlDataSource>
o meu xml e este
<Consultar>
<Ferramentas>
<Fabrica> Fabrica</Fabrica>
<Maquina>Maquina</Maquina>
<Operacao>Operacao</Operacao>
<Estrategia> Estrategia</Estrategia>
<Parametros_Maquinas>
<Maquinas>
<media> Media Maquina </media>
<maximo> Maximo Maquina</maximo>
</Maquinas>
<Grupo_Maquinas>
<media> Media Grupo Maquinas</media>
<maximo> Maximo Grupo Maquinas</maximo>
</Grupo_Maquinas>
<Grupo_Simoldes>
<media> Media Grupo Simoldes </media>
<maximo> Maximo Grupo Simoldes</maximo>
</Grupo_Simoldes>
</Parametros_Maquinas>
</Ferramentas>
</Consultar>
O que preciso de saber e ao clicar em cada nod faxer uma consulta a essa tabela ou campos.
<Consultar>
<Ferramentas>
<Fabrica> Fabrica</Fabrica>
<Maquina>Maquina</Maquina>
<Operacao>Operacao</Operacao>
<Estrategia> Estrategia</Estrategia>
<Parametros_Maquinas>
<Maquinas>
<media> Media Maquina </media>
<maximo> Maximo Maquina</maximo>
</Maquinas>
<Grupo_Maquinas>
<media> Media Grupo Maquinas</media>
<maximo> Maximo Grupo Maquinas</maximo>
</Grupo_Maquinas>
<Grupo_Simoldes>
<media> Media Grupo Simoldes </media>
<maximo> Maximo Grupo Simoldes</maximo>
</Grupo_Simoldes>
</Parametros_Maquinas>
</Ferramentas>
</Consultar>