using System; using System.Configuration; using System.Data; using System.Linq; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.HtmlControls; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Xml.Linq; using System.Data.SqlClient; using System.IO; public partial class news_archives : System.Web.UI.Page { string month; SqlConnection con = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["RSIC"].ConnectionString); protected void Page_Load(object sender, EventArgs e) { if (Session["username"] == null) { Response.Redirect("login.aspx"); } else { if (!Page.IsPostBack) { fill_Tree(); } } } void fill_Tree() { con.Open(); SqlCommand SqlCmd = new SqlCommand("Select * from mnth", con); SqlDataReader Sdr = SqlCmd.ExecuteReader(); SqlCmd.Dispose(); string[,] ParentNode = new string[100, 2]; int count = 0; while (Sdr.Read()) { ParentNode[count, 0] = Sdr.GetValue(Sdr.GetOrdinal("mntn")).ToString(); ParentNode[count++, 1] = Sdr.GetValue(Sdr.GetOrdinal("mnt")).ToString(); } Sdr.Close(); for (int loop = 0; loop < count; loop++) { TreeNode root = new TreeNode(); root.Text = ParentNode[loop, 1]; root.Target = "_blank"; root.NavigateUrl = "mypage.aspx"; SqlCommand Module_SqlCmd = new SqlCommand("Select SrNo,Title,convert(varchar(10),pDate,105)as Date,Detail from news where mnt =" + ParentNode[loop, 0], con); SqlDataReader Module_Sdr = Module_SqlCmd.ExecuteReader(); while (Module_Sdr.Read()) { TreeNode child = new TreeNode(); child.Text = Module_Sdr.GetValue(Module_Sdr.GetOrdinal("Title")).ToString(); // child.Target = "_blank"; // child.NavigateUrl = "your_page_Url.aspx"; root.ChildNodes.Add(child); } Module_Sdr.Close(); TreeView2.Nodes.Add(root); } TreeView2.CollapseAll(); con.Close(); } protected void TreeView2_TreeNodePopulate(object sender, TreeNodeEventArgs e) { } protected void TreeView3_TreeNodePopulate(object sender, TreeNodeEventArgs e) { } protected void TreeView2_SelectedNodeChanged(object sender, EventArgs e) { string temp = Convert.ToString(TreeView2.SelectedNode.Text); Label3.Text=temp; bindgrid(); } public void bindgrid() { if (con.State != ConnectionState.Open) { con.Open(); } //SqlCommand cmd = new SqlCommand("select SrNo,cname from testimonial ", conn); SqlCommand mySqlCommand = new SqlCommand("select SrNo,convert(varchar(10),pDate,105)as pDate,Title,Detail from news where Title='" + Label3.Text + "' ", con); SqlDataAdapter mySqlAdapter = new SqlDataAdapter(mySqlCommand); DataSet myDataSet = new DataSet(); mySqlAdapter.Fill(myDataSet); GridView1.DataSource = myDataSet; GridView1.DataBind(); //GridView1.Rows[0].Cells.Count; // this.GridView1.Rows.Count.ToString(); } }