Handle Database Look Up Values In Application

Jan 20, 2010

Almost all the applications I worked on involve some look-up values. For example, a lot of times a list of languages ( English, French, etc...) need to be displayed on the WebForm for user to choose.

The common data structure for such look up values include an integer Id and a string as name. Since these look-up values are used so frequently, and they are unlikely to be changed. Most of time, instead of grabbing them from database, I just define a global enum in C# like this

enum Language : int { English = 1, French = 2}

I've been handling look-up values like this for years now. I knew it may not be the best way to handle them. For example, every time a new language is added to the system, somebody needs to remember to update that enum.

View 3 Replies

Similar Messages:

How To Handle Exceptions In A 3-tier Web Application - Specifically Sql Database Exceptions

Jan 26, 2010

I'm building the standard 3-tier ASP.NET web application but I'm struggling as to where to do certain things - specifically handling exceptions.

I've tried to have a look around on the web for some examples but can't find any which go as far as a whole project showing how everything links together.

In my data-tier I'm connecting to SQL Server and doing some stuff. I know I need to catch exceptions that could be raised as a result but I'm not sure where to do it.

From what I've read I should be doing it in the UI tier but in that case I'm not sure how to ensure that the connection to the database is closed. Is anyone able to clarify how to do this? Also if anyone knows as to where I could find an example 3-tier web application that follows best practices that would be great too.

View 4 Replies

How To Handle .NET Application Error That Occurs On Application Start And Transfer

Mar 9, 2010

I know that ASP.NET MVC has error filter attribute to handle specified error type. However, this feature cannot catch any error that occurs when application start. Therefore, I need to add some code to "Application_Error" method for handling this error like the following code.

public void Application_Error(object sender, EventArgs e)
{// At this point we have information about the error
var ctx = HttpContext.Current;
var exception = ctx.Server.GetLastError();

View 1 Replies

How To Handle Null Values

Apr 13, 2010

I want to know how to handle null values....

for eg i hav a datetime field called Completion date which temporarily has a null value and when i display the records using a gridview it displays a default date...how do i get rid of this default date.the completion Date gets entered at a later stage in the application following which the gridview should show this date....but initially it shouldn't show anything

View 3 Replies

Web Forms :: How To Refresh ComboBox Values From Database In Windows Forms Application

Jun 16, 2013

I do have combo box on my page where the items are retrieved from database.

I have an link label which leads to new form to add value for corresponding column in database.

After add the value, when i click refresh on my current page, the values in combo box must be updated. 

 I have used this

 private void button3_Click(object sender, EventArgs e)

View 1 Replies

How To Handle Null Values In Stored Procedure With Pivot

Oct 30, 2010

I am using this stored procedure with pivot.If i dont have data i am getting null with this stored procedure.Can u tell me how to handle null.below query is pivot.


View 1 Replies

VS 2008 How To Handle Null Datetime Values Properly

Oct 25, 2010

I have a class with properties for stuff like FileNumber, OpenedDate, ClosedDate etc.When I Initialise the class I set the datetime variables to Date.MinValue.Then when I populate my textboxes I check if the value of the date variables are Date.Minvalue and I set the textbox text to an empty string.

If(File.OpenedDate = Date.MinValue, String.Empty, File.OpenedDate.ToString("yyyy/MM/dd"))
However whe I try to save the data to my sql server db I get a datetime out of range error. What is the correct way to handle these null values in my date columns?

View 9 Replies

Web Forms :: How To Handle SQL Column With Multiple Comma-delimited Values

Jan 25, 2011

I've inherited an SQL table with a column named "product_codes." It contains 1 or more 4-digit numerals separated by commas (for example, the first record in the table has this in the "product_codes" column:0010,0810

There's a second table containing those product_codes and their corresponding names in a column called "product_name"

I'm trying to set up a FormView that will display an individual record and allow the user to update the record. But when attempting to display a record that has multiple values in the "product_codes" column I get an error, presumably because it can't map the product code to the product name.


View 8 Replies

Forms Data Controls :: How To Handle Null Values In While Loop

Apr 16, 2010

i am unable to handle null values in while .even i tried to handle condition is breaking and coming null value comming inside loop.


View 3 Replies

Migrate Existing Database From Specific Application To New Ms Access Based Application (database)?

Aug 2, 2010

how to migrate an existing database from a specific application to a new Ms Access based application(database)?

View 4 Replies

C# - How To Handle Temporary Files In Application

Jan 6, 2010

Recently I was working on displaying workflow diagram images in our web application. I managed to use the rehosted WF designer and create images on-the-fly on the server, but imagining how large the workflow diagrams can very quickly become, I wanted to give a better user experience by using some ajax control for displaying images that would support zoom & pan functionality.

I happened to come across the website of seadragon, which seems to be just an amazing piece of work that I could use. There is just one disadvantage - in order to use their library for generating deep zoom versions of images I have to use the file structure on a server. Because of the temporary nature of the images I am using (workflow diagrams with progress indicators), it is important to not only be able to create such images but also to get rid of them after some time.

Now the question is how can I best ensure that the temporary image files and the folder hierarchy can be created on a server (ASP.NET web app), and later cleaned up. I was thinking of using the cache functionality and by the expiration of the cache item delete the corresponding image folder hierarchy, or simply in the Application_Start and Application_End of Global.asax delete the content of the whole temporary folder, but I'm not really sure whether this is a good idea and whether there are some security restrictions or file-system-related troubles. What do you think ?

View 3 Replies

ADO.NET :: Linq To SQL - Handle Concurrency In Application

Aug 10, 2010

I am trying to handle concurrency in my application. Basically if user A has a support ticket open which currently has a status of 'Active' and user 'B' opens the same ticket and closes it (changing its status to closed), I would expect a confict execepton to be thown when user 'A' tries to close the support ticket. For some reason this is not happening. I have checked that Update check is set to 'Always' in the dbml file. Here is an exerpt of my code. // Update 'Active' lead to 'Close'


View 2 Replies

Php - Application To Handle Form Approval?

May 20, 2010

Hopefully this is the right place for this question. I have done a fair amount of research and yet to find anything that matches what I want. What I'm envisioning is the following. Let me know if any of you know of a program that will do what I want. Also it must be web-based anom user -> fills out form -> email gets sent to admin saying xyz has filled out form abc with links to approve/disapprove request.

admin can also login and edit form and resent results to original submitter. Also once the admin approves/disapproves request the original submitter gets an approve/disapprove email.

and you can search by date submitted, specific project/form, status of request(submitted, approved, disapproved). all on where I could find this? I started to look into drupal with workflows and actions but it just doesn't flow right for this

View 1 Replies

Handle Application Shutdown In Quartz.Net?

Sep 26, 2010

I have used Quartz.Net for queuing and sending emails from my application. I don't know how each scheduled job responds to application instance stopping, pausing or shutting down. The IJob interface has no method that can notify a running job about these events.My question is how can I handle these cases when they occur so that the job can exit while leaving the application and the data in a stable state?

View 1 Replies

C# - Handle Authentication / Authorization In A Web Application?

Feb 25, 2011

I am building an intranet website. And I am still unsure of how to implement the security of the website. I am using ASP.NET MVC 3.

Anyone in the company can access the website. It is a recognition system where you can nominate an employee for an award. Currently I am not using any type of authentication. I have a roles table that contains roles and an association table that specifies which user contain what roles, these roles are mainly administrator-type roles. If a user does belong in these roles then he/she can still access various parts of the website.

Would I need to use the built-in membership for this? Or would I need to create a custom membership for this? We don't use a login page. If the user does not have roles to access a view then he/she is redirected to another page.

We use IIS to do our authentication. Is this the same as Windows authentication? I have the roles table used for authorisation.

View 2 Replies

Forms Data Controls :: Handle Null Values Being Assigned To A Calendar Control?

Nov 13, 2010

I've got a detailsview control on a page. The table that it interacts with has a DateTime column in it. This column is nullable, and a lot of the records have null for that value. In the EditItemTemplate I've got a calendar control. When I try to put the DetailsView into edit mode, I get the following error message:

System.InvalidCastException was unhandled by user code
Message=Specified cast is not valid.
at ASP.entries_aspx.__DataBinding__control44(Object sender, EventArgs e) in c:inetpubwwwrootMediaLibraryEntries.aspx:line 103
at System.Web.UI.Control.DataBind(Boolean raiseOnDataBinding)
at System.Web.UI.Control.DataBindChildren()

I am convinced that the problem is the null values in the DateTime column of the table. I've done some web searches on this, and some have suggested placing some dummy values into that column, but that seems more like a kludge, rather than a solution. How do I keep nulls in the table, and yet not have that preceeding error come up when a user tries to edit the selected record?

View 1 Replies

Data Controls :: Handle NULL Values When Converting DataTable Cell Value To String In C#?

Dec 23, 2015

How to allow null value on my program?

for below statement, "WARNING_TYPE" IS NULL..

but when I run, it promp me error..what are the correct statement should i write. tq all

l_Connection.ConnectionString = constr
l_Command.Connection = l_Connection
l_Command.CommandType = CommandType.Text


View 1 Replies

Data Controls :: Handle Blank / Spaces And NULL Values When Exporting GridView To CSV?

Nov 22, 2015


how do you handle null data on gridview? and also the white spaces, it seems that the white spaces are converting to " " 

 Note: i can't replace the   because i have 1 column thats in html form. 

View 1 Replies

C# - How To Handle NHibernate Sessions In WebForms Application

Jul 16, 2010

I see there are 2 possible scenarios as to the session handling:

Open one single ISession per request. Open it at request start and close it at request end.Open one ISession per conceptual "unit of work". Many sessions are created for a request.

The approach #1 is the one I'm doing now. I'm a little bit worried about it because, although it works, it's a little bit difficult to debug. For instance, I have an object not being saved (even though I ordered it to) and I'm having trouble debugging since there's a LOT of things happening during a complete request life-cycle.

The approach #2 seems to be the standard best-practice (not sure about ASP.NET) and I'm sure it's pretty easier to debug. The problem I see is about inter-session communication. For instance: My Page class holds a reference to the User, which is a persistent object. Many of the operations receive the user as parameter. As the user belongs to a different session, I can't pass it as a parameter.

I'm biased to #2, but I don't know if it's the best practice, nor how to deal with cross-session object.

View 4 Replies

C# - How To Handle Application Start Event In Module

Jun 25, 2010

I am writing an asp.net HTTP module which needs to read configuration data once from a local file (say config.xml stored in application root directory) and then based on configuration perform some processing on incoming requests.

Since there is no Application_Start/Application_init hooking available in Asp.NET modules, what would be the best way to handle the scenario. I am trying to avoid reading configuration file each time a request comes. Ideally, I want to read the config file when application starts.

I need to code this in http module only and do not want to use Global.asax

View 5 Replies

Architecture :: Handle Transactions In 3 Tier Web Application?

Jul 2, 2010

I' am trying to write a aplication using a 3 Tier Model

Data Access Layer <--> Business Logic Layer <--> Presentation Layer

But now i am facing a problem, i need to Handle Transactions i already found a interesting article

[URL] but i have some doubts.

For example when i need to iterate to a Grid in the presentation Layer how will i Use the Transactions??


View 2 Replies

Handle Errors At Application Or Server Level?

Sep 28, 2010

When setting up asp.net error handlers for things like 404 errors, it is more 'efficient' to do this in IIS, or handle it in the Global.asax Application_Error event? I know the latter will be called, and I want to log this information in a database, but should I then just return without any redirect and let IIS do the redirect, or would it be better to do a response.redirect inside application_error once we've logged it?

View 1 Replies

Web Forms :: Application BeginRequest Event Raised Too Often To Handle It?

May 6, 2010

I'm developing IP Blacklisting HttpModule in asp .net application and I found one very annoying thing. Each request to the asp net page generates tens of "subrequests" to application resources like images, client side scripts, styles etc.

Now in my application I'm listing to the BeginRequest event and when it is fired I'm loading Dictionary with blacklisted IPs from application cache and check user's IP against it. I've made a simple log of what is actualy happening during each page view, here are the results:


As you see, one request to Login page causes BeginRequest to fire 18 times, there is 18 dictionary loads, 18 lookups etc. That's not the way I want it to be.

Is there any other event that is raised only once per each request? Where do you place the blacklisting mechanism in your applications? I know I can do it through ISAPI filter, but the catch is, this site is on the shared hosting and I'm not sure I can use it on their IIS. Also I'm not sure if ISAPI filter can access some piece of cache with this blacklist (I don't want to load it from DB on each request, that's obvious).

View 3 Replies

Installation :: IIS Settings To Handle Multiple Users And Application Pool?

Jun 9, 2010

In our IIS (v 6.0) there is one classic ASP app deployed, which has around 35 concurrent users. Now, a new ASP.NET(3.5) app needs to be deployed on the same server which will have its own 50 concurrent users. In this scenario should we create a Application Pool for this new .net app? What are other recommendations for the IIS settings in future?

View 3 Replies

Web Forms :: How To Handle Database Error In C#

Jul 16, 2010

i am working on a website but theres is no error traping or error handling

now i want to implement the error handler,how can i do and what is best way to implement and most important i want to write if possible global error traping so i can write less code and more effective

View 3 Replies

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