|
Thanks a lot...it really helped...[SOLVED]
|
|
|
|
|
Excellent. Glad it helped.
|
|
|
|
|
Hey guys I'm doing Computer Science(hons) with Catholic University nd i'm now in fourth year.I'm doing a VB.Net project of development a fast and robust Internet Browser.I've developed part of the program but will need to see another one with the code for me to make modifications and refinements to the one I got..
topodzie
|
|
|
|
|
A good step would be to start contributing to the Firefox[^] development.
|
|
|
|
|
So what are you asking?
BTW: I didn't attend a Catholic University but did learn how to spell and use proper grammar and punctuation.
topodzie wrote: VB.Net project of development a fast and robust
That's the best oxymoron I've heard in a while.
Failure is not an option; it's the default selection.
|
|
|
|
|
sorry sir but english is not my fist language,I'm rily sorry
|
|
|
|
|
Do a search on the internet. You should be able to find something.
|
|
|
|
|
Well, you could always down the XulRunner or Webkit sources and have a look at those. Mind you, they aren't running on top of the .NET framework - as much as I love coding with it, I wouldn't choose it to create a web browser with.
|
|
|
|
|
topodzie wrote: Hey guys I'm doing Computer Science(hons) with Catholic University nd i'm now in fourth year
Gratz on surviving that far.
topodzie wrote: I'm doing a VB.Net project of development a fast and robust Internet Browser.I've developed part of the program but will need to see another one with the code for me to make modifications and refinements to the one I got..
Did you create a browser (something that parses the html before displaying it) or did you re-use the browser-control, effectively writing a new UI?
Bastard Programmer from Hell
|
|
|
|
|
I started with a new User Interface
|
|
|
|
|
..and you're looking for similar projects, like this one[^]?
Bastard Programmer from Hell
|
|
|
|
|
|
The thing I miss most in my current browser is the option to browse in "Lynx mode", where the browser only displays the text and skips every bit of java/flash/distracting animation. I'm using a bookmarklet that "strips" all this crap from the site that I'm currently browsing, but it'd be cool to have a browser that would do it by default
Bastard Programmer from Hell
|
|
|
|
|
Lynx Browswer is available and browses in text mode.Because Lynx does not support graphics, web bugs that track user information are not fetched; therefore, web pages can be read without the privacy concerns of graphic web browsers.[4] Still Lynx does support HTTP cookies,[2] which can also be used to track user information. to download Lynx Browser 2.8.4 follow http://mac.softpedia.com/dyn-postdownload.php?p=7825&t=0&i=1[^]
|
|
|
|
|
I am using a DataGridView control to display very wide tables; number of columns approx 1,000. When the table get wide an error is generated when assigning the .datasource on the DataGridView. The error is the following: "Sum of the columns' FillWeight values cannot exceed 65535."
I have done a little research and it appears that MS never designed DataGridView to show tables that are very wide. They recommend < 300 columns and I saw somewhere that you could adjust some of the parameters on the columns to increase that number up to 655. I need more than that and would prefer to not implement a "paging" solution.
Can anyone help with a proposed solution? How does Excel display very wide tables of data?
I'm using .net 4.0 and vb.net but a C# solution would be fine.
Thanks in advance !
UPDATE: posted a solution at the end of this thread !
modified 7-Mar-12 16:11pm.
|
|
|
|
|
I suspect some of the DGV internals is still working with 16-bit quantities, maybe all the coordinates are short.
I'm not very optimistic you'll get it to work, however I would try and dumb it down, e.g. by disabling the autoformatting (set DataGridViewAutoSizeColumnsMode.None and give each column a fixed width before providing the data).
|
|
|
|
|
By the way, also Excel is very limited in the number of columns (255? 512?), though the number of rows can be a few thousand (65535?).
Can you locate the position of the problem more closely: is it the mere number of columns which causes the problem, or the width of all the columns together? In the latter case, you could implement a workaround by temporarily setting a very small column width for the columns out of view.
|
|
|
|
|
Thanks, I will look for that (is it # rows or size of displayed data). What I am doing is detecting when the # Cols is > 255 and then not attaching the DataSource. Essentially, if there is going to be a problem I disable viewing of the data; at least the program can continue to run.
Setting a very small column width for those out of view might work if it is the size of the data and not the #columns. Although, if the # cols is > 1,000 I believe there still might be a problem.
I was really looking for some kind of work around. Like a different data structure. Or maybe something derived from DataGrid or DataGridView which disables are lot of the fancy feature and just displays rows & cols.
Thanks for the answer though.
|
|
|
|
|
TPIRick wrote: How does Excel display very wide tables of data?
Excel uses a custom written rendering engine. Since you seem to want to show a huge number of columns to the user (as a user I wouldn't want to scroll through it!) you have exceeded the design goals of the DataGridView. You would have to either find a grid control that supports your requirements (not likely) or create your own custom drawn data grid (not easy).
|
|
|
|
|
TPIRick wrote:
Can anyone help with a proposed solution? How does Excel display very wide tables of data?
Have you ever had to find something in Excel when it's crammed with that amount of data? Once the user needs to scroll, he can also use a button to browse the next page.
You could virtualize the entire thing, drawing a grid and scrolling it's data - not the grid itself.
Bastard Programmer from Hell
|
|
|
|
|
TPIRick wrote: Can anyone help with a proposed solution?
No one looks at that much data. Either they are looking for something in it or they want to manipulate it to do something else. First one means you ask the user what they want and only give them that. Second solution involves allowing the user to download the raw data (then they figure out how to manipulate it) or provide a way to manipulate it before presenting it to them.
|
|
|
|
|
Out of curiosity I performed a little experiment, with the following code inside the Form's Load handler (dgv is a DataGridView):
1 for (i=0; i<10000; i++) {
2 DataGridViewColumn col=new DataGridViewTextBoxColumn();
3 if (i==0) {
4 log("col.Width="+col.Width);
5 log("col.FillWeight="+col.FillWeight);
6 }
7 col.Name=i.ToString();
8
9 dgv.Columns.Add(col);
10 }
As is, it fails when i=655 with the Exception you've got, because the default FillWeight value is 100, and it somehow gets summed in an unsigned short which then overflows.
With line 8 uncommented, it runs fine. That is, if you have half an hour to spare, waiting for the DGV to get loaded with (empty) columns. After the long wait, the Form and the DGV appear, with column headers, scrollbars, and everything (except for rows and actual data, as I didn't provide any).
The conclusion can only be:
1. a DGV wasn't meant to hold that many columns;
2. your app needs another way to interact with your user.
|
|
|
|
|
Thought I would post my workaround in case it helps others.
Once the data is in a datatable I did a check on the number of columns and if it was very large then I disabled the datagridview to disable viewing. I then added code to allow the user to view the data via HTML. I created a humongo string which was an HTML representation of the data in the datatable. Nothing fancy just kept appending to the same StringBuilder object. Started with html cmds to set up the table then looped thru #rows, #columns spitting out tr, /tr, td, /td cmds with the cell contents in the middle. I then used a StreamWriter to write the humongo string to a file. I then added a button to allow the user to view the file that was created using the default browser. Button invocation calls "Process.Start(htmlFileCreated)".
I tried Firefox and IE 8/9 and was able to view the table even though it was 750 columns wide. Hope this helps someone.
Regards,
Rick
|
|
|
|
|
Hi all,
I have a scenario that is puzzling me and I'm guessing at the behavior and was wondering if anyone else knew what was happening under the skin of .Net.
I have a .Net 4.0 application on a clients' Windows Server 2008 64bit back end database is an ALPHA (not relevant).
The application is 1 form with literally hundreds of controls on it and also an image viewer. It's takes up quite a bit of screen space, and has multiple tabs (at least 8) to hold all the controls.
The puzzling scenario is this:
1. Open up a simple list
2. Select an item from the list to open up the form as described above - this takes over 1min 15secs
2. Close the form (return to list in point 1)
3. Open up the same form from the list loading the controls in exactly the same way with the same queries behind it (assuming not relevant from the logs I've looked at), and it can open in 10 seconds flat.
From the looks of the memory print in Task Manager, the memory obviously shoots up when the form is first opened, but doesn't go down too far after closing the form. On reopening the form again, the memory doesn't go up much but only takes 10 seconds to open.
I'm thinking that .Net is loading up a load of stuff (!for want of a better word!) into memory on first load of form, and subsequent forms use what has previously been loaded into memory.
If it's not this that is happening, I'm not sure what is happening, as I have been asked by our client to try and make the first load of the form as quick as each subsequent one, and not sure if this is indeed possible.
Any light shed on this would be most appreciated.
Many thanks
Julian
|
|
|
|
|
My initial thought here, as you haven't said what database you are hitting, is that the database connection is being pooled. On the first invocation, the connection is being created which is a time consuming process. Further invocations are able to take the pooled database connection.
You are also correct that the .NET runtime will also grab extra memory which is not released immediately, allowing space for the application to load the form in again.
|
|
|
|