-----------------------------------------------------------
New Message on BDOTNET
-----------------------------------------------------------
From: BalajiKrishnan
Message 3 in Discussion
Hi Vaibhav, Thanks for your response. I had done
it,I had messed up the split function. Here is my code.
string connString = "user id=sa;password=sa;" +
"Database=;server=;";
string sqlQueryString = "Select strElelement from tblsecurity where " +
"intFnkCategoryID = 3 AND StrDimName = 'Store' order by strelelement";
SqlConnection myConn = new SqlConnection(connString);
myConn.Open();
SqlCommand cmd = new SqlCommand(sqlQueryString,myConn);
SqlDataReader dr;
dr = cmd.ExecuteReader();
string delimstr = @"\";
char[] delim = delimstr.ToCharArray();
string[] split = null;
int intIndex = 0;
XmlTextWriter myXmlTextWriter = new System.Xml.XmlTextWriter (@"C:\BALAJI.xml",
System.Text.Encoding.UTF8);
myXmlTextWriter.Formatting = Formatting.Indented;
myXmlTextWriter.WriteStartDocument(true);
myXmlTextWriter.WriteDocType("TreeNode", null, null, null);
myXmlTextWriter.WriteStartElement("TREENODES");
while (dr.Read())
{
string strvalue = dr.GetValue(0).ToString();
split = strvalue.Split(delim, strvalue.Length);
int intlength = split.Length;
if(intIndex == intlength || intIndex == 0)
{
if (intIndex != 0)
{
myXmlTextWriter.WriteEndElement();
}
myXmlTextWriter.WriteStartElement("treenode", null);
myXmlTextWriter.WriteAttributeString("text", dr.GetValue(0).ToString());
myXmlTextWriter.WriteAttributeString("NavigateURL","showelement.aspx?ElName=" +
dr.GetValue(0).ToString());
strvalue = dr.GetValue(0).ToString();
split = strvalue.Split(delim, strvalue.Length);
intlength = split.Length;
intIndex = intlength;
}
else
{
strvalue = dr.GetValue(0).ToString();
split = strvalue.Split(delim, strvalue.Length);
intlength = split.Length;
for(int i = intIndex; i >= intlength; i--)
{
myXmlTextWriter.WriteEndElement();
}
myXmlTextWriter.WriteStartElement("treeNode", null);
myXmlTextWriter.WriteAttributeString("text", dr.GetValue(0).ToString());
myXmlTextWriter.WriteAttributeString("NavigateURL","showelement.aspx?ElName=" +
dr.GetValue(0).ToString());
strvalue = dr.GetValue(0).ToString();
split = strvalue.Split(delim, strvalue.Length);
intlength = split.Length;
intIndex = intlength;
}
}
myXmlTextWriter.WriteEndElement();
myXmlTextWriter.Flush();
myXmlTextWriter.Close();
myConn.Close();
}
-----------------------------------------------------------
To stop getting this e-mail, or change how often it arrives, go to your E-mail
Settings.
http://groups.msn.com/BDotNet/_emailsettings.msnw
Need help? If you've forgotten your password, please go to Passport Member Services.
http://groups.msn.com/_passportredir.msnw?ppmprop=help
For other questions or feedback, go to our Contact Us page.
http://groups.msn.com/contact
If you do not want to receive future e-mail from this MSN group, or if you received
this message by mistake, please click the "Remove" link below. On the pre-addressed
e-mail message that opens, simply click "Send". Your e-mail address will be deleted
from this group's mailing list.
mailto:[EMAIL PROTECTED]
