I hired some to write a ecommerce website for me.and the used SqlHelper.GetInstance().ExecuteDataSet stuff i'm not familiar with.
But is real slow .
Screenshot of trace,page takes like +20 sec to return like 20 records of 3 field each!The DB queries are good, use same SP on my own app and it takes les then 1 sec.Did they use the sqlhelper wrong? is sql helper that slow?
string connectionString = (string)
ConfigurationSettings.AppSettings["ConnectionString"];
SqlConnection connection = new SqlConnection(connectionString);
SqlCommand command = new SqlCommand("INSERT_PERSON",connection);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add(new SqlParameter("@Name",SqlDbType.NVarChar,50));
command.Parameters["@Name"].Value = txtName.Text;
command.Parameters.Add(new SqlParameter("@Age",SqlDbType.NVarChar,10));
command.Parameters["@Age"].Value = txtAge.Text;
connection.Open();
command.ExecuteNonQuery();
connection.Close();
Above is my code.
I has more than 100 methods like this, so every time i'm opening the connection and close it, this will take too much of time, what i think is instead of this i would like to create the class for Connection open, that class will check whether the connection is closed or Broken then Open it(like SqlHelper.cs) so without big change on my methods, how to create that class and how to access that class from my methods.
what is the exact difference between Sqlhelper.ExecuteReader and Sqlhelper.ExecuteXmlReaderand which on is faster
View 3 RepliesI have 2 tables with Primery Key in both table and 700k in each tables and i am direct executing following Query in SQL Server 2008
[Code]....
Its speed very slow and then timedout error. My system configuration is good and i am not executing it online but offline on my laptop.
I'm facing a problem in our current running application. There is a table in database which has 67 columns,among these 18 columns are nvarchar(max) datatype and contains 30K records. Problem is now that SELECT * FROM myTable it takes around 3 to 4 seconds. Which is degrading our application's performance.
View 12 Replieshow can build the aplication in apache?, I upload all the file but appear this error:
Index of /
cgi-bin/
Apache/2.2.14 (Unix) mod_ssl/2.2.14 OpenSSL/0.9.8e-fips-rhel5 mod_auth_passthrough/2.1 mod_bwlimited/1.4 FrontPage/5.0.2.2635 Server at www.distribucionesoriol.net Port 80
what is the use of this...?
View 4 RepliesI am using a master page and a header ando footer control. Every time I want to debug a particular .aspx page I have to keep pressing F11 to skip all these pages and its events.....Is there a way to slik them other than simply pressing F5 to go to the next breakpoint?
View 2 Replieshow to debug the wcf code. Means I have added refernce of wcf code in my web appilcation's code and called that wcf function in my web application code. Both applications are on my local machine. I have put up break point in web application and also put up break point at the function in wcf. Can break point swicth rom web application to wcf code.? Is ther any way to do this or any other way to do like this so that I can debug the function in wcf.
View 3 RepliesCan a ASP.Net 4.0 Web Aplication use (or host) a silverlight control directly without first creating a Silverlight Application
View 4 RepliesI have create a class SqlHelper in window console client project, then test it it works fine. In my SqlHelper class I make all methods are public static. Then I created an assembly, add it to my unit testing project. Whne I try to access the public function of SqlHelper class, I got error like "Error 1 'CreateDatabase.SqlHelper' is inaccessible due to its protection level ".
Here is my class:
[Code]....
at this line: SqlHelper.setUpTestDatabase I got above error, Where goes wrong?
It looks that the old SqlHelper class from the Microsoft Enterprise Library has been mostly replaced by the Database class which is included in the new Enterprise Library version 5.
I have a very simple and trivial example:
using Microsoft.ApplicationBlocks.Data;
private void PopulateCheckBoxGroup()
{
const string strConnTxt = "Server=(local);Database=DataBindTests;Integrated Security=True;";
const string strlSql = "select Technology from PreferredTechnology where ParentId = 1";
CheckBoxList1.DataSource = SqlHelper.ExecuteReader(strConnTxt, CommandType.Text, strlSql);
CheckBoxList1.DataTextField = "Technology";
CheckBoxList1.DataBind();
}
Note: You may not need to read the whole thing to know what's wrong... skip down to the part about the 3 scenarios if you'd like. Only read the begin if you'd like some background info on how I've tried implementing this and where the errors occurred.To begin with, I'm trying to retrieve a list of Clients stored in the CRM_Clients table for a given callerId.I retrieve the clients from my Controller with the SelectLiveClientsForCaller method. The message is then passed on to the DAL through the static Instance method in the DataProvider class:
public List<Client> SelectLiveClientsForCaller(int callerID)
{
List<Client> results = new List<Client>();
[code]...
We have a requirment to draw a graph (line or bar), where the data will be changed 40 to 50 times in second , we want to refresh data automatically.
Which chart component should we use for drawing graph and how do i make sure that the data will be refreshed very fast on the graph web page.
I have a look-up grid with two columns, Last name and AddressI need that look-up grid to take as little screen real estate as possible, but I have to include the "Select" function next to every row.Any way I could fire the Select function by clicking on the ROW verses the "Select" function
View 8 RepliesFollowing is my case in detail.I have a class against which I will configure an objectDatasource(I have a datatable in the class which the data will be initially loaded from the database.)A gridview which has provisions to add/update/delete records will be bound to the objectdatasource
My methods i.e. insert/update/delete will be manipulating the datatable and NOT the database directly(I DONT WANT TO CONNECT TO THE DATABASE IN THESE STEPS. THE REASON IS THAT THE INSERTS/UPDATES/DELETES WILL BE PERSISTED ONLY WHEN THE USER CLICKS A SAVE BUTTON(MAY BE PLACED OUTSIDE THE GRID) . My class to which the objectDatasource points to will have anadditional AcceptChanges method which will be called on clicking the save button. This method is the one which connects to the database and where the adapter.update will be called.The query here is that how do I call the AcceptChanges method of my class instance which is bound to the grid? Also I would like to get some websites where I can see the real world implementations of gridview(with insert/update/delete options) so that I can improve my implementation.
I have this code there Federal_Mandate I am checking weather this MandateType is 1 or 0
if its one I am just converting this as 1 or 0
mandate.Federal_Mandate = collection["MandateType"].ToString().Equals("Federal") ? Convert.ToByte(1) : Convert.ToByte(0);
and my datbase Federal_mandate datatype has tiinyint.
is that something doing wrong i am here.. why I am gettting object reference error here?
im using Vs2010 to plot real time line chart. i have been looking for the section that allow me to set X and Y axis..
i jus couldn't find the place for me to set.
my Y axis is a double, min =0, max = 100 and my X axis, min =0, max = 300(seconds).
How would you troubleshoot a page that is rendering slowly in ASP.NET?
This issue is happening on only specific pages with a few user controls. Other pages work fine. Tracing has clarified that the issue is happening between "Begin Render" and "End Render".
what is the best way to show/hide controls in .net?
I have a page with many show/hide depending on the control value.
eg. radio button list rbl (dynamically generated from the database values)
based on the radio button list value,will need to show/hide the other controls.
if the value is 1, will need to show or hide dropdownlist1.
if the value is 2, will need to show or hide dropdownlist2.
I tried using the javascript with rbl.Attributes.Add("onChange","return toggleDropdown();")
then in my javascript function i will show/hide the control.
However when I toggle the dropdown for the second time, it became very slow. The first time is okay.
I have also tried using ScriptManager and UpdatePanel (putting the controls inside the UpdatePanel), but it is also very slow when toggling dropdown for the second time onwards, causing the page to hang.
I have an .aspx page with multiple .ascx (User Controls on it). One of the User controls is very slow in loading (calls a very slow webservice for the data.). Now, my question is how to render all the controls on the page (so the User can view those) and have a rotating icon for this control (slow one) (till it loads). I know, I need to bring AJAX into picture, but any clarification on that would help as I will be new to AJAX programming.
View 4 RepliesSo I have a RadPanelBar, and within that a RadTreeView. On a node click event I want so update some control.. for now I am just trying to update a textbox. It works fine except that the first time I click on a child node it takes a very long time to update the control.. Just a simple text change. I set a break point in my function and I noticed that it is taking long to fire the OnNodeClick event.. If I click a parent node in the tree view it loads fine on the first click. Also, after the first time I've clicked it.. it loads quickly.. If I refresh the page, it is slow on the first click again.. Is there something I am missing.. Is the structure of my HTML inappropriate for these AJAX calls? I feel like this is a really simple example that should work..
<asp:Content ID="BodyContent" runat="server" ContentPlaceHolderID="MainContent">
<telerik:RadAjaxManagerProxy ID="RadAjaxManagerProxy1" runat="server">
<AjaxSettings>
<telerik:AjaxSetting AjaxControlID="IncidentReportPanel">
[Code]....
EDIT: I updated my code according to this article, [URL] , and the problem persisted... again it only happens the first time..
EDIT: Just to clarify, by updating according to that article, I mean that I removed all the tables and relative widths and replaced them with css positioning and fixed widths.. the problem only happens the first time.. and it only happens sometimes.. quite a few times i thought i solved the problem as it would start responding quickly.. but then after I change my .aspx and change it back (even to the exact same thing when it was working quickly).. I get the same problem..
EDIT: So, I removed the AJAX component.. and setup the control so that it does a PostBack.. and it still takes long to hit my break point.. so it seems that its not an AJAX issue... but for some reason my events are taking long to fire..
EDIT: So I followed the advice on this post and I used the webservices to do my binding and handle everything from the client side code.. All seemed to be ok until I decided that I wanted to return nodes from my webservice that could also be expanded.. So in my webservice I set the ExpandMode of my RadTreeNodeData object to Webservice.. and it renders the data correctly when I expand the child nodes.. However now I see the same problem from before where some calls take 20-30 seconds.. It takes 20-30 seconds to even hit the break point in my webservice.. Should I use the OnClientNodeExpand event instead?
I just use a FormView to display the data. When I tried to set the PageIndex at Page Load, it is quick to get the PageIndex value from database. But it took 2 seconds to set the PageIndex.
FormView binding to a List collection which get from Database (It is quick to get the data from database)
My web app has one main page, which is like a work bench. Within this work bench I have 3 placeholders that I load 3 different user controls into (only displaying one at a time). It works, and loads ok although it is very slow.
For instance; Each user control has a 'New' button. when I click this it takes anywhere from 3-10 seconds just to refresh the page, and display all the original default values.
I gues there is a lot of info being sent/returend to/from the server (The main workbench page, and the usercontol), but it still seems to be taking way too long. I have a customer using my application, and they have raised the issue, and have even experienced delays of around 30 seconds for simple tasks.
I have walked through my code with the debugger in vs2010 and nothing seems to take a long time. I have also used Firbug to try and find out what is going on, along with setting Trace="true" on the page to try and resolve the issue. Its all just numbers to me, I have no idea what is going on.
I have a Table (in SQL Server) that is being updated roughly every minute or so with new records being inserted from various sources. The number of records inserted in this duration varies from a few records up to dozens of new records. I am using an update panel to rebind my data every minute to keep the GridView current. Now that I have the data refreshing I am looking for a better solution than reloading the data every minute. how to best keep my GridView up to date? Here is what I would like to accomplish:
1. Load the GridView and refresh the contents every minute. (60 second intervals)
2. When the GridView is refreshed every minute I would like to append only the new records to the existing grid, rather than bringing back the entire result set with each round trip to the database.
3. I would like a visual cue to identify the rows that have been inserted into the GridView. If new rows were to flash/flicker with a background color (yellow) that would be ideal.
Am I even using the correct control for displaying real time data, or are their other options? I essentially am looking to find the preferred method of displaying data that is being updated in real time in a web application. I'm hoping there is a solution involving AJAX but I haven't been able to find much on The Google. I am open to changing anything and everything about my approach -- this is largely a learning exercise. For testing purposes I am currently using LinqDataSource in conjunction with a GridView in an UpdatePanel being refreshed by a Timer control every 60 seconds. Informational: I have also started playing with the [URL] in place of the Timer control. However, for the purposes of this example I would be content to achieve the desired behavior using native controls as I have described them above.