I have a list of Categories which I need to bind to a TreeView control in WPF and I can't find a working tutorial or get it working.My Category class consist of (ID, Title, ParentID). If the Category is a top level category the parentID is null.Can anyone sow me how to bind this to a treeview?
View 3 RepliesI am just learning ASP.NET c# and trying to incorporate best practices into my applications. Everything that I read says to layer my applications into DAL, BLL, UI, etc based on separation of concerns. Instead of passing datatables around, I am thinking about using custom objects so that I am loosely coupled to my data layer and can take advantage of intellisense in VS. I assume these objects would be considered DTOs?
First, where do these objects reside in my layers? BLL, DAL, other?
Second, when populating from SQL, should I loop through a data reader to populate the list or first fill a data table, then loop through the table to populate the list? I know you should close the database connection as soon as possible, but it seems like even more overhead to populate the data table and then loop through that for the list.
Third, everything I see these days says use Linq2SQL. I am planning to learn Linq2SQL, but at this time I am working with a legacy database that doesn't have foreign keys setup and I do not have the ability to fix it atm. Also, I want to learn more about c# before I start getting into ORM solutions like nHibernate. At the same time I don't want to type out all the connection and SQL plumbing for every query. Is it ok to use the Enterprise DAAB for now?
I am displaying data with in textboxes in gridview here user will change the values my problam is how to get the gridview data and assign it to List?
View 1 RepliesI have the following Students class:
[Code]....
I need the 1 since it's a foreign key in another table. For the life of me, I can't get this to work like this.
I use MS SQL, EF 4 and C#.
I have a table in SQL fro "Categories" and I need populate a TreeView in my Asp.net page.
My question are:
1 - How can i populate the TreeView?
2 - How can i use the TreeView to modify the hierarchy of my Categories?
NOTE: I use "hierarchyid" SQL Columns!
CREATE TABLE dbo.CmsCategories
(
CategoryId int NOT NULL IDENTITY (0,1) -- Seed = 0 and Increment= 1
CONSTRAINT PK_CmsCategories_CategoryId PRIMARY KEY,
Title nvarchar(40) NOT NULL,
MetaDescription nvarchar(160) NOT NULL,
MetaKeyword nvarchar(128) NOT NULL,
Summary nvarchar(256) NOT NULL,
IsPublished bit NOT NULL
CONSTRAINT DF_CmsCategories_IsPublished DEFAULT 1,
CategoryNode hierarchyid NOT NULL,
CategoryNodeLevel AS CategoryNode.GetLevel()
);
I have a large XML file (3000+ nodes) that I want to represent in a TreeView on ASP.NET. I cannot databind it to a XMLDataSource because loading the TreeView will then be way too slow (I never even waited long enough to see it finish...)
So the solution for this would be to use the PopulateOnDemand property of the TreeNodes to load data only when needed. Problem is, I can't think of a way to acheive this...
How can-I, based on the ID of a node, search a XMLDocument to get all the childnodes of the node having this ID?
XML would look like that:
<document ID=1>
<document ID=2>
<document ID=3>
</document>
</document>
<document ID=4>
</document>
</document>
There are nor rules on how much levels it can go down or anything...
can populate a treeview from an ftp folder
View 3 RepliesI'm currently working on a Web Site application project that requires a treeview to be heirarchically structured based on the attribute ids of each node rather than the format of the XML.
[Code]....
At present the above is lining up all names under each other, I would like the hierarchy to be based on the attribute parentid and Id. For example: Jane Smith should be a child of Joe smith and Bob Turner is a Child of Jane Smith.
How to do this programitically.
I want to populate treeview control parent and child nodes dynamically from the database table using sql server,asp.net and c# code,so that when user clicks the node in the treeview, it would take me to the selected aspx page.
I have searched a while for a good solution for this, but i have only found solutions with XML files and mssql.
I have 2 tables. Table parent holds the parent nodes and table child holds the childnodes related to the parentnodes.
Table parent looks like this: pID as integer (pk), parentName as varchar
Table child looks like this: cID as integer (pk), parentID as integer, childName as varchar
I want to populate the treeview with data from these tables! How can i do that?
How to bind TreeView Control in asp.net using C# code?
View 1 RepliesI have string which came from the database,now i want to compare each charater of the string with the radiobuttonlist value and check box list value and select both radiobutton list and checkboxlist.
Here i write down some code but its just select 2 item of the each radiobuttonlist and checked all checkboxlist.
[Code]....
I'm designing my own custom control that contains a .NET dropdownlist. What I'm wondering is if it is possible to populate my dropdownlist with listitems placed in a placeholder? For example:
<asp:DropDownList ID="ddlFilter" runat="server" >
<asp:PlaceHolder ID="ListItemPlaceholder" runat="server"/>
</asp:DropDownList>
This doesn't work because the DropDownList control only allows ListItems as child controls. But, I want to do something similar to this so when the user includes my control on a page, they can do something like this:
<mytag:MyControl Mode="DropDown" runat="server">
<ListItemTemplate>
<asp:ListItem Text="C" Value="c"></asp:ListItem>
<asp:ListItem Text="E" Value="e"></asp:ListItem>
<asp:ListItem Text="B" Value="b"></asp:ListItem>
</ListItemTemplate>
</myTag:MyControl>
I know I can do this by dynamically adding the ListItems in the page code behind, but I'd like to avoid that if possible.
I am binding the XML Data to treeview using XMLDataSource. Its working fime, but when the Number of nodes and childnodes increases, the treenode expand and to display the content in iframe takes moer time.
<asp:TreeView ID="TreeView1" OnSelectedNodeChanged = "OnClick" runat="server"
ExpandDepth="0" ShowExpandCollapse="true" ForeColor="Red" Font-Underline = "false"
ondatabinding="TreeView1_DataBinding" CollapseImageUrl = "Resources/TocColapse.bmp" ExpandImageUrl = "Resources/TocParent.bmp" Font-Names="Arial" >
<SelectedNodeStyle Font-Underline="false" BackColor="White" ForeColor="#0483e0" />
<NodeStyle Font-Size="11pt" ForeColor="white" HorizontalPadding="5px"
NodeSpacing="0px" VerticalPadding="0px" Font-Underline = "false" />
<ParentNodeStyle ForeColor="#0483e0" Font-Underline = "false" />
<LeafNodeStyle ForeColor="#0483e0" Font-Underline = "false" ImageUrl = "Resources/TocChild.bmp" />
</asp:TreeView>
<asp:XmlDataSource ID="XmlDataSource1" runat="server" XPath="/*/*" EnableCaching = "false" ></asp:XmlDataSource>
In OnDataBinding event of treeview I implemented the following code:
TreeNodeBinding[] TreeNode = new TreeNodeBinding[Count];
for (int i = 0; i < Count; i++)
{
TreeNode[i] = new TreeNodeBinding();
TreeNode[i].DataMember = TableOfContents[i].GetElementName();
TreeNode[i].TextField = TableOfContents[i].GetFirstAttributeName();
TreeNode[i].ValueField = TableOfContents[i].GetSecondAttributeName();
// TreeNode[i].Target = "contentFrame";
TreeView1.DataBindings.Add(TreeNode[i]);
}
populate a treeview from an ftp directory?
View 3 RepliesI have a list view control. Each row within it has a rowid and a textbox where a note(user enters relevant info to that particular record) is entered. On a paging event I store the rowID and the note text in a generic list for retrieval if the user pages back later on. Goal here is to keep the text the user has entered. (see the code below)This generic list does in fact get populated correctly when I go to the next page currently. I can see this in Visual Studio. So now, when the user goes back to the first page I want to run a test within my Listviews ItemDataBound event. I want to see if the row ID being tested is part of the generic list. If so, I then want to take the corresponding note that is also within the list and bind it to the text box. However, I don't know how to write the correct conditional for this and how to bind the textbox if the conditional evaluates to true.
View 1 RepliesI'm trying to populate a dropdown list from a list of existing SQL tables in a database. Does anyone have a code sample for doing this?
View 10 RepliesI need populate a TreeView control to display Hierarchy Data from a DataBase.
The Hierarchy Order has been dictated by a Column, in my DB called "CategoryNodeString" and "CategoryNodeLevel".
/ = Root
Example:
CategoryId CategoryNodeString CategoryNodeLevel
1 / 0
2 /1/ 1
3 /2/ 1
4 /1/1/ 2
5 /1/2/ 2
6 /1/1/1 3
Can you provide me a sample of code to start?
How can I add a Treeview to the DropDownList for show child and parent record..
View 1 RepliesI have two generic list with Hotel class object. Both List contains hotel ID. I want to retrieve common hotel id from both Hotel List and assign to new HotelList.I have done following code for that but any other sort way to implement this kind of functionality.
[Code]....
Note: I dont want to use Linq because I am working on framwork 2.0
I'm trying to render out some images on an aspx page. Error I'm getting in the code below is:
DataBinding: '_Default+ImageThing' does not contain a property with the name 'FileName'.
public class ImageThing
{
public string FileName;
}
private void DisplayThumbnailImages()
{
ImageThing imageThing1 = new ImageThing();
ImageThing imageThing2 = new ImageThing();
imageThing1.FileName = "asdf.jpg";
imageThing2.FileName = "aaa.jpg";
List<ImageThing> imagesToRender = new List<ImageThing>();
imagesToRender.Add(imageThing1);
imagesToRender.Add(imageThing2);
Repeater1.DataSource = imagesToRender;
Repeater1.DataBind();
}
here is the aspx:
<asp:Repeater ID="Repeater1" runat="server">
<ItemTemplate>
<%#DataBinder.Eval(Container.DataItem, "FileName")%>
</ItemTemplate>
</asp:Repeater>
in my model there is a List.
public class InvoiceModel{
public int InvoiceID { get; set; }
public int Date { get; set; }[code]...
for create view i can use Html.TextBoxFor(m => m.InvoiceID) and for Date.but how can i fill List?and how can i use global for this list as Shopping cart?
C#- bind treeview runtime using dataset and data table
simple example
I need to populate a listbox, however, the value on the second box needs to derive from the first one, such as when I click on North America, USA and Canada would show up. the tricky part is that I need to be able to select North America and Europe in the same time and 2nd list box needs to show USA, Canada, UK, Italy, German accordingly.
A1: North America
A2: Europe
A3: Asia
B1: USA
B2: Canada
C1: UK
C2: Italy
C3: German
D1: China
D2: India
Can any one can describe the main diffrence between the array and generic list.
View 6 Replies