when i did not have too many controls on the gridview, it was displaying fine. but when i added more controls, it has become very slow and displays a large size for a second or so, and then comes to normal size.
View 1 Replies
how to display large amount of data in griedview with serach funcationality.(the data should be 20 L)with example in asp.net.
View 1 RepliesI am trying to show a large amount of data in gridview but the problem is that everytime data increase the gridview row size increase automatically.
is there any possible way that the data which is stored in my MS access Database display in multi line instead of one single long line.
we have a classic ASP Webpage for displaying reporting data.
The process is following:
user inputs reporting criteria reporting criteria are passed to a method in a VB6 DLL containing the reporting business logic (generating a dynmic sql statement) VB6 DLL method returns xml data xml data are displayed with xsd transformation 150.000 datarows are displayed in some seconds (less than 10 seconds maybe) Now we want to extend this reporting function and decided to use asp.net (2.0) So I have written a little prototyp application with a SqlDataSource Object and a GridView Control.
A table with less data (about 100 or so) are displayed quickly.
But a view with about 150.000 datarows needs about 2 minutes and ended with a OutOfMemoryException!
The request of the customer is definitvely to display the data on one page like in the old classic asp application!
I have a DTS script which transforms a Tab delimited text file to a table. I get the following error when trying to transform the data of a field that is greater than 255 chars:
[Code]....
I have seen this issue with importing from Excel with the jet 4.0 engine, however I am importing a text file.
I have problem in my asp.net application. I have some file in floder (PDF, .doc, ,txt ) i want to open these files in my web browser .
Now my problem is large PDF files are not opeing in my browser even some less size pdf files are opeing prefectly and other files are also working good.
The following code i have wriiten to open the file
[Code]....
How to resize large size image like 3-4 mb of size to small size like 800px X 600px so that sie got reduce while uploading in asp.net ....
View 1 RepliesI have a gridview that is currently showing 20 lines per page. Each line has several fields in it, three of which are dropdownlists. These dropdownlists are populated with a SQLDataSource and then the selected value is bound to one of the gridview datalements.
The problem I'm running into is that the page is very slow to load. I believe this is because of the large dropdownlists (and possibly because there are roughly 60 of them, each of which is executing a SQL query to populate the list of available values). The file size that is being transmitted over the web is just over 1.25MB in size, again from the large amounts of data in the dropdownlists.
Is anyone aware of a technique by which I could only execute the query from the SQLDataSources that populate the dropdownlists' available values once and then reuse the results of that query to populate the relevant dropdowns? Ideally I would do this on the client side so it would also limit the amount of text being transmitted to the client browser.
With reference to the following thread: URL....I have problem applying the same concept to gridview EditItemTemplate. Is there a way i can add comma to large numbers and display it in currency format like exemple below:
Textbox3=Textbox1 * Textbox2
Textbox3= 1,000.00
Textbox3 should happen OnTextChanged and the above controls are in Gridview edit mode.
1. I want to know that if want to display 100 rows in Ui page so which is best method of display of data Bcz i want to fast the display of data..
2. how to fast the executaion time in stored procedure..
ASP.NET 3.5,I'm upgrading a page that currently uses classic asp and xslt to display about 2000 readonly tabular records. Please leave aside the issue of whether this is a good idea or not.My asp.net replacement page uses a gridview to do the same thing.The scrolling in IE8 using this old code is very smooth and even. The scrolling using the asp.net page is horribly jerky. I can't figure out why - there doesn't appear to be much client side code running.Any clues welcome as this is a high traffic page that I want to look as good as possible.The same page also can't handle a row highlighter - same reason slow and jerky.
View 2 RepliesI have a very large text file whose data I need to extract and display in a gridview control. The method I'm using now is as follow:
1. Read each line of the textfile using StreamReader, into a String.
2. Split the String and populate the fields of a detail object.
3. Add the detail object to a List.
4. Repeat steps 1 to 3 for each row of the text file.
5. Bind the list to the gridview.
I think most of the time is spent processing the text file data (steps 1, 2 & 3).
Is there any way this can be done quicker and more efficiently? At present, it takes ages to read and process a 76 mb text file.
I want to set specific width size of a column inside grid view i tryed following things butit did not work:
I tryed through css through C# and to set properties for gridview like itemstyle/itemcontrol width = 150px
I am using a gridview that contains an asp:fileupload so that when the user clicks 'edit' they can upload a pdf. I need to validate the size of the file, it needs to be less then a certain size. I tried to use a custom validator, but it never get called when the user updates. How can I validate the file size on edit in the gridview?
View 1 Repliesthis is my Gridview style
asp:GridView ID="gvAmount" runat="server" AutoGenerateColumns="False"
CellPadding="3"
DataKeyNames = "id"[code]....
here im binding more than 20 records to this gridview. at one situation Title will come alone without any other data, at that time i would like to show the title in a single line so i have increased the Title (first column) width but that size would be set to all the rows, so without affecting other row columns width how to increase that Title size alone.
I've already searched to no avail for an answer to this question:is it possible to dynamically alter the page size in a paged gridview based on data in a particular column?In other words,let's say I get data from a table that lists students enrolled in a particular course.If there are 10 students in Course "A," then I want page 1 in my gridview to show 10 records.
If there are 15 students in Course "B," then I want page 2 in my gridview to show those 15 records,and so on.I imagine that this could probably be done with a master-detail kind of set up,but let's say for the sake of argument that I don't want to go that route.
when a user enters edit mode of my gridview, the girdview becomes huge. How can I make it so my gridview stays relatively close to the size it is when it is not in gridview?
View 1 RepliesI have gridview like this.
[Code]....
is index was out of range must be non negative and less than the size of the collection
How do you set the font size for all GridView textboxes in Edit mode other than templating each. I have the font size for the GridView set <asp:GridView
ID="GridView1"
....... "x-small" but when I call the Edit mode the font defaults to medium.
I have 65 columns in the grid, if the columns are reduced to 20 then the speed when accessing from client is more or less similar to that accessing from web browser. Does it mean that all this performance issue is due to the data only ???
View 1 RepliesIs there such a thing as an optimum chunk size for processing large files? I have an upload service (WCF) which is used to accept file uploads ranging from several hundred megabytes.
I've experimented with 4KB, 8KB through to 1MB chunk sizes. Bigger chunk sizes is good for performance (faster processing) but it comes at the cost of memory.
So, is there way to work out the optimum chunk size at the moment of uploading files. How would one go about doing such calculations? Would it be a combination of available memory and the client, CPU and network bandwidth which determines the optimum size?
EDIT: Probably should mention that the client app will be in silverlight.
In my database m having 1000 record and I want to display 10 record on each page on gridview so every time it fetch 1000 record so while page loading it is quite time consuming ..
View 1 RepliesI want to bind large amount of data in gridview using jquery but without paging.
I am taking reference from this post
[URL]
But when there is large amount of data, it's not working
My admin set innodb_buffer_pool_size=512M, innodb_log_file_size=128M, and innodb_log_buffer_size=1M although in mysql query show global variables its showing what the value is set. When i restart my system also its showing what we set the data.(It means we set log file buffer file size to max and its working fine.) but when i try to upload a file of 58 mb again its throwing error as The size of BLOB/TEXT data inserted in one transaction is greater than 10% of redo log size.
View 1 RepliesWhen the user selects the list of files from a page and hit's download selected, then a post back happens to server and starts zipping on the server. This works great until we hit the timeout on the page ( which is default to 90 seconds ) and just returns the process to the page even though the backend process is still zipping. Is it possible to show the size of zip file when the file is being zipped instead of waiting till the end to provide the download link?
View 1 Replies
