Efficiently Loading Sitemap From Database?
Jan 13, 2010
i have a custom SiteMapProvider which I populate from a database. I also have a custom SiteMapNode which has to be constructed with a custom Page argument.[code]Should I return false in AuthorizeCore() to have everything work according to default authorization protocols? (What are these?) Or should I throw my exception.SiteMap.CurrentNode is Null / Nothing (in AuthorizeCore()) if the page which is requested is not accessible to the user (obviously). How should I change my implementation? I want to keep the functionality that the Page objects are only loaded once, so I need to store them somewhere.
View 1 Replies
ADVERTISEMENT
Jun 21, 2010
I'm attempting to create and populate a table in a new Microsoft Access (Jet) database using VB.Net 2008 Express under Windows XP Pro SP3. The database and table are being created properly, but loading the table proceeds VERY slowly. When I am loading the table, no complicating factors that might impact performance, such as indexes or table relationships have been defined. The table to be loaded is made up of relatively short rows consisting of three single byte columns, and one (four byte) integer column. I am loading approximately 16 million rows, and this is literally taking hours, while the same data can be interactively imported into Microsoft Access from a .csv file in minutes. I am trying to batch load the rows, 64K rows at a time, in order to avoid the overhead of individually transacting/committing each row individually, but suspect that I must not be doing something right. Key code that I am using for this process is provided below.
[Code]...
View 3 Replies
Jun 20, 2010
Is there any way to have the program still run efficiently when connecting to an mysql database? Would System.Windows.Forms.Application.DoEvents() work anywhere?I have it connecting every 3 seconds on a timer and during that connection the program locks for a second.
View 2 Replies
Apr 7, 2011
I am having an issue with the sitemap control, I have added the hierarchical levels within the web.sitemap file and added the sitemap control to the various masterpages. I have however two homepages which can be viewed depending on the user of the system.
Is there any way to define two sitemap structures within this web.sitemap file or can I just create another sitemap file?
View 1 Replies
Feb 21, 2012
I have been trying to open the following XML file in VB.NET using the Linq library.
<?xml version="1.0" encoding="UTF-8"?>
<?xml-stylesheet type="text/xsl" href="http://wegotflash.com/sitemap.xsl"?>
<urlset xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.sitemaps.org/schemas/sitemap/0.9
[code]....
The code that I'm using works with normal XML files, but whenever I add the xmlns="http://www.sitemaps.org/schemas/sitemap/0.9" attribute to the root node, nothing is getting returned by the application. Here is the VB.NET code that is reading the XML file:
Dim XMLFile As XDocument = XDocument.Load(TextBox1.Text)
For Each url As XElement In XMLFile.Descendants("url")
[code]....
View 1 Replies
Mar 5, 2011
I am using asp.net sitemap with the in-built asp.net menu but this is very 'dull'. I want to apply CSS and jQuery to give it a better visual look and feel. I have read various articles based on [URL]
Is there any examples or tutorials similar to this which are FREE?
View 2 Replies
Nov 9, 2009
System.NullReferenceException: Object reference not set to an instance of an object. Making the Sitemap.CurrentNode work in my code is oddly a problem. I haven't figured out how to list code on STOF yet. so here is the code that will easily be displayed. [Code]
View 2 Replies
Jan 30, 2011
On our site, we have our sitemap in this order:
SiteName > SelectedProject > Path > To > Page
Where SiteName takes you to the very root page which is primarily to select a project and SelectedProject takes you to the project's homepage.Currently, in the Web.sitemap file, SelectedProject has a static name. How can I rename it to the name of the selected project, which can be obtained from Session("PRJ")? I'd strongly prefer any code behind to be given in VB.NET, not C#.
View 1 Replies
Aug 20, 2009
I have a dynamic website that shows articles. Any article can have sub articles and sub articles can have sub articles etc. I have wrote a routine that recursively goes through the data creating a new sitemap xml file. My problem is this:-
Art1
SubArt1a
SubArt1aa
[code].....
View 7 Replies
Jan 12, 2010
i created the following ActionFilterAttribute to check if a user is granted access to a page. I also created two custom Exceptions to handle different scenarios: NotLoggedInException and InsufficientPrivilegeException.
[Code]...
Where do I catch the exceptions to for instance redirect users if not authorized?Should I perhaps use the SiteMap authorization somewhere else instead of using the ActionFilterAttribute and throwing Exceptions..?
note: as you can see I'm using a custom class for BLL.Page. This is a ORM page which has Role based security stored in the database. SiteMap is also populated based on this data
View 1 Replies
Jun 23, 2009
I'm trying to make a menu based off of an asp.net sitemap. How do you nest the sitemap nodes so that they all appear on the same level. Here is what I have:
<siteMap xmlns="[URL]" >
<siteMapNode>
<siteMapNode url="~/Default.aspx" title="Home" description="link to Home" />
<siteMapNode url="~/about.aspx" title="About" description="abot" />
</siteMapNode></siteMap>
Here is what the code for the Menu control looks like:
<asp:Menu ID="Menu1" runat="server" BackColor="#E3EAEB"
DataSourceID="SiteMapDataSource1"
</asp:Menu>
They both appear as 2nd tier elements underneath an arrow.
View 1 Replies
Jul 24, 2011
I neeed to create a dictionary that holds objects with a large requirement in memory. Therefore i need to make them a weak reference.I created a dictionary with an ID and a weekerence that holds my object.The annoing thins is that as soon as i finished filling up my dictionary the garbage collector has already reclaimed all of them despite there is a large quantity of RAM avaible and I did not call the gc.collect.
View 2 Replies
Nov 30, 2010
What is an easy to implement way to communicate between 2 vb.net (3.5) form applications that are running on the same machine?
The current problem is that in each program a user needs to be logged into to use. If the user is logged into one, and clicks a button to launch another, it should pass who is logged in so they do not need to log in again in the second program.
View 2 Replies
May 23, 2011
I have 20 PictureBoxes named PictureBox2 through to PictureBox 21, where I need to conditionally set the positon of them. I was wondering if there is a more efficient way to set their positions than to copy the code out 20 times. This is what I have so far:
For NextPos As Integer = 2 To 21
Select Case Direction
Case 1
[code]....
View 4 Replies
Jan 5, 2011
It seems to work fine for a small text file but when I use files larger than 100MB it does not give me an accurate count.The program is pretty simple. It should return the number of occurences of a substring from within a text file. I look for a match to the first character of the substring and if found then my code should test to see if the whole substring exists.I have run several tests but for some reason I am not getting an accurate result. I used the windowsupdate.log file. My code trturned 34596 hits but when I used MS Word to find the number of occurences it returned 50096 [code]
View 3 Replies
Jul 7, 2009
i need to use my gridview by using only the keyboard.My clients prefer keyboard rather than using mouse. How can i use my gridview like that?What all events should i use?
View 1 Replies
Dec 16, 2009
I'm making a program as part of a college assignment that requires my to add up the contents of an array. Now the array has 20 places, and the only method I know of atm is:a + b + c + d + e etc...They are all different numbers so I can't just do a * 20, I need a more code efficient way of adding all these numbers up, is this possible?
View 10 Replies
Jul 25, 2009
I need to draw 100 lines between 100 semi-random points in a 800x800 pixel square on the screen.
I've been using the built-in drawlines & drawrecangles functions inside of .NET, but my drawing gets erased everytime the form paints.
So, I've been thinking about perhaps drawing to an in-memory bitmap, but I'm not sure if that's a good solution.
View 5 Replies
Sep 12, 2010
I am writing a small tool that identifies digital scielence in non compressed PCM WAV files. Its purpose will be to scan files approximately 1 hour long, containing mostly scilence and spltting the periods of non scilence into files and discarding any digital silence which is encoded as null bytes.I am wondering what the most efficient way of scanning the files is. I am able to derive the number of bytes for each second from the file header (in my case 16000) so am considering reading into a buffer of this size then scanning byte for byte, if I identify a non-null byte I will start siphoning the data off to another file.My issue is with scanning large expanses of digital silence which could be many megabytes of data which would require examining each byte to determine wether or not its digital silence. Surely there is a more efficient way of skipping them as I am not interested in them.
View 7 Replies
Mar 3, 2009
What is an efficient way (must be performed in a loop quite often) for getting the difference between two timestamps that come in form of DateTime-variables?
View 1 Replies
Feb 23, 2009
I've been trying to improve the efficiency of my giant program and I know that using a textbox to deal with a string is terribly inefficient.
Function CollectionSplit(ByVal TheString As String, ByVal TheSeperator As String)
Dim tb As New TextBox
tb.Text = TheString.Replace(TheSeperator, Environment.NewLine)
Dim returnable As New Collection
For Each x As String In tb.Lines
If Not x.Length = 0 Then returnable.Add(x)
Next
Return returnable
End Function
What it does is convert a string of "1,2,3" into a collection of the 3 separate items for use later on.
View 1 Replies
Nov 19, 2011
Basically I want to store an integer efficiently. At the moment I'm using Button1 Click' Or whatever I need it for Label1.text+0 But to do this I need to add in another Label and set it to visible.
View 6 Replies
Sep 19, 2011
having trouble understanding databases in visual 2010.
I have a database, which is loaded into a table adapter when the form loads. I want to assign each column of the table adapter into an array
View 6 Replies
Oct 17, 2011
I am developing a windows application.In that I am loading Menu dynamically from database.And on MenuItem_Click event I am opening the forms with respect to the clicked menu.For this I have a code as
Select case MenuId
case "1"
form1.show[code]....
Now What I want is: I want to save respective forms for the menu also in the database so that i dont have to write select case. so on MenuItem_Click event my should look like
form(value from database associated with clicked Menu Item).show
View 13 Replies
Jul 26, 2010
In VBA / VB.NET you can assign Excel range values to an array for faster access / manipulation. Is there a way to efficiently assign other cell properties (e.g., top, left, width, height) to an array? I.e., I'd like to do something like: Dim cellTops As Variant : cellTops = Application.ActiveSheet.UsedRange.Top..The code is part of a routine to programmatically check whether an image overlaps cells that are used in a workbook. My current method of iterating over the cells in the UsedRange is slow since it requires repeatedly polling for the top / left / width / height of the cells.I'm going to go ahead an accept Doug's answer as it does indeed work faster than naive iteration. In the end, I found that a non-naive iteration works faster for my purposes of detecting controls that overlap content-filled cells. The steps are basically:
(1) Find the interesting set of rows in the used range by looking at the tops and heights of the first cell in each row (my understanding is that all the cells in the row must have the same top and height, but not left and width)
(2) Iterate over the cells in the interesting rows and perform overlap detection using only the left and right positions of the cells.[code]
View 2 Replies
Jun 11, 2012
I'm attempting to make a generic query executer function. I want to be able to send it a query string and have it return a two-dimensional array containing the results. Below is my code for how to do it with a (9,x) array. How can I do it with an (y,x) sized array? Also, I feel like there must be a more efficient way to do this..
[Code]...
View 3 Replies
Apr 28, 2009
im trying to load a database and I get this error.
View 3 Replies
May 8, 2011
i have access database connected to application.. i have a table in database called "clanovi" (members) and first column items loaded to combobox their name and surname..now..when i select one of them from combo box i need all their other info loaded into several text boxes..adress,email etc..all of that info is in the same table ..i need some example code too .
View 6 Replies
Sep 13, 2010
I'm thinking about using the treeview for creating a phonelist. The issue here is that I can't think how to load the data into the nodes according the group they are categorized in.
Here's a screenshot of my test_database:
So there is an ID and a row with groups (groep). What I want is that when loading the data a DISTINCT node gets create for each group and that the person is added to the sub-node. Got the faintest idea where to start.
View 17 Replies
Mar 11, 2009
how to load the contents of an Access Database table into a Dataset? The Access Database consists of multiple tables with different data table names but all tables has same row header and same data type.
View 2 Replies
