C# - Importing Name Space Without Use Effect Performance?
Jan 16, 2010Is there any deficiency performance if import a lot of name space in Web.config or in every single cs file while it's not necessary to be in all classes ?
View 1 RepliesIs there any deficiency performance if import a lot of name space in Web.config or in every single cs file while it's not necessary to be in all classes ?
View 1 RepliesI was recently asked to speed up a C#/ASP.NET/SQL Server business app website. Since I just started, I don't know too much about the internals. So where do I start? Sight unseen, what is the single most important thing affecting performance on a system like this? Database tuning? Hardware? Individual page optimization? What is the first thing you'd look at? EDIT: After I actually do the work, I'll come back and post the answer. ;)
EDIT again: "Profile" is currently the most-voted answer, and I agree that that is clearly what one should do. But I was looking for guesses/experience as to what the profiling results would show, so I don't think that answer counts...
i'm writing a stored proc and if a field i return is longer then 200 characters, i want to truncate, find the last space, remove any characters after that space, then add some full stopseg:
INSERT INTO @rec(articleid, abstract)
SELECT a.id,
CASE
[code]...
How to replace a character in a String to space or white-space?
View 3 RepliesI 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 have a problem with DataSet.GetXml() in ASP.NET 4.0:
First I populate the dataset with some tables.
Then I run the .GetXml() method on the dataset and some XML is returned. The output of this method is not want I want it to be, however.
The desired result is this:
[code]....
How do I stop this from happening? I mean, how do I stop the cell from being included at all?
In ASP.NET 1.1 the same code is used and the desired output is returned. This means that it is probably some new thing in 4.0 that I have to switch on/off. But what?
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 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 wanna create a ASP.NET c# file named "DBconnect.aspx" where I will provide all my MYSQL database settings. I would like to import these settings without re-entering database details to another page.
Of course have to mention the namespace with Public class but I do need to sample syntax to make this.
I'm a novice ASP.Net/C# programmer, and had an experience only of a couple of projects during college and a couple of freelancing projects when I was recruited by a startup company to build their ASP.Net based website. I've just abut completed the website, and now since the company is not able to find a worthy enough SEO, I'm expected to do our site's SEO as well(which is a totally new experience for me). Did I mention that I'm the only Web Developer here?So, now as you'd expect a novice programmer having no concern for future SEO needs, I built up the site without giving due consideration to any of the SEO enhancement techniques.
The Problems:
ViewState - When is it required? Is it really required if I'm not creating any controls on the fly? I'm using DataControls though. And the website(the pages visible to the user not the CMS), is purely information based. Also, if I disable a control(ex: DataList)'s viewstate, will the viewstate of controls inside it also get disabled?(which is what I'd like actually)QueryStrings - Now comes the toughest part, I've used Query Strings to the extent that you can say that the website is QueryString driven, which unfortunately enough is not a good thing for SEO. To make matters worse, the QueryStrings for some pages are not uniform. For ex- In some cases the querystring may have variables A, B, and C, while in other cases it can have variables M, B, C and probably not all the three variables in some cases. Now, I know that I'd have to do url rewriting but these query strings have dynamic data fetched from the database tables of size more than 10,000 rows. So would I have to create functions for url rewriting and use regex to separate wheat from whaff?
I am new to javascript and jquery. I have written some javascript code for some client validation.
document.getElementById(spnError).style.display = 'block';
This is how I am showing a span if there is some validation issues in the form. I want to use Jquery to show this span. I would like to slide it down slowly.
i want to get list of contacts when user enters his yahoo or msn alike emails. Application is build in ASP.NET with 3.5 framework. Solution i've found on this site does not work or require framework 4.0. I don't need solution which costs money or not personally tested by you ones.
View 1 RepliesI've got a simple (inline) ASPX page that is ouputting XML.
I want to import this XML into Excel 2007 using Data | From Other Sources | From XML Data Import.
If I specify the URL for my APSX page Excel opens the result into the Text Import Wizard :(
If I open my URL directly from Notepad, save the content to a file and import that into Excel, its correctly treating is a Xml. why Excel is treating the result as text when is comes from a Url?
Heres the code from the ASPX Page
<%@ Page Language="C#" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SqlClient" %>
<%@ Import Namespace="System.Xml" %>
[Code]....
Is there some simple way I am missing to import an Excel worksheet into a datatable using an OleDBConnection and change what row the header is located on? I have HDR=YES in my connection string and that works great when header is on row 1 but the header is actually going to need to be on row 3. I am using the following CommandText:
SELECT [headercol1name], [headercol2name], [headercol3name] FROM [sheetname]
I have imports.aspx with an ASP:FileUpload function.In my code-behind I have this:
SEPTA_DSTableAdapters.ServiceTBLTableAdapter sta = new SEPTA_DSTableAdapters.ServiceTBLTableAdapter();
SEPTA_DSTableAdapters.RoutesTBLTableAdapter rta = new SEPTA_DSTableAdapters.RoutesTBLTableAdapter();
protected void Page_Load(object sender, EventArgs e)
[code]...
I have an assignment which is to import mpp file into database via ASP.NET (C#).
View 2 RepliesI have a form that allows a user to import a spreadsheet. This spreadsheet is generally static when it comes to column headers, but now the users want to be able to include an optional column (called Notes). My code crashes when I try to read the column from the spreadsheet if it doesn't exist.
[code]...
In one of the application i am developing on ASP.Net. In this application we have been using lots of AppSettings. In the initial development we used ConfigurationManager.AppSettings[""]. but as development progressed we created a utility class in which we would define a static property for each AppSettings. Then issues started to come. Now when application is deployed on testing server and we change any settings on AppSettings it does not have any effect unless we restart the IIS. here is the following code snippet i am using to create static property of AppSettings.
public static class AppSettingsUtil
{
public static string Log4Net
{
get
{
return ConfigurationManager.AppSettings["Log4Net"];
}
}
}
Look at the reply and contact buttons @ [URL]how would I get that effect to my buttons (Dont need the icons, just the blue color, borders and a mouse over effect)
View 2 Replieshere is what i am looking for...
how do i highlight the gridview control row after i am done updating with the row?
[Code]....
EDIT:
here is what its generating at runtime after i debug the code
<script type='text/javascript'>
$('#ctl00_ContentPlaceHolder1_tabControl_gv_ctl03').show().fadeIn(8000).fadeOut(90000)
</script>
ere is what i am looking for...
how do i highlight the gridview control row after i am done updating with the row?
<asp:GridView runat="server" CssClass="DataWebControlStyle">
<AlternatingRowStyle CssClass="AlternatingRowStyle" />
<RowStyle CssClass="RowStyle" /> <
HeaderStyle CssClass="HeaderStyle" />
<SelectedRowStyle CssClass="SelectedRowStyle" />
</asp:GridView>
protected void gv_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
//update....
}
I have been trying to use ajax in my asp .net website developed in 3.5 sp1 2008! The problem is I can see tool kit controls in my tool box but i can not use the controls. like i was using the text box watermark effect but when i run the website the text-box does not show effect and there is no option in text box to add extender. there is only remove extender option. I have code:
<asp:ScriptManager ID="ScriptManager2" runat="server">
</asp:ScriptManager>
<asp:UpdatePanel ID="UpdatePanel1" runat="server">
<ContentTemplate>
First name:
<asp:TextBox ID="TextBox1" CssClass="unwatermarked" Width="150" runat="server" />
<ajaxToolkit:TextBoxWatermarkExtender ID="TextBoxWatermarkExtender1" runat="server"
TargetControlID="TextBox1"
WatermarkText="Type First Name Here"
WatermarkCssClass="watermarked" />
</ContentTemplate>
</asp:UpdatePanel>
I running my static analysis checks again and I'm getting 100s of nags on
Label foo = new Label(); //Where this is an ASP.NET web forms label
Do I need to call dispose on these web forms labels? Also, how late in the page life cycle is it safe to call Dispose on these? If a class implements IDisposable, but doesn't actually do anything in it, is there any harm in not calling dispose?
(Yes, I have already read that closing connections is a good thing and using blocks are a good thing, too.)
DataSet is another class that seems to implement IDisposable for inexplicable reasons.
I have a Panel that I'm setting visible=true explicitly. The debugger passes over that line and visible still evaluates to False on the next line. Obviously as a result, the Panel is not shown. How is this possible?
pnlValidate.Visible = true;
if (IsPostBack) return;
<asp:Panel ID="pnlValidate" runat="server">
[code]...
I'm here again because of jquery overlay.I have an overlay that loads a normal Div into it, i want to apply the apple effect to it, but i can't, i get an javascript error "Effect no found".The code for the jquery function is written as below:
[code]...