Architecture :: Redundant SQL Code To "set Up" My Code Behind. Can I Put It In The Global.asax?

Oct 14, 2010

I've moved away from using sqldatasources, and now I exeucte all my sql in my code behind. However, I'm looking to make my codebehind a little more cleaner/neater. For example, on one page, there are three stored procedures that must execute, and All three have these same 8 lines of code for each of my three stored procedures. How can I condense my code behind to not always have to add this...

SqlConnection conn = default(SqlConnection);
SqlCommand comm = default(SqlCommand);
SqlDataReader reader = default(SqlDataReader);
string connectionString = ConfigurationManager.ConnectionStrings["xyz"].ConnectionString;
conn = new SqlConnection(connectionString);
comm = new SqlCommand();
comm.Connection = conn;
comm.CommandType = System.Data.CommandType.StoredProcedure;

View 10 Replies


Similar Messages:

MVC :: Pattern URL Routing In Global.asax Code

Jul 15, 2010

Currently using asp.mvc in application. there is problem related to my URL. I have changed Routing respectively as per the mvc pattern URL. In Global.asax Code :

routes.MapRoute("Default",
// Route name
"{controller}/{action}/{ID}/{PRODUCT}/{CATEGORY}",
// URL with parameters
new { controller =
"Home", action = "LogOn", ID =
UrlParameter.Optional, PRODUCT =
UrlParameter.Optional, CATEGORY =
UrlParameter.Optional}
// Parameter defaults );

In Grid, While click row of ProductDetails link URL will be : [url] When click on same thik i click on product Page link i am calling method "ProductDetails". Expected URL would be [url]

View 1 Replies

Web Forms :: Global Asax.cs Code Is Not Executing?

Jul 22, 2010

I have a Global.Asax and Global.Asax.cs file that is specific to my particular Asp.net project. For some unknown reason the code in my Global.asax.cs file is not being executed. I thought that the breakpoints were being ignored, however that is not the case. Because if I try to deliberately force an error to occur, the code is never executed. Below is an example of what I am talking about. The real code in my Application_Start method is not shown below. ANd other methods are not shown as well.

I have tried renaming the Global.asax file and then re-creating it, and that did not work either. Strange because when I try and create a new Global.asax file, the option to create a code behind file is greyed out.

Why isn't my Global.Asax.cs code being executed?

private void Application_Start(object sender, EventArgs e)
{
int x = 1;
int y = 1;
int z=1/(x-y)
}

View 8 Replies

What Code Would Be Placed In The Application_start And The Session_start Events In Global.asax

Oct 31, 2010

what might be best suited to place in the Application_Start and Session_Start subroutines? I know when each subroutine is called. Application_Start when the first user first accesses the web application. Session_Start when a user opens a session with the application. But what code belongs in each of these subroutines. What should the code in each subroutine do?

View 2 Replies

Web Forms :: Calling Global .asax Page Events From Code Behind (C#)

Apr 1, 2010

i wrote some code in application start event in global.asax page...

how to call that event in my every .cs page of my project.

View 5 Replies

Visual Studio :: Debugging Global.asax Code In Integrated Mode?

Feb 21, 2011

migrating my ASP.NET project from IIS 6 to IIS 7.5 I came across an issue with the Managed Pipeline Mode set to 'Integrated'.I have a Global.asax file in my web root to initialize some objects, gather data etc., however I am not able to hit breakpoints in the associated code-behind file (VS 2008). The code is executing very well (as I can tell from Eventlog), but I want to step into all that initializing there and need to have the debugger attached properly.Everything is working as expected in Classic pipeline mode. Since I'd like to benefit from Integrated Mode features in the future I wonder if I have to give up the ability to debug my Application start and error events...

View 1 Replies

Web Forms :: When Adding New Global.asax File, The Option To Create A C# Code Behind File Is Greyed Out?

Jul 25, 2010

I have an asp.net application. I want to add a global.asax and global.asax.cs file to my project. In the IDE when I select to create a new global.asax file, the option to create a CS code behind file is greyed out. When the global.asax file is created, no code behind is created, instead code is placed in the global.asax file and the global.asax.cs file is never created? Why is the option for a C# code behind file greyed out?

View 4 Replies

C# - Dictionary Lookup Efficiency & Request Scoped Global Variable Accessible By Global.asax And Pages/etc?

Feb 8, 2011

I know there is a couple answered questions on here regarding "request scoped" globals, but I want to nit-pick on something specifically and maybe squeeze some extra enlightenment out of one or two of you.I have an ASP.NET C# Website and a static Dictionary of objects (loaded from DB once on Application start). Each page request will need to do a lookup in the Dictionary (based on a key derived from the request url/etc) and get the appropriate object.The issue is I'm trying to maximize efficiency by reducing the lookups to the Dictionary per Request. Doing just a single lookup within a Page itself is easy enough and I can pass the object to sub controls, etc too.. but global.asax is separate from the Page and it also needs to use the object (in Application_BeginRequest and Session_Start).

So is doing a Dictionary lookup once in Application_BeginRequest, once (when necessary) in Session_Start and once in the Page negligible speed wise, even if there are many requests coming in every second?I would like it if I could just have a Request scoped global variable that I can easily call upon.. the only one I see available though is HttpContext.Current.Items and that is a Dictionary itself.Am I beingridiculously nit-picky with my concern over efficiency? or will these milliseconds (nanoseconds?) get me in the long run when more and more requests are being made?

PS. I currently only have around 100 objects in the Dictionary although this may increase in the future.

View 2 Replies

HttpHandlers / Modules :: Fire The Application Error In Asax From The Code?

Aug 7, 2010

I have this code in Global.asax but it not firing once an error occured:

[Code]....

View 2 Replies

C# - Code Works On Local Machine Only Not On Global?

Jan 16, 2011

I am having some trouble with an ASP.NET website I've set up and it's very difficult to debug.Background Information:There is a page on my website that allows the user to upload one or many Microsoft Word documents. The user can then press a button, and the code is supposed to open the document(s), count the words, and then return the number of words in a table.This works perfectly fine when I am in Visual Studio running the debugger, however when I try to do it over the web from another computer, I get an error.

try
{
String file = this.lstFileBox.Items[i].Text;
// MicrosoftWordOperations is a custom class
MicrosoftWordOperations wordOps = new MicrosoftWordOperations(file);
String contents = wordOps.GetContents();
int numWords = wordOps.CountWords(contents);
[code]...

View 3 Replies

When Use Global.conString In Web Form Code Behind It Comes Up As Null

Jan 26, 2011

I have a Global.cs within my App_Code.

Here is the variable I have set:

static string _conString;
//Connection String
public static string conString
{
get { return _conString; }
set { _conString = ConfigurationManager.ConnectionStrings["BreakersConnectionString"].ToString(); }
}

When I use Global.conString in my web form code behind it comes up as null.

View 3 Replies

C# - How Can We Use Global.asax

Feb 26, 2010

how can we use global.asax in asp.net? and what is that?

View 4 Replies

Global.asax With SQL?

Jun 20, 2010

Is it possible in the global.asax file on session_start to check if a url string exists and it it does insert the string into a sql database? The url would be something link http://www.mysite.com?campaign=january.

I would want to capture the january bit and put that in the database for each visitor that uses that url.

View 3 Replies

How To Assign A Control Property Value From A Global Variable In Page Code

Aug 31, 2010

I have a control and list of variables and I want in the control property to be assigned to the variable value directly in the page not from the back code, something like this

My global variables

public string Banana = "banana_pie";
public string Apple = "apple_pie";

in my custom control instead of:

<uc:LoadPie id="pieBanana" type="banana_pie" />

To this

<uc:LoadPie id="pieBanana" type="<%=Banana %>" />

so is there a way or just assign the property in page back code.

View 3 Replies

Visual Studio :: Global Name Change Of The Stored Procedures In The Code Behind?

Jan 28, 2010

i have a project that makes calls to SQL db stored procs. I wanted to do a global name change of the stored procedures in the code behind. now I am getting errors that controls on the pages are not defined in the code behind. I did not save the changes that were made.

View 1 Replies

Web Forms :: What Is Global.asax / How To Use It

Jan 27, 2010

I want to make All Methods about Error handling in asp.net some one device me at using global.asax what is global.asax?

how can i use it ?

View 1 Replies

Configuration :: Global.asax 3.5?

May 12, 2010

I have a hosting account on DailyRazor.com , i use Global.asax in my project to start a schedule process in Application_Start.When i just publish my website, and upload it, the Application_Start does not Fire, but when i upload the Global.asax to my host it gives an Error but the Applicaiton_Start Event fires up, and then i delete the Global.asax file and everything works.just wondering, What am doing wrong ? or why this meaningless thing happens?

View 2 Replies

C# - Global.asax Application_BeginRequest

Nov 4, 2010

I have a site with multiple domains pointing to it. I wanted to redirect all requests to main domain so I've created a method called RedirectToRealDomain("domain.com") to check and redirect all requests to my preferred domainAt the moment it lives on Session_Start but I am planing to move it to Application_BeginRequest event. As I understand Session_Start only raised when new session started but Application_BeginRequest raised on all requests. RedirectToRealDomain method doesn't do any DB lookups or anything expensive apart from comparing strings.

View 2 Replies

Set Masterpage From Global.asax?

May 21, 2010

I want to set the Masterpage property in Global.asax.

This is what I have done but I get a NullReferenceException on the first line.

protected void Application_PreSendRequestContent(Object sender, EventArgs e)
{
System.Web.UI.Page page = System.Web.HttpContext.Current.Handler as System.Web.UI.Page;
if (Session["lang"] == "eng")
{
page.MasterPageFile = "SideMasterPageEng.master";
}
}

View 1 Replies

.net - Get Username In Global Asax?

Jun 29, 2010

I am trying to check if the user belongs to someone's friendlist from the database and redirect him accordingly.I am doing this in a routehandler called by Global Asax.I just want to know how to get the username (from the login information) in the route handler class (or Global asax)I used this: string username = HttpContext.Current.User.Identity.Name; and very strangely, its assigning ".aspx" as the username!! ps: i did search for similar question but in vain.

View 1 Replies

Vb.net - To Rewrite Url In Global.asax?

Oct 19, 2010

I need replace double slashes in one slash. I am planning do this in Global.asax Application_BeginRequest event. Is it enough? or better do a http module?

UPD
Sub Application_BeginRequest(ByVal sender As Object, ByVal e As EventArgs)
' Fires at the beginning of each request

[code]...

View 1 Replies

Some Basic Clarification On Global.asax?

Feb 8, 2010

I was under the impression till now that Global.asax is used for application level events and it's a common file for all users. Then what does Session_Start event does in this file. If we have to create user session varaibles then Is this the write place to create those? If someone can kindly clear my confusion on this file and it's methods.

View 5 Replies

Application_Error In Global.asax Not Firing?

Oct 8, 2010

I'm trying to handle all my application exceptions inside the global.asax but from some reason it's not firing at all, i never tried to do it before so i guess i'm doing something wrong here...

here is the code inside the default.aspx page that throw the error:

[Code]....

View 6 Replies

MVC :: Getting Server Context In Global.asax.cs?

Apr 19, 2010

I'm using the HttpRunTime.Cache.Add to create a routine that runs every 5 mins to post data out of my app to the main DB, and this works fine. However I also need to import some files from disk in this routine. I have my document directory set up in my web.config as a ~/ relative path and resolve this in normal controller actions using Server.MapPath(string). How can I do this in my Global.asax.cs code -when I try to access it, it throws an error?

View 3 Replies

C# - Server.Transfer In Global.asax?

Dec 29, 2010

I have a custom error handler in the global.asax's Application_Error method, when an error occurs I use the following code to transfer user to the error page:Server.Transfer("/Error/");

However without specifying the actual page name the code above breaks with "Error executing child request for /Error/" exception.So if I use Server.Transfer("/Error/Default.aspx") it works fine with no problems.Also using Response.Redirect("/Error/") works fine too, however we want to keep using Server.Transfer to retain URL displayed in the address bar when the error page is displayed so users can simply refresh the page to retry accessing the original offending URL.Would be grateful if anyone can comment on how to get the Server.Transfer method working without specifying the actual aspx page name.

View 1 Replies







Copyrights 2005-15 www.BigResource.com, All rights reserved