I am using ASP.NET AJAX Autocomplete to load the data. I am fetching data from a Dataset, which is store in Session. The table length is approx 1000 rows.I use DataView to and Table.Select ("Data Like '"+ inputvalue +"'") to filter data on each keystroke.I am wondering, what's the best and fastest way to store and fetch data for Autocomplete?
View 5 Replies
I have developed a website in asp.net framework 2 . This website is being hosted in two different servers without any change in code. My issue is about the performance of these 2 sites. One website is taking much time for inserting datas to the DB (SQL server 2005). 2 websites are having different DB server.
I think the issue is for the DB server. How can we rectify the DB performance while insertion and Is there any other cause for this permance issue?
I am not sure if this is the right forum. I can not find a forum for LINQ.
I am working on an application using LINQ. Application performance is not up to par and my tests show that it is LINQ queries that are slow. I was wondering if anybody can recommend where I can find an article about optimizing LINQ performance maybe by compilation or other methods.
I'm creating just simple autocomplete sample.
taking one textbox adding autocomplete extender as
<asp:ScriptManager ID="ScriptManager2" runat="server">
<Services>
<asp:ServiceReference Path="WebService.asmx" />
</Services>
</asp:ScriptManager>
<asp:TextBox ID="TextBox1" runat="server" EnableTheming="True" ></asp:TextBox>
<cc1:AutoCompleteExtender ID="AutoCompleteExtender1" runat="server" MinimumPrefixLength="1" ServiceMethod="GetCountryInfo" ServicePath="WebService.asmx" TargetControlID="TextBox1">
</cc1:AutoCompleteExtender>
<asp:Button ID="Button1" runat="server" Text="Button" onclick="Button1_Click" />
Also creating web services as "WebService.asmx" & code inside this file is that
<%@ WebService Language="C#" CodeBehind="~/App_Code/WebService.cs" %>
------
then in Webservice.cs file i write code as
public class WebService : System.Web.Services.WebService {
MySql.Data.MySqlClient.MySqlCommand cmd = new MySqlCommand();
MySql.Data.MySqlClient.MySqlConnection con = new MySqlConnection();
//MySqlDataAdapter da = new MySqlDataAdapter();
MySqlDataReader dr;
public WebService () {
//Uncomment the following line if using designed components
//InitializeComponent();
}
[WebMethod]
public string[] GetCountryInfo(string prefixText)
{
int count = 10;
string sql = "Select * from tbl_patientmaster Where P_NAME like '" + @prefixText + "%'";
con.ConnectionString = System.Configuration.ConfigurationManager.AppSettings["HMSDBConnectionString"].ToString();
con.Open();
MySql.Data.MySqlClient.MySqlDataAdapter da = new MySql.Data.MySqlClient.MySqlDataAdapter(sql, con);
da.SelectCommand.Parameters.Add("@prefixText", MySql.Data.MySqlClient.MySqlDbType.VarChar, 50).Value = prefixText + "%";
System.Data.DataTable dt = new System.Data.DataTable();
da.Fill(dt);
string[] items = new string[dt.Rows.Count];
int i = 0;
foreach (System.Data.DataRow dr in dt.Rows)
{
items.SetValue(dr["P_NAME"].ToString(), i);
i++;
}
return items;
}
this code is not working
I am creating a service oriented application where trying to have everything using services....however there is something I am not sure of , I am having a page that calls the database at the page load...so what would be better and faster?? to call database in pageload , or to call wcf service from javascript during javascript load ??btw , I am using a repeater in the page , but I have created somekind of an engine to create the suitable html so...I'll be creating the repeaters html using the wcf and resend it back to the page If I am using a wcf service at the start.
View 1 RepliesI'm using jQuery AutoComplete Plugin in ASP.Net as outlined in the article below, so that as a user types in a .Net textbox they get a list of options to choose them. This works fine, but what I need to do now is call a server side function when the user has finished typing or has choosen a value, rather than the user having to submit the value by pressing a button.
View 2 RepliesI am using Ajaxtoolkit 3.5.I am using an autocomplete textbox extender.My problem is I have populated Country in the autocomplete textbox.I have to populate city in another dr
View 1 RepliesLet me know asp.net application performance tips..
View 2 Repliesi have a web application with master and content pages i just wanna know that can i use web user controls(.ascx) instead of these content pages and load them dynamically according to user clicks on the menu does using user control affects performance. i wanna load data from sql server in controls placed in web user controls so i m confused that it ll be a performance hit as i have to load the user control after every postback..plz give me suggestions on this. is there any performance testing tool that i can use to see the load on server.
View 9 RepliesI see bugs? give me your opinion really improve my site es [URL] this is metasearch fly meta search flights
View 2 RepliesI am working on finance domain, we are using many sessions and viewstates for store values and data. Our clients want fast speed of our website. We are using grid/repeater/datalist and chart controls for show data.
View 3 RepliesI am working on AJAX-ASP.NET site. This site is taking 25-30 sec to load the contents. I want to improve this site performance. Is there any settings required in IIS? How to check IIS log files?
View 2 RepliesIn my web application i send a invoice(pdf file at least 700kb) when completing a order(create a pdf file then attach it to mail function and send it and delete the file).There are more than 10 users use this function same time. My problem is when all users login to the system and doing transactions system take more time to complete the above function. I want to increase the performance. What is the best way.
View 3 RepliesDoes anyone have performance comparision between asp.net and infragistics controls? Not only for complex controls. I need to compare all available controls.Note: The reason I am posting this here instead of infragistics is :)
View 1 RepliesI have been led to believe that the performance benefits of using StringBuilder over normal concatenation means that you should always use stringbuilder when concatenating more than 2 strings. However when I test them this does not seem to be the case. Take these 2 methods
public void TestMethod5()
{
for (int i = 0; i < 1000; i++)
{
string t = string.Empty;
t = "dddddddd" + "dddddddd" + "dddddddd" + "dddddddd" + "dddddddd" + "dddddddd" + "dddddddd" + "dddddddd" + "dddddddd" + "dddddddd" + "dddddddd" + "dddddddd" + "dddddddd"; ;
}
}
public void TestMethod6()
{
for (int i = 0; i < 1000; i++)
{
StringBuilder sb = new StringBuilder();
sb.Append("dddddddd");
sb.Append("dddddddd");
sb.Append("dddddddd");
sb.Append("dddddddd");
sb.Append("dddddddd");
sb.Append("dddddddd");
sb.Append("dddddddd");
sb.Append("dddddddd");
sb.Append("dddddddd");
sb.Append("dddddddd");
sb.Append("dddddddd");
sb.Append("dddddddd");
sb.Append("dddddddd");
string t = string.Empty;
t = sb.ToString();
}
}
TestMethod5 takes 0.03 milliseconds so complete but TestMethod6 takes 1.43 milliseconds What is going on?
I have a webpage that takes about 1 minute to completely load onto browser. there are many user control in the page. I was told that there is a feature in VS.NET 2010 ultimate enables you to see execution time of each method.
View 2 RepliesHow to implement Collapse Autosuggest / Autocomplete with Ajax v. 2.1.3?
View 1 RepliesI have to add data in database using autocomplete. if the data exist the old data will overwrite.if the data is not available new recourd will added in database.
eg- i have Product name, Product Qty and Product Price three text box if the product name is exist it display product price and also user can update price.and product name is not exist user can able to add new record. ....
I am developing a site similar to forums. I allow users to Post articles and upload files regarding the articles. I am not storing the Attachments contents in DB instead i store only the path of the attachment file and store the actual file in physical folder in the Project directory. WHat i want to knw is if the size of the physical folder increase will it affect the performance of my application.
View 6 RepliesI created an ASP page which contains a MultiView and two buttons, it is as below
<div style="width:700px; background-color:White">
<asp:MultiView ID="mvAgreement" runat="server"
onactiveviewchanged="mvAgreement_ActiveViewChanged"> [code]...
The first and third view are simple now.The second view contains a user control AgreementDetailUC, which dynamically loads many other user controls onto several dynamically created tabs, as show below
AgreementDetailUC.ascx is like:
<div style="width:700px; background-color:White; text-align:left">
<cc1:TabContainer ID="tcAgreementDetail" runat="server" Height="300px" AutoPostBack="false">
</cc1:TabContainer>[code]....
When <Next> and <Previous> button is clicked, it take several seconds to show the second view. Page_Init is run very fast, it seems the time is spent on rendering the page.
My questions are:
1. How can the performance be improved?
2. How to change the cursor to hour glass when a button is clicked and change it back when the new view is shown (I can set it to hour glass when a button is clicked, but don't know how to set it back to normal).
One thing I really love about web browsers, is the autocomplete feature they have for different controls, like textboxes in forms. However, some times users get confused with the dropdown appearing. So, we would like to be able to disable the autocomplete feature for some textboxes on some of our ASP.NET WebForms pages. Isn't there a property which controls that? Or is that done through JavaScript?
View 3 RepliesI have an application where I don't want the browser to be able to remember passwords. I can see the AutoCompleteType = disable and that seems to work in IE, but I also need to support FireFox. Setting autocomplete="off" doesn't seem to do anything. Is there anyway for me to kill the autocomplete of a password text box in FireFox?
View 4 Repliesim new at asp. net and im making a web page with 3 dropdownlist filtering DATA, and then i display a Gridview with the data selected. But i also have some TextBoxs and i want them to autocomplete according to the filters i previously selected. Im working all of this with no code behind.
I Bold The TextBox so you can see it clearly :D.
[Code]....
I want use auto complete TextBox and multi select drop down list. If multi select drop down list worked auto complete TextBox show result in top. If auto complete TextBox worked multi select drop down list not worked. It’s my result but not my requirement. I shared code below but not my requirement.
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="dolgeForm.aspx.cs" Inherits="RProject.dolgeForm" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
<link href="Scripts/jquery-ui.css" rel="stylesheet" type="text/css" />
[code]...
Which is best one to autocomplete textbox whether ajax autocomplete or jquery autocomplete ....
View 1 Replies
