781 1
How to create N Level Of TreeView from database in asp.net

Hello Guys !!

I have already asked the same question but now I am again asking with the new requirement, so please read carefully and solve my issues.

 My Requirement:

  •    How to create n level of Treeview in asp.net c# from SQL Database Record.

Explaining my Requirement

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="N-level-Treeview.aspx.cs"
Inherits="N_level_Treeview" %>
 
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:TreeView ID="TreeView1" runat="server" ImageSet="XPFileExplorer" NodeIndent="15">
<HoverNodeStyle Font-Underline="True" ForeColor="#6666AA" />
<NodeStyle Font-Names="Tahoma" Font-Size="8pt" ForeColor="Black" HorizontalPadding="2px"
NodeSpacing="0px" VerticalPadding="2px"></NodeStyle>
<ParentNodeStyle Font-Bold="False" />
<SelectedNodeStyle BackColor="#B5B5B5" Font-Underline="False" HorizontalPadding="0px"
VerticalPadding="0px" />
</asp:TreeView>
</div>
</form>
</body>
</html>?

: -  I have a table and there are Srno,PId, Pname, CID, CName,Cqty columns in my table.

Suppose if CID is also in PID column,  Node must be created on that CID and also must have expand button to show the child of that cID.

What i have done in coding let's see...

CS--------

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
 
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
public partial class N_level_Treeview : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!this.IsPostBack)
{
DataTable dt = this.GetData("SELECT cId, cName FROM TopBill");
this.PopulateTreeView(dt, 0, null);
}
}
 
private void PopulateTreeView(DataTable dtParent, int parentId, TreeNode treeNode)
{
foreach (DataRow row in dtParent.Rows)
{
TreeNode child = new TreeNode
{
Text = row["cName"].ToString(),
Value = row["cId"].ToString()
};
if (parentId == 0)
{
TreeView1.Nodes.Add(child);
DataTable dtChild = this.GetData("SELECT srNo,cid, cName FROM TopBill WHERE pid = " + child.Value);
PopulateTreeView(dtChild, int.Parse(child.Value), child);
}
else
{
treeNode.ChildNodes.Add(child);
}
}
}
 
private DataTable GetData(string query)
{
DataTable dt = new DataTable();
string constr = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
using (SqlConnection con = new SqlConnection(constr))
{
using (SqlCommand cmd = new SqlCommand(query))
{
using (SqlDataAdapter sda = new SqlDataAdapter())
{
cmd.CommandType = CommandType.Text;
cmd.Connection = con;
sda.SelectCommand = cmd;
sda.Fill(dt);
}
}
return dt;
}
}
}

-------------- Current Output of my Code is ...

...

Type
Question
Treeview C# Asp.Net SQL
773 1
Error "Entity Framework: Store update, insert, or delete statement affected an unexpected number of rows (0)"

Hello, I am using Entity framework in my asp.net MVC project, when I try to delete any row using Entity framework, I am getting following error

...
Type
Question
ASP.NET MVC Store update insert or delete statement affected an unexpected C# Entity-framework
760 1
The model backing the 'bwavenueDbContext' context has changed since the database was created. Consider using Code First Migrations to update the database

I am getting this error when trying to work on Code First migration with Entity Framework

The model backing the 'bwavenueDbContext' context has changed since the database was created. Consider using Code First Migrations to update the database

here is the error image

...

Type
Question
C# Code-first-migration Entity-framework
743 1
How to delete a single Record using Entity Framework?

How can I delete (remove) single record from database table using entity framework in asp.net MVC Controller?

please note I want to delete row of selected Id from the database permanently(Not to make a column IsActive and set it as false)

...
Type
Question
C# Entity-framework Delete a single record using EF sql-server
724 1
Calling Web Method in ASP.NET from jQuery Ajax
This article will give you quick example on how to call Web Method of ASP.NET using Ajax in jQuery.
Type
Article
ASP.NET C# calling webmethod from javascript call webmethod from jquery ajax

724 1
Need boiler plate ebook or demo

I want ebook or demo of asp.net boilerplate but do not paste home page(https://aspnetboilerplate.com/) of boilerplate.

thank you very much!!

...
Type
Question
asp net asp-net-boilerplate C#
718 2
Detect language of latin word on asp.net mvc using google translation api

Hi, please how we can detect if a latin string is in English or French or not recognized on asp.net MVC razor c# using google translation API ??? Thank u :) ...

...
Type
Question
Google translation api asp.net-mvc C# razor
715 1
Clicking on browser back button after login shows login page again??

How can I maintain the session of the user in ASP.NET MVC? Here is the login case for the user. (Only authenticated users are allowed to login in the system.) But once the user gets logged in and press the back button then the user needs to login again. I want to solve this issue. Can anyone have idea about it?

...
Type
Question
ASP.NET MVC C# session-management
704 2
Populating DropDownList with values showing error There is no ViewData item of type IEnumerable SelectListItem that has the key Name

I Have populated the DropDownList with the roles from the AspNetRoles, when I am registering a new user and allocating a role an error is thown

"There is no ViewData item of type 'IEnumerable<SelectListItem>' that has the key 'Name'."

My AccountController :

...
Type
Question
MVC C# SQL
695 1
Keep Pop up Modal Opened after saving data in Ajax.BeginForm

Hi, I wanted to stay open pop-up modal (this modal is partial view) after successfully inserting data in database, I am using Ajax.BeginForm to save data with PartialView

I want to stay it open so I can insert new data without clicking the create button again and i dont want to redirect it to Index View. Please see the image below of my code, Thanks...

 

...

Type
Question
C# BOOTSTRAP POPUP MODAL

Page 10 of 22