I have Sql Table for Products that have ~8000 records. In my web form I want use dropdown list to edit code with dropdown list. This drop down list populate very slow. How to increase speed to populate dropdown list with large amount data.
View 1 RepliesI have a WCF method that returns a huge number of rows, causing a long wait for end user.
Also I do not have IIS7 but only IIS 6 for my WCF.
Is there any way I can speed up the WCF response so user does not wait for a longer time?
I have about 5,00,000 data. I want to display the records according to group by. It takes to me about 2 minutes. Is it good?
If not, then what is best process to display the record in a very fast way?
Moreover, I have encrypted one field in database and encryption is done from my code behind. So when I display the records, I have to decrypt those. That's why I make paging on 100 records per page.
I 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
I have a drop down list . In that list i have to show more then 3000 value comes form SQL Server database
Becasuse of huge amount of data the drop-down list preforms slowly.... is there any way so that the dropdownlist performs faster.
I have a gridview that displays query results on a reporting page for a "home-grown" CRM application. From the gridview, a link can be clicked which opens a modal window that contains an iframe linked to a "details" page where record specific info can be viewed/altered. On the details page there are 10 or so dropdownlists (ddls) that are bound every time the page is called. The ddls are bound using a method similar to the example below. I am looking for a way top speed things up a bit. The details page could be called 10-20 times in one session and every time the page loads these ddls have to be bound from the same methods but for different records. What are some options for speeding up the load time for this page??
[Code]....
[Code]....
I am facing problem with images loading time. In my form I have image server control placed in repeater control. The repeater control every time binds atleast 300 images. When we want to see all the images at a time the page is taking lot of time(atleast 3 to 4 mins) to display. But I need the page should be loaded fast.
The image url is from physical location.And the information related to image is coming from database.
I am using .net framework 3.5 and C#.net as language in asp.net web application.
I normally have a function to populate my dropdown list with the database values.
How can I populate a dropdown list so the values are stored in the web config?
The only problem is that the list would need to store two values, the text value of the combo, and the data value.
Using a gridView to read some data from a SQL database. The user can select a record in the gridview. On the SelectedIndexChanged property I populate this to a couple of text boxes & drop down list; txtCountry,ddlProvince,ddlCity.
I have special characters in France ( accent marks) and when I populate it to the drop down list it fails giving out the error message "SelectedValue which is invalid because it does not exist in the list of items".
Example of items that I try to populate are as follows. ( separated by commas) ÃŽLE-DE-FRANCE , PROVENCE-ALPES-CÔTE D'AZUR , RHÔNE-ALPES, DRÔME,ISÈRE ........ When I looked in the drop down lists for Province and Cities I see those Provinces there in the item list. When I debug line by line the word ÃŽLE-DE-FRANCE comes out like ÎLE-DE-FRANCE which is not there in the drop down list. Got to know the ÃŽ is typed by pressing down ALT+206 and lloks like this is what is coming in at the start of the string above.
populating the dropdownlist with column name. I have a gridview that has 7 columns . I want to have a textbox search and dropdownfield where user can select column name and type a word in search box and click search so that text for that column name is being search and displayed in grid. how I can fetch just column names from DB and search ?
View 1 RepliesI wanted to populate the dropdown list when selecting the edit button based on the officeid from the gridview.
My code:
<
asp:GridView
ID="gridassignserv"
runat="server"
[Code]....
I'm trying to populate a dropdown list from a list of existing SQL tables in a database. Does anyone have a code sample for doing this?
View 10 RepliesI have grid view which databind from object datasource. my problem is i want to disply dynamic dropdown list on edit template based on the id which has in grid view. but still i can't figure out a way to do this.
View 1 Replieswe 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've run into small problem, here's the thing: i've got a dropdown list (ddlist1) that i am populating from a database, that works fine. However, depending on the option selected here, i need to populate another dropdown list (ddlist2). for example, if on ddlist1 i select option 1, on ddlist 2 i should get a list of options related to option 1 from ddlist1. If i select option 2, on ddlist 2 i should get a list of options related to option 2 from ddlist 1. and so forth. this information with which ddlist needs to be filled, comed from another database. o how can i go about this? m not sure yet how to code the second ddlist.
View 4 Repliesi have 3 dropdown list box 3rd dropdown populate depending on 2nd drop down and 2nd drop down populate depnding on 1st value of drop down in asp .NET C#
View 9 Replieshow do i initaize array in just one line so that dropdown list can be populated easily.
For eg : arr={"1","2","3"} how do i do this for list items in dropdown list.
I know this method:
Dim a(1) As ListItem
I'm designing my own custom control that contains a .NET dropdownlist. What I'm wondering is if it is possible to populate my dropdownlist with listitems placed in a placeholder? For example:
<asp:DropDownList ID="ddlFilter" runat="server" >
<asp:PlaceHolder ID="ListItemPlaceholder" runat="server"/>
</asp:DropDownList>
This doesn't work because the DropDownList control only allows ListItems as child controls. But, I want to do something similar to this so when the user includes my control on a page, they can do something like this:
<mytag:MyControl Mode="DropDown" runat="server">
<ListItemTemplate>
<asp:ListItem Text="C" Value="c"></asp:ListItem>
<asp:ListItem Text="E" Value="e"></asp:ListItem>
<asp:ListItem Text="B" Value="b"></asp:ListItem>
</ListItemTemplate>
</myTag:MyControl>
I know I can do this by dynamically adding the ListItems in the page code behind, but I'd like to avoid that if possible.
If you had to get large amount data(nearly 230.000 rows) from database(I use oracle) to an excel file with asp.net, how would you do it?
View 2 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.
I have a database of about 50 tables and some of the tables have more than 9999999 records. When I try to fetch some data on some SQL statements, sometimes it takes more then 5 minutes. I would like to know if there is good searching approach to get data from that much records in many tables.
View 6 Repliesi want to to sotre large amount of character in one field of a table i use text-nvarchar(max) and but it show me this exception
(String or binary data would be truncated The statement has been terminated.) I know that text and nvarchar can store 8000 character
i have write data from db to .txt file,where db have large amount data,i need to wite data into file, if some error occure, then reInitiated that file and write data again without stop process.that is Continuous calling same process
View 2 RepliesI was looking for JQuery Grid which will help me more than 1000 - 2000 records. I mainly need search and paging . Can some tell me with its own experience
View 3 Repliesi want to show some contents out of large amount of data...and want to apply read more link so that after clicking the link all data will shows on next page..how can i show the some contents out of large data ....
View 1 Replies