I have a data grid in which I have to display around 12,000 records. Even if I do paging it is difficult to display all the records. Is there any other control or something else so that I can display all these records. Even if I make these as alphabetical also, some times I have to load 1000 records in a page which is difficult.
View 2 Replies
i am using sql server inbuilt mail system for sending mail.and i made SP to call dbmail sp
now my problem is when i call sp it get executed fine but in last suppose 1000 mails queued then 1000 times i get mail queued.and that my connection time out .i extend connection time out limit but i get error msg like
"Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. Mail queued."
my mail get queued well proper but due to 1000 or 100000 mail queued its lost of msg make problem.
Me with C#.net and sqlserver 2005. In my application there is a need to insert 1000 products details into my sqlserve table. I am using a for loop to insert and its done using a stored procedure, but when this code executes it stops mostly after 80 iterations and showing the error "Object reference not set to an instance of an object". How can I over come this? How can I make a steady sqlconnection?
View 12 RepliesI have a datagrid control which is bound to a table which containing more than 1000 records. And i want to show only 25 records once a time. I have used paging in datagrid. But each time the next page index is set, query is fired again. This takes lots of time. So what is the easiest way to bound data in this case to improve performance.
View 3 RepliesLet's say we are building some public service that grabs the setup of a user (what server, user and pwd he wants to perform the call), logs in into that server and do some processing...
the process takes about 15 seconds to complete each user has a different setup (server/user/pwd), so the process needs to run against each one
if 1000 users tells the system to run the method at 1:00PM
How can I insure that the method is processed in the next 15 minutes?
What should be the correct approach to this little problem?
I'm thinking that I need to do something Asynchronously, and parallel processing could speed up things, maybe throttling the processes, maybe execute 100 calls per each 30 seconds?
I never did something like this and would love to get your feedback on ideas and future problems just to spend 100 hours of work and realize that I took a wrong road
I am using Linq to SQL. I have a table with a uniqueidentifyer column.
I need to insert 1000 records, each with all the same values except for the uniqueid field.
I know the syntax to insert a single record for example where dc is a DataContext():
[Code]....
Does anyone know how if there is a way, other than looping 1000 times, to tell SQL to insert 1000 records generating different unique ids but assign the constant values to the other columns?
I am currently struggeling to make an Alphabetical pager. I have used the following code to create the pager:
[Code]....
My probrolem is to databind it. I want the pager to show all the letters at all time, but only make them to links if a word in the database starts with that letter. (Ex. got Apple and cucumber and mydatabase, only "A" and "C" become links and the rest letters fades in or some thing) I need the the code to be in a methid of its own. just dont know where to start.
[Code]....
now a days i'm working on my project. In project there is a aspx page which is binded with a masterpage, the problem is that when i run the project in debugging mode i found that page load event of a page is firing two times instead of one along with masterpage page's page load event. This is crreating a problem in filling a grid. I searched through the internet for this problem some says that it may happen if u have any image whose src="" or due to some bad HTML's on page .But i've gone through the page it does not contain any image whose src="" .
[code]....
Using Forms authentication, for some reason my login page is called 9 times. it causes some browsers to show "too many redirects!". Even with no javascript and nothing in the page_load event, it is called 9 times.
View 2 Replies am using a master page, with children pages.
I am using forms authentication, and a session object to hold user information once the user is authenticated.
I am able to login and log out. I am able to log in and use the "remember me" functionality of the forms authentication.
When attempting to test the "remember me" functionality, the master page load event contains code to check the forms authentication & remember me, and retrieve user info from the database to automatically log the user in. This fires correctly, and the screens all load with the user successfuly logged in, and the users info is successfully stored in a session object.
Without touching anything on the screen, a moment passes and then the master page load event spontaneously fires again, Page.User.Identity.Name still contains the user name, however the session variable is now null, and throws an error.If I tell it to run past this error, it does, and the application continues to function normally, withthe session variables set correctly.
Its almost as if that second firing is ina different session, or something.
I have no problem posting code, but I have a profile class holding / handling the session communication, etc so it is a bit cumbersome.
I have the following datagrid
<asp:GridView ID="importedListGridView" runat="server" OnDataBinding="importedListGridView_DataBind"
Width="450" CssClass="GridAltItem" AutoGenerateColumns="False">
<RowStyle CssClass="GridItem"></RowStyle>
[code]...
I created a search page with a lot of different functions. The page takes about 6 seconds to load so I'd like to work on making it faster. I first want to see what functions are taking the most time. I originally tried adding Response.Write(Date.Now()) throughout the code but didn't yield accurate results. I'm guessing it that's because .NET doesn't compile things linearly?
View 2 RepliesI have 1000 records in a table .
Now I want to Loop through all them ,extracting value of one particular column in each row (which is then used to find value in other table)
How should I proceed .
I don't want to use WHILE as it slows down my Stored procedure
I have a webpage which displays content drawn from a single record in a database table. I've been asked to change this so that the content displayed alternates between 2 records each time the page is requested by a browser (I guess this would equate to each PageLoad event).
The records to be displayed are chosen on the basis of two dates, a beginning date and and ending date, that define a time period in which the record is to be active. The table containing these records has 2 columns containing these dates (begin date is contained in "dtDisplay" and end date is "lastDisplay."
I'm not sure how to amend the existing code behind to make this happen. Here is the c# that I inherited from a developer who is no longer available.
[Code]....
I am looking for a way to improve user experience on a UI that can display on average 3K records in the Grid. Today's implementation limits grid on the page to 20 records with a "Next" option to continue through the data. Requirement is to load all of the available data in one shot and allow Sorting, Filtering, etc.
Environment: ASP.NET 3.5 SP1, WCSF 2.0, IIS 7.0
in this code i have generated runtime checkboxlist controls. my prob is in the page load i want to get the chekboxlist items selected for the items which the user has selected previously and saved. now i get only the last item in the loop as selected and the remaining are not selected.
// page load
protected void Page_Load(object sender, EventArgs e)
{
dsQuest1 = objCDAL.FetchQuestion(Convert.ToInt16(Request.QueryString["QID"]));
QID2 = Convert.ToInt16(Request.QueryString["QID"].ToString());
DataSet dsQuest = objCDAL.FetchQuestion(Convert.ToInt16(Request.QueryString["QID"]));...
I think I summed up the question in the title. Here is some further elaboration...I have a web user control that is used in multiple places, sometimes more than once on a given page.The web user control has a specific set of JavaScript functions (mostly jQuery code) that are containted within *.js files and automatically inserted into page headers.However, when I want to use the control more than once on a page, the *.js files are included 'n' number of times and, rightly so, the browser gets confused as to which control it's meant to be executing which function on.What do I need to do in order to resolve this problem? I've been staring at this all day and I'm at a loss.
View 2 RepliesThis is the problem. My datalist, which connects to an Objectdatasource (I implemented custom paging) becomes populated with data only half of the time. When I go to the aspx page which contains that datalist (from another page), sometimes, the datalist fully loads, but sometimes only the header shows up. The header just contains hard-coded text whereas the body (itemtemplate portion) contains things that are binded to the objectdatasource. I thought I would mention this since the problem might have something to do with how things in asp.net bind.
The strange part of this is that when I was testing and debugging within VWD 2010, the datalist loaded fully everytime and I had no issues. When I placed my files on the IIS web server, this is when the problems started happening.What could the problem be? The speed of the IIS web server vs VWD's "internal server"? My page_load, init_load, etc methods are empty for this aspx page. The datalist is solely handled by the objectdatasource_selecting method. Should I explicit call something from one of those early lifecycle methods to ensure proper datalist loading?
I have a simple UserControl that I've created that simply allows a user to enter the date. For the time being, it has a single Textbox with ID="tbDate". I am trying to dynamically add this control multiple times via (for example) `placeholder.Controls.Add(LoadControl())` but am receiving the error "An entry with the same key already exists". I could, perhaps, change the ID of the elements but then it would be difficult to grab the value entered by the user.
View 3 RepliesWhen a user inserts a record it automatically stores the Date and Time that the record was created in column called CreatedDate.
Now what I am looking to do is retrieve the records between two days - which isnt a problem really, I am doing this....
[Code]....
@StartDate and @EndDate come from Calendar selected dates.
@StartTime and @EndTime come from two textboxes.
when i make control (visible=false) onpage load event, this mean this control is created and Make Load on Server? becasuse i have ajax html editor when i make it hidden onpageload event, all My Controls rendered fast, but when i make it visible its slow down page , althouh ajax html editor is not in any updatepanel.
last question :when any DataControl ( for example DataList)Contain Datasource (assume ArrayList) and This ArrayList is null , this datalist created ? and Make Load on Sever? and the speed of page is the same as there is no datalist?
When I load my page I populate my repeater with the following code.
Dim conn As Data.SqlClient.SqlConnection
Dim Comm As Data.SqlClient.SqlCommand
Dim reader As Data.SqlClient.SqlDataReader
[code]...
I have a script that loads diferent photo in same div on masterpage for diferent pages.
So my question is how can I know what page is currently loaded so I can use something like this:
onpageload...
Dim pageID as String
pageID = ?????????
If pageID = "default1.aspx" Then
image1.ImageUrl = "~/zagreb.jpg"
ElseIf pageID = "default2.aspx" Then
image1.ImageUrl = "~/split.jpg"
End If
maybe I can put some kind of ID on every page but how?
HTTPresponse does not help to much becouse links looks diferent every time (default.aspx?sasa , default.aspx876786 .....)
[code]...
I have something like this. I want to make "Package Recap" invisible when the page is loaded. It is in the .
I set a labelA visible=false when page load.
How to make labelA blinking while meet a condition.
For example,
if ordercity="New York" then
labelA.visible=true
labelA blinking (how to code)
End if
