i want to save Treeview checkbox checked nodes will be saved

Question

hi friends iam new to treeview control using i want to save treeview checked nodes will be save in to database table please help me..

Satyapriya Nayak · Answer

Untitled Page SaveSelectedValue: /> using System; using System.Collections; 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; namespace Treeview_checkbox_checked_nodes { public partial class WebForm1 : System.Web.UI.Page { string strConnString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString; string str; SqlCommand com; protected void btn_save_Click(object sender, EventArgs e) { Response.Write(" Seleted values of nodes: "); foreach (TreeNode item in this.TreeView1.CheckedNodes) { SqlConnection con = new SqlConnection(strConnString); con.Open(); str = "Insert into item values ('" + item.Text + "')"; com = new SqlCommand(str, con); com.ExecuteNonQuery(); con.Close(); Response.Write(item.Value + " "); } } } } Table is item items varchar(50)

chandu gummadi · Answer

http://s831.beta.photobucket.com/user/Oasisfactor/media/menu.jpg.html FRIEND PLEASE CHECK THIS LINK SEE IT. MY AIM IS CHECKED NODES WILL BE SAVE IN TO DATABASE.IAM USING ONLY ONE TABLE

Satyapriya Nayak · Answer

Normal 0 false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4 Category table Category_ID varchar(50) CategoryName varchar(50) SubCategory Table SubCategory_ID varchar(50) SubCategoryName varchar(50) Category_ID varchar(50) ------ Category1 table CategoryName varchar(50) /* Style Definitions */ table.MsoNormalTable{mso-style-name:"Table Normal";mso-tstyle-rowband-size:0;mso-tstyle-colband-size:0;mso-style-noshow:yes;mso-style-priority:99;mso-style-qformat:yes;mso-style-parent:"";mso-padding-alt:0in 5.4pt 0in 5.4pt;mso-para-margin-top:0in;mso-para-margin-right:0in;mso-para-margin-bottom:10.0pt;mso-para-margin-left:0in;line-height:115%;mso-pagination:widow-orphan;font-size:11.0pt;font-family:"Calibri","sans-serif";mso-ascii-font-family:Calibri;mso-ascii-theme-font:minor-latin;mso-fareast-font-family:"Times New Roman";mso-fareast-theme-font:minor-fareast;mso-hansi-font-family:Calibri;mso-hansi-theme-font:minor-latin;}

chandu gummadi · Answer

Please could you send me the tables columns of catogory and subcatagory.

Satyapriya Nayak · Answer

Untitled Page SaveSelectedValue: onclick="btn_save_Click"/> using System; using System.Collections; 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; namespace Treeview_checkbox_checked_nodes { public partial class _Default : System.Web.UI.Page { string strConnString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString; string str; SqlCommand com, com1; protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { bindtree(); } } void bindtree() { SqlConnection con = new SqlConnection(strConnString); con.Open(); str = "Select * from Category"; com = new SqlCommand(str, con); SqlDataReader reader = com.ExecuteReader(); com.Dispose(); string[,] ParentNode = new string[100, 2]; int count = 0; while (reader.Read()) { ParentNode[count, 0] = reader.GetValue(reader.GetOrdinal("Category_ID")).ToString(); ParentNode[count++, 1] = reader.GetValue(reader.GetOrdinal("CategoryName")).ToString(); } reader.Close(); for (int loop = 0; loop { TreeNode root = new TreeNode(); root.Text = ParentNode[loop, 1]; com1 = new SqlCommand("Select * from SubCategory where Category_ID =" + ParentNode[loop, 0], con); SqlDataReader reader1 = com1.ExecuteReader(); while (reader1.Read()) { TreeNode child = new TreeNode(); child.Text = reader1.GetValue(reader1.GetOrdinal("SubCategoryName")).ToString(); root.ChildNodes.Add(child); } reader1.Close(); TreeView1.Nodes.Add(root); } } protected void btn_save_Click(object sender, EventArgs e) { Response.Write(" Seleted values of nodes: "); foreach (TreeNode item in this.TreeView1.CheckedNodes) { SqlConnection con = new SqlConnection(strConnString); con.Open(); str = "Insert into Category1 values ('" + item.Text + "')"; com = new SqlCommand(str, con); com.ExecuteNonQuery(); con.Close(); Response.Write(item.Value + " "); } } } }