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;
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]
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) }
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?
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...
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?
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.
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]...
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.
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.
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.
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?
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.
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.
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
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.
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:
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?
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.
