I'm trying to implement a TreeView exactly like this:http://www.matthidinger.com/archive/2009/02/08/asp.net-mvc-recursive-treeview-helper.aspxThe problem is, that I'm using MySQL which doesn't support MARS (Multiple Active Result Sets).So, how would I do this, without being able to use MARS?
View 4 Replies
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?
hile i have been working with application perfomance tuning part i found an article for doing the same from Microsoft. it suggests me to reduce the round trip between application and database by using Sqlbatch statements. i got two ways to achieve it 1. SqlDataReader.NextResult() - we can use single connection to execute sql batch statements2. MARS (Multiple Active Result Sets) - we can use single connection to open multiple readers and execute the batch statements
View 2 RepliesI am using MS SQL Server 2005 and i added "" to my connection string and i still have the problem
"There is already an open DataReader associated with this Command which must be closed" ;
SqlDataReader dr2;
StrSql = " SELECT * from Modules";
cmd.Connection = conn;
cmd.CommandText = StrSql; [code]....
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
namespace amief.Models
{
public class WebsiteModels
{
public static void getPagesForPage(int pageId, dbDataContext db, List<page> myPages)
{
var pages = (from p in db.pages
where p.pageParent == pageId
select p);
foreach (var item in pages)
{
myPages.Add(item);
getPagesForPage(item.pageId, db, myPages);
}
}
}
}
calling the procudure
List<page> myPages = null;
WebsiteModels.getPagesForPage(0, db,myPages);
i'm getting an error System.NullReferenceException was unhandled by user code Message=Object reference not set to an instance of an object. on line "myPages.Add(item);" I don't understand the error...
Not sure I'm asking the right question, but it's a start. I have a user control with a ListView and, ideally, I would like to nest this same control inside of the ListView to provide recursion. This would behave somewhat like a TreeView with child nodes. This might be a monumentally bad idea. :) In fact, I feed like MSFT is pointing me in that direction, because when I try this I am told that I can't do it
View 1 RepliesI have a categories table which is set up to allow an infinite number of sub category levels. I would like to mimic the following:It should be clarified that sub categories can have sub categories. E.g. Parent cat -> level 1 -> level 2 -> level 3 etc.My categories table has two columns, CategoryName and ParentID.This list box will be used when assigning the correct category to a product.How can I write this?EditIn response to thedugas I had to modify your answer to work with my situation. I found some errors that needed to be fixed, but below is a final, working solution.
protected void Page_Load(object sender, EventArgs e)
{
using (DataClasses1DataContext db = new DataClasses1DataContext())
[code]...
I use the following method to find a control on an asp.net page recursively:
/// <summary>
/// Searches recursively for a server control with the specified id parameter.
/// </summary>[code]...
I hit a problem because it was returning the wrong control. I tracked the problem down to the standard FindControl method, and fixed it by checking that the id of the control returned did actually match the one requested like this:
foundControl = start.FindControl(id);
if (foundControl != null && foundControl.ID == id)
return foundControl;
My question is why does start.FindControl(id) ever return a control that does not match the id requested?
When developing a rather complex web application that has to be localizable, it can be quite a dawnting task to make even the smallest change like changing a name for an abstract object type.To illustrate the problem, let's assume the user can create objects through our web application called a "FooBar". The web application most probably have numerous resource strings making reference to the object type "FooBar", for example, "Click here to create a new FooBar", or "Delete all the selected FooBars".During or even after the development life cycle of the web application, the owners decide that "FooBar" is not an appropriate name, and would like it to be renamed to "Thingamajic". In the web application there are thousands of references to "FooBar". Now one has to find all and replace them.
View 1 RepliesI'm looking for a good way to prevent the scenario of the page calling itself repeatedly.
I have a page, that to be rendered needs to make an HTTP request to an RSS feed. If the URL to that RSS feed happens to be the current page, it will fire off a request to itself. The new request would start off another request to the page, which would start another request... This continues until the site grinds to a halt when all available connections are busy in this recursive loop.
A few notes:
The URL to the RSS is entered by the user.
This is a page in a CMS, the URL of the page could be almost anything and could change after the RSS URL is entered.
In this case, the user entered a URL to a remote server that lead to a redirect back to the page.
A few ideas:
I could just deny all requests from the localhost IP before rendering.
Before sending the request, I could track in a common location which requests are active and not even send it if it's already in the middle of another request to the same address.
Maybe add a custom user-agent to the request header and deny the request if that user agent is seen?
I am using "Classified Ad" starter kit of Asp.net 2.0. In the Post Ad feature that using the ad "CategoryPath" control that recursively update link based on user select ad category. After user satisfied with the ad Category selection, the control generate a complete button link of the entire path.
If I am going to convert CategoryPath control from Asp.net to MVC / Ajax, how about I am going to do this?
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 am writing a program to crawl the websites. The crawl function is a recursive one and may consume more time to complete, So I used Multi Threading to perform the crawl for multiple websites. What exactly I need is, after completion crawling one website it call next one (which should be in Queqe) instead multiple websites crawling at a time.I am using C# and ASP.NET.
View 4 RepliesI added a new link to a master page on my website. Immediately after saving, I started getting this error:
Recursive fallback not allowed for character u003F. Parameter name: chars
I remove the new link and I still continue to get the error.
You can see this for yourself here:
[URL]
I am using a CustomSiteMapProvider to draw the SiteMap from a MS SQL database table. If I select all the rows in the SiteMap, everything works correctly. I now want to select a subsite from the SiteMap and display it and this subsite's subsites only. I am using recursive SQL to do this. The code below works correctly except the root record, record number 286, is not included in the result:
[Code]....
How do I include the root record, record ID 286, in the result?
I have created a server control which uses recursion to create a menu. It essentially outputs nested lists with anchors inside them.
Now, this works perfectly, however, since the control is calling itself to render the child menus, it is also rendering multiple identical WebResource.axd javascript file references in .
how to stop this from happening? I just want the one reference in my tag.
Periodically a rash of occurrences of the following error happen. I believe they're the result of hack attempts. Whether that's the case or not, my question is how can I handle the error? I want to avoid unhandled exceptions. The TreeView control is just
a standard .Net TreeView control, not a custom one. If you suggest a code solution, please code it in VB.Net as that's what I'm using.
Message: Input string was not in a correct format.
Stack Trace:
at System.Number.StringToNumber(String str, NumberStyles options, NumberBuffer& number, NumberFormatInfo info, Boolean parseDecimal)
at System.Number.ParseInt32(String s, NumberStyles style, NumberFormatInfo info)
at System.Web.UI.WebControls.TreeView.LoadPostData(String postDataKey, NameValueCollection postCollection)
at System.Web.UI.WebControls.TreeView.System.Web.UI.IPostBackDataHandler.LoadPostData(String postDataKey, NameValueCollection postCollection)
at System.Web.UI.Page.ProcessPostData(NameValueCollection postData, Boolean fBeforeLoad)
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
how to write Css for asp.net treeview by applying color and theme like (msdn website treeview)?
View 1 RepliesI have a treeview which will be generated dynamically which need to be displayed on left side and when user clicks on a node it need to open a page on the right side of the same page. and each node has different aspx page. so whenever user selects a node the page details should be displayed on the right side .we can use an iframe on the page which will display the different pages clicked on the node.Is there any alternative i can use to display different pages based on the user selection on the right side without using iframe.
View 5 RepliesCode to drag and drop a TreeNode to another control or tag such as Div or even another TreeView.
View 1 Replieshow can i use cursor in this function ?
ALTER FUNCTION [dbo].[GetCatIDChilds]
(
@CatID [code].....
i want to develop a data access layer ,it can support multiple database like oracle ,Mssqlserver and Mysql using enterprise library and C#.net 3.5 based on database connection
View 1 RepliesI have a web site which uses one SQL database but the hosting company is very slow sometimes and I got database timeout, login and similar errors. Can I implement my code to use two databases simultaneously? I have stored procedures and the data is updated periodically.
EDIT:
Simply: When dbDefault is down and inaccessible I need to use dbSecondary so the web app keeps running. Ant these two databases must be always same.
EDIT:
Some errors:
A transport-level error has occurred when sending the request to the server. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.)A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached.Cannot open database "db" requested by the login. The login failed. Login failed for user 'root'.
im using treeview in asp.net
treeview like
*parent
@child1
.child2
*parent
.child
if i click child2 after postback the alignment which is in above should not change
but parent1 should be collapsed if i click child then parent node should be collapsed
im using thi following code
protected void Page_Load(object sender, EventArgs e)
{
if (Session["tvExpandNode1"] != null)
{
TreeView1.FindNode(Session["tvExpandNode1"].ToString()).Expand();
}.........
its just not working properly...
I have a treeview that i fill from a database, when i add a new row to a database, the treeview is not updating.Even the reload of an internet explorer doesn't help, It does updates only after i press stop debugging button and turn it on again.Here is the code:
[Code]....
[Code]....
