I am having nearly more than 80 thousand records and i need to export in .csv format.
I need to export to woksheet.
I need to export nearly 65 thousands of records in one sheet,
When it reached the limit, it should exported in the next sheet.
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 follow the following link for add dropdownlist in gridview.Adding Dynamic Rows in GridView with DropDownLists in ASP.Net..In this template field the drop down list contain 500 items how can i search the paticular item
View 1 RepliesI have a user control that is common to the application. It searchs for lakhs of Items in one go from the db and I set the selected Items in a list in a session to pass on to the pages that use it. Hence making the application a tad slower. The gridview that contains the Items should have sorting, page indexing. What according to u,I should do to enhance the application's performance ?
View 1 RepliesI want to insert a large amount( approx 7000 records) of data into a table, My scenarios is that i need to check whether the record already exists then it will not insert it. Currently i am using a stored procedure for this which gets called for each record.
IF EXISTS(SELECT 'True' FROM MYTABLE WHERE ID = @ID)
BEGIN
--This means it exists, return it to ASP and tell us
SELECT 'This record already exists!'
END
ELSE
BEGIN
--This means the record isn't in there already, let's go ahead and add it
SELECT 'Record Added'
IF EXISTS(SELECT 'True' FROM [Aadil].[dbo].[SharePointSitesData] WHERE ID <> @ID)
I have an ASP.net VB Web app I'm working on that has a requirement to provide a list of all our component part numbers to our engineers for selection into a custom Bill of Materials for reworking of an assembly. The list of part numbers is currently generated from a stored proc in our MRP systems/SQL database. The number of records being generated is slightly over 39K part numbers.
Although the SP only takes a few seconds to generate the data the web page is taking a couple of minutes to load, primarily because of the time to fill the control presenting the records to the engineers. I've bound the data to a combobox control to the engineer. They want to be able to type the first few characters of the part number if they know it and have the list filtered or be able to just scroll the data to find the part they are looking for.
I've read elsewhere that they may be a way to only populate a certain quantity of records rather than all 39K then filter based on the users actions. Unfortunately the discussions about doing this didn't provide any examples, references, etc.
My questions are these...
Is there a better way to handle this quantity of records than a stored proc and combobox? A
ny examples of a method to populate a certain number of records then filter based on user action?
i have this code in Page_Load()
[Code]....i use this code for export in word format,it work fine, but if i put inside my page a label or a gridview who shows large quantity of data word could not open the document.he says only that there are probably an error inside!
i want datalist to show only 6-8items ,as these datalist is connected to datasource which has more than 20 items..
like in facebook,we have lots of friends but in friend box only 6 friends is shown and when we click that we go to next page which display all list of friends...
I have a datagrid in aspx page.Inside of datagrid i am using around 15 controls such as Button,dropdownlist and text box
controls.Once the datagrid binds then the events in the aspx page not firing.Issue occured when the number of rows greater than 500.The number of rows less then its works fine.
"Platform i am working on ASP.NET1.1"
I have developed one simple application in that i am using mysql database. but my database size more thatn 4,50,0000, as well as ecah and every second my database is updated i.e record ll be added to the table how can i get the details for one single click.
View 1 RepliesI 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 Replies1. 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..
I have a report which is created using a .rdlc. And populated using a List object. The report when exported to excel has a problem. The numeric colums show up as text and the tooltip in excel says "The number in this cell is formatted as text or preceded by an apostrophe". How can I get the number to show up as numeric?
View 1 RepliesI am having some issues with the performance. I am binding a Gridview with around 200 records and it is taking a long time. At one time I only display 10 records on the page, but I bind all the 200 records.
Generally what is the number of records that should be bound to a gridview ?
I am trying to add a label in my gridview that counts the number of records that are being displayed as well as the total number of records found via the datasource. and i want this label to be displayed in the pager template of the gridview i.e. at the bottom.
I have the following code:
[Code]....
which i run in the rowdatabound method of the gridview. but when i run it it comes up with an error saying "null reference exception handles by code".i think the error lies in not being able to count the total number of rows in the sqldatasource in the int variable intTotalRecords. How do i go about counting the number of rows in the datasource that i am trying to pass in?
Currently I have
dlRSS.DataSource = GetRSSFeed("http://www.foodsafetynews.com/headlines.xml")
dlRSS.DataBind()
Function GetRSSFeed(ByVal strURL As String) As DataTable
'Get the XML data
Dim reader As XmlTextReader = New XmlTextReader(strURL)
'return a new DataSet
Dim ds As DataSet = New DataSet()
ds.ReadXml(reader)
Return ds.Tables(2)
End Function
<asp:DataList ID="dlRSS" runat="server" Width="100%" >
<ItemTemplate>
<strong><p><div><asp:HyperLink ID="TitleLink" runat="server" Text='<%# Eval("title") %>' Target="_blank" NavigateUrl='<%# Eval("link") %>'/></div></p></strong>
<strong><p> <div><asp:Label ID="SubtitleLabel" runat="server" Text='<%# Eval("description") %>' /></div></p></strong>
</ItemTemplate>
</asp:DataList>
But is returning all rows in RSS Feed I would only like top 5 or so
I am working on gridview, i want to add the total number of records in the gridview footer which are returned by the query, and also want to see the curretly showing records, suppose if we have 50 records i want to display them as viewing 1-10 of 50 records. i need to display like this of similar to this format
View 2 RepliesHow to display the total number of records returned in a GridView in asp.net? I want to display it in a label or if possible next to the page index in GridView... And how to provide a select option in a GridView to select all records (It should select not only the record shown in one page in GridView but all records that were returned to the GridView) or one by one record that was returned? These things (for e.g., Number of selected rows) should also be displayed in the label which I mentioned before.
View 5 RepliesI have one application and there are 1500 users of that application.When 200 users logged in application that time login page and other pages of applications are not opend. I want to manage 1000 of users at a time.
View 1 RepliesHow to resize large number of images in a folder in c# windows application. I am using following code to resize images of my folders. If images are less than 1600 ( in number) then no problem but if images are more than 1600 then i am getting error. My code is given below:-
public static Image ResizeImage(string file, int width, int height, bool onlyResizeIfWider) {
using (Image image = Image.FromFile(file)) {
// Prevent using images internal thumbnail
image.RotateFlip(RotateFlipType.Rotate180FlipNone);
image.RotateFlip(RotateFlipType.Rotate180FlipNone);
[Code] ....
Thumbnail creation in ASP.Net: System.Runtime.InteropServices.ExternalException: A generic error occurred in GDI
(Visual Studio 2012 VB, MSSQL 2008)... Is there a way to count the number of records in a sqldatasource without displaying a grid on my page?
Code:
<asp:SqlDataSource ID="sqlMessages" runat="server" ConnectionString="<%$ ConnectionStrings:DBConnectionString %>" SelectCommand="SELECT * FROM [Messages] WHERE ([SentTo] = @SentTo) ORDER BY [MessageDate] DESC">
<SelectParameters>
<asp:SessionParameter Name="SentTo" SessionField="MemberID" Type="Int32" />
</SelectParameters>
</asp:SqlDataSource>
How can I get the number of records that are returned? another question I have a field "MessageStatus" how can I get the number or records that are listed as "new" as well...
Here is what I would like to display...
lblMessages.text = "Total Message: " WHAT DO I PUT HERE "Total New Messages: " WHAT DO I PUT HERE????
I tried to find out about subject but with no success. The point is that in the beginning I've made many user controls. My site is too slow. I have not idea yet if it is because of user controls.
View 7 Repliesis there is any methos so that only the some data rows displayed in detaisview.and rest of the data row item will appear by clicking more button or link.
View 1 RepliesI am working on a website in which more than a thousand users can login at a time and there may be more than 50000 total users. I am worried about the performance of the application in case of concurrent access.
what is the best way to manage that, so that my application runs without any performance issues.
I'm running a ASP.NET website on my development box (.NET 2.0 on Vista/IIS7).
The Session_Start method in global.asax.cs logs every call to a file (log4net).
The Session_End method also logs every call.
I'm using InProc session state, and set the session timeout to 5 mins (to avoid waiting for 20 mins).
I hit the website, wait for 5 minutes unit I see the Session_End logging. Then I F5 the website. The browsers still has the session cookie and sends it to the server. Session_Start is called and a new session is created using the same session id (btw: I need this to be the same session id, because it is used to store data in database).
Result:
Every time I hit F5 on a previously ended session, the Session_Start method is called.
When I open a different browser, the Session_Start method is called just once. Then after 5 minutes the Session_End each F5 causes the Session_Start method to execute.
Update:
After the Session timeout, all subsequent requests have a session start & session end. So in the end my question is: why are the sessions on these subsequent request closed immediatly?
[code]....