I am getting following output in Dataset
ActivityID ParentActivityID ActivityName AcivityLevel
0 NULL Dashboard 0
1 NULL Market Trends 0
2 1 News 1
and I want to build HTML list as follow.
<ul>
<li>Dashboard</li>
<li>Market Trends[code]....
I've data which looks something like this.
[code]....
To convert the above data into unordered list based on depth, I'm using the following code
[code]...
But the resulting unordered list doesnt seem to be forming properly(using which i am constructing a tree).For example "Site " with id '180' is supposed to appear as a direct child of "Televisions" with id '1',is appearing as a direct child of 'Flash' with id '191' using my code.so in addition to considering depth,I've decided to consider itemid as well in order to get the treeview properly.Those rows of the table with itemId not equal to null are not supposed to have a child node(i.e.,they are the leaf nodes in the tree) and all the other nodes can have child nodes.
Update:
The 'itemid' column refers to the id of an item which is present in another table.This column just in identifying if an item has any sub items(i.e., 'name' in my data in this case has any other unordered lists under it).
I'm trying to understand how to build a self referencing model for hierachical data. Eventually i will be creating a category tree.
I don't anything in tables yet. After I have the structure nailed down then I will create the tables. My existing Object is defined like this:
public class Categories
[Code]....
Can I read from a dataset and create a hierarchical horizontal menu?
View 4 Repliesi added a collection of data into a list box. i have another group of data with a group name.i want to add this group in to that same list box as a tree structure.
the sample list box is shown below.
item1
item2
item3
-group name
group item1
gruop item 2
gruop item 3
item 4
item 5
is there any way to do this. when clicking on the group name it must be expanded within the list box and i want to manage all these elements with an index.
I'm writing an ASP.Net application (no AJAX, but maybe) and there's a requirement to have a list of companies graded under a traffic light system. I intend to have these in a collapsible hierarchical list on the Master page, e.g. Red expands to show companies, and then companies can be further expanded.
how can I keep the expanded list in the same place, with the same content visible, between page loads?
I want to display child rows in the datagrid after the + sign is selected (like grouping & outlining in excel). This is automatic in infragistic grids but when i did in asp (no more infragistics) it doesnt work. here is my code (very simple stuff)
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>
<!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:GridView ID="GridView1" runat="server">
</asp:GridView>
</div>
</form>
</body>
</html>
DataSet ds = new DataSet();
ds.Tables.Add(myDataAccess.ExecuteSelectCommand("uspCategories"));
ds.Tables[0].TableName = "tblCategories";
ds.Tables.Add(myDataAccess.ExecuteSelectCommand("uspProducts"));
ds.Tables[1].TableName = "tblProducts";
DataRelation rel = new DataRelation("relation", ds.Tables[0].Columns["CategoryID"], ds.Tables[1].Columns["CategoryID"]);
ds.Relations.Add(rel);
GridView1.DataSource = ds;
GridView1.DataBind();
How can I build an user control that takes a list as a parameter, i.e:
<foo:TabMenu runat="server">
<Tabs>
<Tab Label="Tab1" PanelId="pnlTab1"/>
<Tab Label="Tab2" PanelId="pnlTab2"/>
<Tab Label="Tab3" PanelId="pnlTab3"/>
</Tabs>
</foo:TabMenu>
What is the quickest way once I have JSON array in hard to actually manufacture HTML? I'm thinking it's iterating the JSON arrays pulling out needed data and concatinating an HTML string that I pass to eval()? Is there a faster way?
View 1 RepliesI have an Employee model that has a Name and Company
I want to be able to build multiple Employees in one CREATE view. I figured I need to create an IList<Employee> and do something like:
<%= Html.TextBoxFor(m => m[0].Name) %>
<%= Html.TextBoxFor(m => m[0].Company) %>
<%= Html.TextBoxFor(m => m[1].Name) %>
<%= Html.TextBoxFor(m => m[1].Company) %>
If a user clicks on "Add another employee", I want the view to make another form for the new employee:
<%= Html.TextBoxFor(m => m[3].Name) %>
<%= Html.TextBoxFor(m => m[3].Company) %>
And continue to add form items (and increment the array index if they click on it again).
Keep in mind that I need to build the form and the list dynamically in the create view. I don't already have a populated list of Employees.
basically trying to make a treeview.
i can query to get my parent list and pass that into the partial view. Im running into problems when i try and make a recurisve call to the view. i cant figure out how to pass the second group back in.
I'm looking for an automated way to inventory all the links within an asp.net project that I inherited.
View 1 RepliesI need to build a custom html helper that generates Label and a tooltip Icon(based on the Display(Name = 'MyProperty', Description = 'ToMyToolTip') attribute). This is how my helper looks like so far:
[Code]....
The problem is that the label have a attribute called "for", I need to set this also but do not find the value in the metadata object? Do I have to manually create the value to the "for" attribute? And if so, how is the best way to do that?
I am trying to implement an html definition list in which each <dt> is the <header> in the accordion, and <content> is the <dd>. No matter how I write this out I can't get it to be valid markup because of the position of the <div>s inside the definition list where divs aren't allowed.
I also tried using a unordered list but had the same validation issues. I would really like to use the accordian, but not if I have to sacrifice valid semantic markup on my page.
I'm building an HTML5 application (with ASP.NET back-end) and i want to develop it in such a way that i can run it locally with all my resources (such js and css) not minified (so i can debug it easily). However when i build the final version i want merge and minify the resources. At the same time i want to create several versions of the app targeting different platforms (iPhone, iPad, desktop, etc) by adding appropriate css.
I thought that the final output should be a set of html files (so the get cached nicely). I could use ASPX and just control the output by a query string parameter, but i don't really want to have the form tag on my page.
So the questions are:
What are the pros and cons of using static html pages generated from a template versus a dynamic ASPX page? (apart from being able to run on any web server)
If ASPX approach good enough then how can i get rid of the form tag that's required by ASP.NET?
UDPATE
Another factor in favor of static html pages is the fact that the files are served instantly, whereas ASPX may take awhile to load if the app has recycled.
The back-end is ASP.NET 2.0.
I've got a database that looks like this:
ID Name ParentID
1 1 0
2 1A 1
3 1B 1
4 1C 1
5 2 0
6 2A 5
7 2B 5
8 2B1 7
9 2B2 7
10 2B3 7
ParentID points to the ID field so that ID 2 is the child of ID 1.
Unfortunately, the order of the db elements is not guaranteed but what I'd like to do is have the information displayed sort of like in windows explorer with the children directly underneath the parents.
I've done something similar in the past with nested gridviews (ugh!), but it didn't point to itself and I knew how many children (additional db tables) there would be in advance. I'm basically trying to re-create that setup but make it much more flexible by making it point to itself.
Pseudo Coding I'd do something like:
Setup the html table and table headers Go through the DB from the top and search for the row with ParentID = 0 Add that row to the table Go through the db and find the row where ParentID = ID of Step 2)Add that row to the table Recursive magic go back to 4 Keep going deeper inception style ^^ Recursive magic go back to 2
I just have no idea how to even begin doing something like this!
This has nothing to do with my problem, but so you know where I'm going with this: after I get the table/gridview setup in the correct order, I plan on using jquery to hide all the non 0 parentID rows and make the rows clickable so that the child rows expand out underneath the parent row.
I have used the Generic List , so i want to convert the List into dataset, after converting the dataset i have to export the excel in all the details,
how can i convert List to dataset , and also the Export the details.
I am developing a website using Visual Studio 2010, SQL server 2008 and WCF. Already i have developed DAL (Data Access Layer), for some of pages i want to use WCF services and Silverlight, I am new for WCF and i understand that all should be done in List<> for Silverlight and WCF. But all my methods in DAL will return the records in DATA SET format, So my ultimate aim is to convert the DATA SET into List. I browsed in internet and got many explanation like serialization , IEnumarable and so.... but i have 1000 of methods in my DAL, so for the each method i do not want DATA SET to LIST convertion. So i am thinking of having one common class the responsibility of comman class will be get the dataset and return the List [Convert DATA SET to LIST ] For example(Just Psedo explanation for undertanding, Ignore the Syntax error )
Public List< > DsTOLi(dsRecord)
{
// Here we will convert DATA SET to LIST
return liRecord;
}
How to convert list to dataset using c sharp?
View 2 RepliesI am using VS 2010, C# and Sql Server 2008.From the database, i am returing a list, which contains around 25 columns. am binding the list to the grid. After the list is binded, i am trying to create a dataset from the list. But I would like to have only 5 columns in the dataset, out of the 25 columns returned from the list. How to achieve this?This is the code I have used now:
[Code]....
I want to pass columns like, schoolid, schoolname,courseoffered,Ranking,Dateofopening from the list to the dataset .How to pass the columns from the list to create the Dataset
how to get records from database and display in datagrid w/o using dataset/datareader?my requirement is not to use Using System.Data namespace
View 5 RepliesI am using Linq To Sql to get List of objects with data from database. To bind data with a grid view i am creating a dataset explicitly and then adding List values to that explicitly created dataset.
Now my question is whether it is a good pratice to do what i am doing (in terms of resource utilization) or is there any better way to this...
I have a asp table and working dataset.How can I bind the dataset with the table.The code is here....
<asp:table id="tblcampaign" runat="server" width="100%" border="0" cellspacing="0" cellpadding="0">
<asp:TableHeaderRow ID="content_table_heading">
<asp:TableHeaderCell Width="39"><img src="Images/table_heading_bg_lft.gif" alt="" width="39" height="41" /></asp:TableHeaderCell>
<asp:TableCell width="91">Campaign ID</asp:TableCell>
<asp:TableCell width="132">Campaign Name</asp:TableCell>
<asp:TableCell width="134">Parent Campaign</asp:TableCell>
<asp:TableCell width="121">Target Segment</asp:TableCell>
<asp:TableCell width="95">Objective</asp:TableCell>.......
.cs code is here..
MCMS.DAL.Dataset.MobileCampaign mob_cam = new MCMS.DAL.Dataset.MobileCampaign();
MCMS.BL.MobileCampaignHandler obj = new MCMS.BL.MobileCampaignHandler();
mob_cam = obj.GetCampaignDetails();
I have this data:
5-16-2010, 5
5-16-2010, 3
5-16-2010, 2
5-16-2010, 4
5-15-2010, 2
5-15-2010, 5
5-15-2010, 1
5-14-2010, 3
5-14-2010, 5
I want to group by the date, these values are now in a dataset. What comes up to my mind is an array list with the following: The master array would have each date listed on the dataset above, within each row of this array I would have the list of numbers for that specific date. How do I do that in VB.NET?
how to extract DataTable or DataSet from Linq Query or List. e.g I have linq query like this
MyDBpDataContext dcSp = new MyDBpDataContext();
dcSp.myProgrammSP().ToList();
I wrote an Sp which sends a Table as result and I have code which is already using DataTable So I want to convert this result in DataTable.