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 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 RepliesIn 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 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 am using mySQL. I have separate tables for several languages. When I display the Greek statements I seem to be limited to between 192 and 201 characters. That is not the problem with English, Danish, Dutch, Russian, or Farsi. I am using the same code for each with the only change being which table is opened. (In fact I just took the Dutch code and changed only the name of the table I'm opening to the Greek table and had the same problem.)The problem is that I've also double checked the statements in the table and they are complete, e.g., some have up to 255 characters.
View 2 RepliesIf I want to be able to have a table Consultant, which is the user and their personal information, and I want this user to be able to select their proficiency in a number of Programs (software) on a scale from 0-5 (zero being no experience whatsoever), how do I do this best?
I mean I could have a Consultant table with a one-to-many relationship to a Program table, and then have all the limited Programs availalbe loaded by an XML file or something, and for each Consultant associate all the Programs and their Levels of proficiency. But that seems very wrong and inefficient.
It seems to me I should have a table with all the (limited number of) Programs, and then by some sort of association between the two by Ids. But I can't get my head around how to do this. I'm thinking many-to-many... But first, is this correct? Secondly, how do I do this in an Entity Framework Model? I usually create my database code first, i.e. create the EF model, and then generate database from model. Will I get a junction table where I can add the Level field, because basically a Consultant HAS A Program with a Level, or actually a list of Programs each with a Level.
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..
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 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 Repliesthe helper @grid.GetHtml() You can display the limit rows (e.g. 10) and page numbers at the bottom of the display which can be viewed by clicking on the following sample data.But the helper @ grd.GetHtml() (I figured) there are restrictions in output. For example if I want to display picture < img src =" @ id .jpg" alt = ""/> (I'm doing when working with @ foreach) to do that I need to put in the < img src = ".jpg" alt = ""/> it's not convenient. mene Is it possible to use @foreach to organize limited preview rows and displays the page number to view the data?
[Code]....
I get this message when i go to update formview.
View 2 RepliesThe following code gives error: "When casting from a number, the value must be a number less than infinity."
<asp:TemplateField HeaderText="DATE" SortExpression="date1">
<ItemTemplate>
<asp:Calendar ID="Calendar1" runat="server"
SelectedDate='<%# Bind("date1") %>' VisibleDate='<%# Eval("date1") %>'>
</asp:Calendar>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox ID="Date1" runat="server" Text='<%# Bind("date1") %>'></asp:TextBox>
</EditItemTemplate>
</asp:TemplateField>
The error occurs at the line <asp:Calendar ID="Calendar1"...>
It errors because there are records with null value for date1 when the records are returned from the database.
Is there a way to specify in the .aspx file telling it to ignore null or display null/blank?
I 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 am using the asp.net and framework 2.0 with Ajax enable web.i have a text box and when user will enter "a" or number in this will search the name started from "a" character or number if he or she enter the number basically we can say live-search.
Employee search: Textbox.In this text box she/he will enter the first character of name or first number of employeeno and according to the a character name will search in list.
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.
I've implemented a ListView to display selected data from a DataTable. My listview is one row high and 4 columns wide. I've setup a DataPager to the left of it and another to the right to allow the user to access any item in the ListView.My problem is simple: When the user adds a new item to the DataTable, I rebind the data again { e.g. listView1.DataBind() }, and then I proceed to select that newly added item. BUT no matter what I try, nothing works! More precisely, I do this: listView1.SelectedIndex = #; where "#" is the appropriate index number.
View 8 RepliesI have a dataset with the following values:
NAME, NUMBER
Test3, 1
Test2, 2
Test3, 3
I am basically need the ability to do something like dataset.tables(0).row( ' here i would be like where item("NAME") = "Test2" ' ).Item("NUMBER")
I apologize in advance for my poor english:1. I have a dropdownList within my datagrid and its already populated fine (22 rows in my datagrid)2. The select item for the 21 row is the same as the select item of the 22 row3. When trying to do selectedIndexChange for the 22 row, it didn't seem to work.The error:
Dim ddl As DropDownList = CType(sender, DropDownList)
Dim dgi As DataGridItem = CType(ddl.Parent.Parent, DataGridItem)
Dim rowID As Integer = dgi.ItemIndex
The rowID keep staying at 20 even though the selectedIndexChanged is happening in row 22( ie. rowID should be 21)
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 Repliesif grid view contain number then formating is07.7711.00and alingment is rightif contain date then01-25-2011 then 25-jan-2011
View 4 RepliesI have a web user control with DataList control in it. In my .aspx page, I have a report header, an empty panel as a place holder, a report footer.In my .aspx.vb file, I'll loop through a list of departments. Within each department, I'll load a label to display the department name and the user control for the data, and add both the label and user control to the panel. So there are two variables:
the number of departments and the number of records in a user control.
Now I need to display the current page number and the total page number in the report footer. Is it doable? How? I'm thinking of this approach: declare a page variable count, count the number of department name labels and the number of records in a user control. When the total count reaches a number, such as 20, I'll break the page. This way, I can get the the page current number and the total number of pages. But how to add a page break to an asp.net page?
I have a gv which displays all foreign keys as hyperlinks. These links point to another page which show a gv for that particular table. When I click the hyperlink it will navigate to the correct url, display the gridview, and select the correct record, but.... the grid view will always initially display the first page whereas I would like it to go straight to the gv page of the selected row. How can i effeciently determine which page the record is on so that I can navigate straight to that page?
View 2 Repliesin my colum values like: ,2, 1,,3 1,2,3 1 , ,3 i want to show some text instead of these number .... here is my code
Report Category: ---------------------------------------------------- public string reportcategory(object check) { string[] report_type = check.ToString().Split(','); foreach (string rtk in report_type) { if (Array.IndexOf(report_type, rtk)
!= -1) { if (rtk == "1") { string value = "Weekly"; return value; } else if (rtk == "2") { string value = "Daily"; return value; } else { string value = "Monthly"; return value; } } } } i have also confusion here suppose i have 1,2 then how to write code to show text like "weekely,Daily
I 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]....
