suggestions

Hi, all:
i am currently working on a survey web site which is based on ASP.NET. Every
survey is over 100 questions and using two different languages (for example,
english and chinese), and 15 questions per page by request, also I need to s
tore
answers to database.
Here is my question, is there any way I can pull the "save to Database
function/module" out and save it to a standalone function/module so both
language web pages can re-use it without put it on every single page? and ho
w?
Thanks in advance.I'm not sure I understand your question. If your database is properly
designed and your application is well architectured, from the little I do
understand, you should be able to re-use the save functionality.
How are you doing it now and what problems are you running into?
karl
MY ASP.Net tutorials
http://www.openmymind.net/
"Jason" <jason@.hotmail.com> wrote in message
news:t1buj01kue9g1d077hif2md9rc8m24murr@.
4ax.com...
> Hi, all:
> i am currently working on a survey web site which is based on ASP.NET.
Every
> survey is over 100 questions and using two different languages (for
example,
> english and chinese), and 15 questions per page by request, also I need to
store
> answers to database.
> Here is my question, is there any way I can pull the "save to Database
> function/module" out and save it to a standalone function/module so both
> language web pages can re-use it without put it on every single page? and
how?
> Thanks in advance.
Here is what I did so far:
Survey1-EN.aspx
Survey1-EN.aspx.cs
Survey2-EN.aspx
Survey2-EN.aspx.cs
Survey1-CN.aspx
Survey1-CN.aspx.cs
Survey2-CN.aspx
Survey2-CN.aspx.cs
the only difference between Survey1-EN.aspx and Survey1-CN.aspx is user will
see
different language(English or Chinese) in each page. And I have a class call
ed
saveToDB() in each *.aspx.cs, so how can I let each *.aspx.cs call the
standalone procedure so I do not need to have the saveToDB() in each *.aspx.
cs?
Thanks.
ASP.NET newbie!
On Wed, 8 Sep 2004 13:37:09 -0400, "Karl" <karl REMOVE @. REMOVE openmymind
REMOVEMETOO . ANDME net> wrote:

>I'm not sure I understand your question. If your database is properly
>designed and your application is well architectured, from the little I do
>understand, you should be able to re-use the save functionality.
>How are you doing it now and what problems are you running into?
>karl
I've written a two part tutorial on this sort of thing:
http://openmymind.net/localization/index.html
http://openmymind.net/localization/index2.html
You should find it useful. It'll help you onl have 1 page for X languages
and give you some database design ideas.
Karl
MY ASP.Net tutorials
http://www.openmymind.net/
"J" <j@.NoSpam.org> wrote in message
news:9ghuj0ltoq4olrsd965ahsb08noq40kr4s@.
4ax.com...
> Here is what I did so far:
> Survey1-EN.aspx
> Survey1-EN.aspx.cs
> Survey2-EN.aspx
> Survey2-EN.aspx.cs
> Survey1-CN.aspx
> Survey1-CN.aspx.cs
> Survey2-CN.aspx
> Survey2-CN.aspx.cs
> the only difference between Survey1-EN.aspx and Survey1-CN.aspx is user
will see
> different language(English or Chinese) in each page. And I have a class
called
> saveToDB() in each *.aspx.cs, so how can I let each *.aspx.cs call the
> standalone procedure so I do not need to have the saveToDB() in each
*.aspx.cs?
> Thanks.
> ASP.NET newbie!
>
> On Wed, 8 Sep 2004 13:37:09 -0400, "Karl" <karl REMOVE @. REMOVE openmymind
> REMOVEMETOO . ANDME net> wrote:
>
>

suggestions

Hi, all:
i am currently working on a survey web site which is based on ASP.NET. Every
survey is over 100 questions and using two different languages (for example,
english and chinese), and 15 questions per page by request, also I need to store
answers to database.
Here is my question, is there any way I can pull the "save to Database
function/module" out and save it to a standalone function/module so both
language web pages can re-use it without put it on every single page? and how?
Thanks in advance.I'm not sure I understand your question. If your database is properly
designed and your application is well architectured, from the little I do
understand, you should be able to re-use the save functionality.

How are you doing it now and what problems are you running into?

karl

--
MY ASP.Net tutorials
http://www.openmymind.net/

"Jason" <jason@.hotmail.com> wrote in message
news:t1buj01kue9g1d077hif2md9rc8m24murr@.4ax.com...
> Hi, all:
> i am currently working on a survey web site which is based on ASP.NET.
Every
> survey is over 100 questions and using two different languages (for
example,
> english and chinese), and 15 questions per page by request, also I need to
store
> answers to database.
> Here is my question, is there any way I can pull the "save to Database
> function/module" out and save it to a standalone function/module so both
> language web pages can re-use it without put it on every single page? and
how?
> Thanks in advance.
Here is what I did so far:
Survey1-EN.aspx
Survey1-EN.aspx.cs
Survey2-EN.aspx
Survey2-EN.aspx.cs

Survey1-CN.aspx
Survey1-CN.aspx.cs
Survey2-CN.aspx
Survey2-CN.aspx.cs

the only difference between Survey1-EN.aspx and Survey1-CN.aspx is user will see
different language(English or Chinese) in each page. And I have a class called
saveToDB() in each *.aspx.cs, so how can I let each *.aspx.cs call the
standalone procedure so I do not need to have the saveToDB() in each *.aspx.cs?

Thanks.
ASP.NET newbie!

On Wed, 8 Sep 2004 13:37:09 -0400, "Karl" <karl REMOVE @. REMOVE openmymind
REMOVEMETOO . ANDME net> wrote:

>I'm not sure I understand your question. If your database is properly
>designed and your application is well architectured, from the little I do
>understand, you should be able to re-use the save functionality.
>How are you doing it now and what problems are you running into?
>karl
I've written a two part tutorial on this sort of thing:
http://openmymind.net/localization/index.html
http://openmymind.net/localization/index2.html

You should find it useful. It'll help you onl have 1 page for X languages
and give you some database design ideas.

Karl

--
MY ASP.Net tutorials
http://www.openmymind.net/

"J" <j@.NoSpam.org> wrote in message
news:9ghuj0ltoq4olrsd965ahsb08noq40kr4s@.4ax.com...
> Here is what I did so far:
> Survey1-EN.aspx
> Survey1-EN.aspx.cs
> Survey2-EN.aspx
> Survey2-EN.aspx.cs
> Survey1-CN.aspx
> Survey1-CN.aspx.cs
> Survey2-CN.aspx
> Survey2-CN.aspx.cs
> the only difference between Survey1-EN.aspx and Survey1-CN.aspx is user
will see
> different language(English or Chinese) in each page. And I have a class
called
> saveToDB() in each *.aspx.cs, so how can I let each *.aspx.cs call the
> standalone procedure so I do not need to have the saveToDB() in each
*.aspx.cs?
> Thanks.
> ASP.NET newbie!
>
> On Wed, 8 Sep 2004 13:37:09 -0400, "Karl" <karl REMOVE @. REMOVE openmymind
> REMOVEMETOO . ANDME net> wrote:
> >I'm not sure I understand your question. If your database is properly
> >designed and your application is well architectured, from the little I do
> >understand, you should be able to re-use the save functionality.
> >How are you doing it now and what problems are you running into?
> >karl

survey

How can i design a public survey in asp.net writing with c#??Hi !!

Can you expand more and explain what you want it to include or how the application should behave? (more explanation please, i might be able to help)
There is a free survey product for ASP.NET:NSurvey.

FYI: Your question is so broad its not much different than asking "how do you write a Word Processor"? You need a lot of knowledge and programming skills to build complete solutions like this. Its the kind of thing you generally hire experts to handle.
I will prepare it in asp.net with c# first..It will include 3 parts..Questions, answers and answer's options...How can i model these parts in database first?Some people told me to use normalization...but i dont know how??please help me...
It genuinely sounds like you need an education in database design.

asp.net forums is not hear as a classroom to teach you. We cannot start writing entire courses of subjects. We cannot guess what you know so we can tune our tutorial to you.

If you cannot find a course, seek out books on the subject. Also search the web for articles. After all, there are people who have written educational articles on many subjects. (Please don't ask me to direct you to the articles. I expect you to search the web because that's how I do find things on the web.)

asp.net forums can give you short answers that move you forward. If I told you "normalization is a way to reduce the size of records by extracting their common parts into a new table", how far will that get you with your current level of inexperience?

People have high paying jobs creating databases and software applications. Frankly, its a little frustrating for others to demand we mentor in these forums instead of getting a real education.

Going back to my original response: there is a FREE survey package available for ASP.NET: nsurvey.

Survey Example Code

Just thought I'd ask so I won't be reinventing the wheel so to speak:

I wanted to know if any of you have some example code or a good link to a survey?

Many thanks in advance...I've got an entire survey web app that I've created. I will be posting soon, although, e-mail me offline at jgaylord@.aspalliance.com and I might be able to help you sooner.

Jason
Thank you for your expeditious response! I will certainly contact you!

Survey dynamic ASP server controls generation plz

How can i add dynamic survey questioners with (Text box, Check box and combo boxs). i am using ASP.NET 2.0,SQL2005.

If you have any good articles are ideas please share.

Thanks in advance

DK

Hi DK,

There are ASP.NET survey/poll controls. You can search them yourself.

http://www.codeproject.com/useritems/Site_Poll_Control.asp

But I'm not sure if it is dynamic.

Survey Module?

Helen,

There is a Survey Module in DotNetNuke: -

http://www.dotnetnuke.com/Default.aspx?tabid=467

Hth,
Phil winstanley
Microsoft ASP.NET MVP
http://www.myservicescentral.comThanks Paul, perfect.

I'm a winforms developer, new to asp.net. This dotnetnuke looks like a
goldmine. Are there any other must-see resources I should know about? The
Rainbow portal looks very useful too. And IBuySpy of course.

Is DotNetNuke the resource of choice for ASP.Net developers?

h

"Phil Winstanley [Microsoft MVP ASP.NET]" <phil@.winstanley.name> wrote in
message news:cb4nir$kjr@.odbk17.prod.google.com...
> Helen,
> There is a Survey Module in DotNetNuke: -
> http://www.dotnetnuke.com/Default.aspx?tabid=467
> Hth,
> Phil winstanley
> Microsoft ASP.NET MVP
> http://www.myservicescentral.com
there are several starter kits at www.asp.net

"Helen B" <helen@.nospam.com> wrote in message
news:exdSwW3VEHA.2928@.tk2msftngp13.phx.gbl...
> Thanks Paul, perfect.
> I'm a winforms developer, new to asp.net. This dotnetnuke looks like a
> goldmine. Are there any other must-see resources I should know about? The
> Rainbow portal looks very useful too. And IBuySpy of course.
> Is DotNetNuke the resource of choice for ASP.Net developers?
> h
>
> "Phil Winstanley [Microsoft MVP ASP.NET]" <phil@.winstanley.name> wrote in
> message news:cb4nir$kjr@.odbk17.prod.google.com...
> > Helen,
> > There is a Survey Module in DotNetNuke: -
> > http://www.dotnetnuke.com/Default.aspx?tabid=467
> > Hth,
> > Phil winstanley
> > Microsoft ASP.NET MVP
> > http://www.myservicescentral.com

Survey Module?

Hi
Anyone know where I can find a sample ASP.Net survey module?
Do any of the starter kits or community sites have one?
Thanks very much
h xHelen,
There is a Survey Module in DotNetNuke: -
http://www.dotnetnuke.com/Default.aspx?tabid=467
Hth,
Phil winstanley
Microsoft ASP.NET MVP
http://www.myservicescentral.com
Thanks Paul, perfect.
I'm a winforms developer, new to asp.net. This dotnetnuke looks like a
goldmine. Are there any other must-see resources I should know about? The
Rainbow portal looks very useful too. And IBuySpy of course.
Is DotNetNuke the resource of choice for ASP.Net developers?
h
"Phil Winstanley [Microsoft MVP ASP.NET]" <phil@.winstanley.name> wrote in
message news:cb4nir$kjr@.odbk17.prod.google.com...
> Helen,
> There is a Survey Module in DotNetNuke: -
> http://www.dotnetnuke.com/Default.aspx?tabid=467
> Hth,
> Phil winstanley
> Microsoft ASP.NET MVP
> http://www.myservicescentral.com
>
there are several starter kits at www.asp.net
"Helen B" <helen@.nospam.com> wrote in message
news:exdSwW3VEHA.2928@.tk2msftngp13.phx.gbl...
> Thanks Paul, perfect.
> I'm a winforms developer, new to asp.net. This dotnetnuke looks like a
> goldmine. Are there any other must-see resources I should know about? The
> Rainbow portal looks very useful too. And IBuySpy of course.
> Is DotNetNuke the resource of choice for ASP.Net developers?
> h
>
> "Phil Winstanley [Microsoft MVP ASP.NET]" <phil@.winstanley.name> wrote in
> message news:cb4nir$kjr@.odbk17.prod.google.com...
>

survey location in mssql server

hi everyone

When I add a Survey the information goes to the database server>table>Lists.

tp_Fields holds the question and the choices
tp_ItemCount gives how many users response to that

but i cant find the field where our selected answer to that survey resides in the database server.

Can any one please tell me to which field or table the User's selected answer goes?

Thanks

anshul

What's the project you're building? Any website refers to the template? Need to look at related code.

Survey form - is it possilbe?

I am working for a small IT firm and we want to send our clients surveys. I have been thrown in to the development of this without alot of expereince in ASP so I thought I would run this by the forum first off.

What I would like to do is:

1) Send the client a link ithat will direct them to a web survey and pre-fill in info such as technicial, date, and call type.

2) Have them complete the survey and hit submit to return their info (this part I know how to do!!)

Link Structure:
"http://domain.com/surveyform & date & technician &calltype"

Is this even possible to do with ASP and if so do you have any suggestions.

Thanks very much!!Sure it is very possible using asp or asp.net. What do you have questions about?
This is very possible.

Use the query string like so:
http://someplace.com/survey.aspx?Date=blah&Technician=blahblah&CallType=blahblah

That will send:
Date that has a value of blah
Technician that has a value of blahblah
CallType that has a value of blahblah

to the survey.aspx page. To access those values, you use the NameValue collection object to hold them and you get the values from the Request.QueryString() method in the page load event. Use those values to fill your controls. Make sure you check for IsPostback.
I'm trying what you say but it won't work -- where am I going wrong? It directs me to the page but the first name textbox is not filled with "testname".

My link: http://www.britec.com/survey.asp?fname=testname

My code:
<%
dim fname
fname=Request.QueryString("fname")
%>

<html>
<head>
<title>First Name</title>
</head>
<body>

<form method="get" action="survey.asp">
First Name: <input type="text" name="fname">
<br />
Last Name: <input type="text" name="lname">
<br /><br />
<input type="submit" value="Submit">
</form>
</body>

</html>
Are you using VS.Net? If you are, your first problem is you are using asp not asp.net.
I am trying to use just ASP.
Ok, you are in the wrong forum...sorry for my replies, I thought you were talking about asp.net.

The querystring principles are the same, and I think you can use the Request object the same, but you would have to verify that because I have used little asp.
Go here and ask the question:
http://www.vbforums.com/forumdisplay.php?s=&forumid=4

Survey results: How do I retrieve and view it ?

Hi all,

I have done a small prototype survey with just two questions.. using webforms and all..

The QUESTION is : How do I retrieve and view it after I gather many people have taken the survey ?

For eg user choose a radio button M for male ?

=> How do I see how many males are surveyed?

Kayln87

Do you have a database in which you save results of the survey?

Hi Kipo,

No i dun have a database from which my questions and answers can be pulled out from.

I realised its possible to view back retrieve and view past results for a quiz engine but mine's a survey. I do not want the people who are being surveyed to see the results.

How do I consolidate all the data for each question and display it to the adminstrator. A typical result, I as the adminstrator will want to know is stimulated as below

Out of 2000 surveyed, How many are Male or Female ? <= I wish to retrieve and view this result , given one of the question is

What is your gender?

radiobutton M

radiobutton F

So, basically, you have Radio Button controls and you want to know how many times users clicked on "male"? It's impossible to achieve your goal without some sort of database (it doesn't have to be SQL database, you can use Access database, XML file, or even ordinary txt file).

Hi Kipo and anyone who can help on this..

Yes. I think I understand that I'll need to implement a database, but how do I go about doing it?

Is it possible for you to list down the steps i need to take to implement?

1. implementation of survey question. <= ie to say I pull my questions from a database? => how to implement database management on survey questions... they are quite long i feel, not like account figures like customerID as such.

2. How to I retrieve the information, do I need to set up views as in admin login then I can see the data?

Kayln87

Best option is store the data in a database. If you dont have a database, you can store it even in a .txt file also..

Hi

Are your survey questions going to change over time? If yes, You have to store it in a database. Otherwise, if it is for a single time use, implement it in front end itself. For each answer, try to make a column in the database: Eg; for male/female Question you can create a boolean column or a varchar column. For a question of number of children, you can create a column of numeric type. It goes on like this,

The basic tables you need to use are

1. A user management table( user name, password etc) -- if you want to keep track of the names of the users of the survey and who has answered what.

2. A survey table (user id column, each answer columns)

Thats all I feel for a small scale application

Otherwise, if it is for a single time use, implement it in front end itself. For each answer, try to make a column in the database: Eg; for male/female Question you can create a boolean column or a varchar column. For a question of number of children, you can create a column of numeric type.

Hidineshspillai and anyone who can help on this,

My survey is for a single time use, I do not understand when you say implement it infront end itself? does it mean juz put some tables and radio buttons and label boxes?

How do you create a boolean column or varchar column?

My survey is pretty long which questions like age group

sex

profession

nationality

no of pple in household

ages of people in household ... and so on

as you can see I dun think I can implement a database as i might be fixing the no of columns for my questions's options... as the no of choices vary from different questions.

Thank You

Kayln87

Helpp ANYONE ???

Hi Kaylan87,

I have two questions to you about your application

1.Is the survey application is meant only for some specific users(whom you know) or any one(without revealing their identity) can fill it?

If your application falls in the first case(specific users) you have to store the user details in a database(it can be sql server,oracle or even MS access).Again you have to create a separate page for authentication of the user. The user can access the survey page only after a successful anuthentication

2. How many times can one attend the survey?

If you are not targetting a specic group of people, you need not give a authenication page and a user table(in the database)

>>>>" I do not understand when you say implement it infront end itself? does it mean juz put some tables and radio buttons and label boxes?
What I meant by implementing in front end is you create a web page for the survey, put each of your questions in each labels, create a set of input controls like

sex : Radio Button, (for male and female)

profession (If you have some Idea about the user's Profession, you can show a set of occupations in a drop down list, otherwise put a textbox)

nationality (drop down List, load all countries in it)

no of pple in household (again dropdown List)

ages of people in household ()----> I think this is the area which disturbs you, since the number of answers will vary case to case. This can be tackled by creating a separate table in the database- in which the userid/SurveyID , questionID(those questions which may have multiple number of answers have to be stored in the database with an ID through which you can uniquely identify the question) and answer.

>>>>>>>>>> How do you create a boolean column or varchar column

I was referring to database column, not in asp.net

Hope this information didnt confuse you,

Thanks,

Dinesh

Hi there,

by far I think you got what I mean to set out and do. However my problem here is that i do not understand how I can save all these users' inputs and view it when I am done with the collection of survey results. iesaving the user inputs into a database i think

Is the survey application is meant only for some specific users(whom you know) or any one(without revealing their identity) can fill it?

Ans:It is for any one(without revealing their identity) to fill it.

THANKS!!

Kayln

Hi Kaylan,

Which database is available there? Oracle/SQL Server/ MS Access ?????

Thanks,

Dinesh

Hi Dinesh,

I have SQL express edition 2005 installed. By the way my name is Kayln!! hahaha

Thank you !

Kayln

Hi Kayln,

Sorry for mispronouncing your name :.

Here is an article which tells about connecting to sql express:

http://msdn2.microsoft.com/en-us/library/ms228037.aspx

Thanks,

Dinesh

Survey Sample (hopefully this copy of my previous post will allow replies!)

Hi

I downloaded the Survey Sample and Survey Admin Sample from MSDN's Code Centre two years ago and have been using it regularly since with Windows 2000 Server, IIS 5.0 and the .NET Framework 1.0. However, I am unable to port the Survey solution to a new production Web server, running Windows Server 2003, IIS 6.0 and the .NET Framework 1.1, due to a error when setting the Nested property of a DataRelation to true in the AdjustQuestionPrimaryKey() sub-routine ("A column named 'Answer' already belongs to this DataTable: cannot set a nested table name to the same name"). There are a few reports of a similar issue elsewhere on the Web but I have yet to find any that refer to a satisfactory resolution. Given that the Survey and Survey Admin samples appear to have disappeared relatively recently from MSDN, I was wondering whether anyone can offer an explanation for this occurrence or, alternatively (and preferably!), has a solution to the problem. I should add that I have yet to apply service pack 1 for the .NET Framework 1.1 but did not notice any documented connection between the issues that it addresses and the difficulty I have reported.

Regards

GazHi Gaz,

Yeah, I had it removed as too many people were having problems with it, and I didn't have the time to go through the code and fix all of the migration issues. There was one fix I did that may work for you, however. In the response.xsd file, change the definition of Answer from:

<xs:element name="Answer" minOccurs="0" maxOccurs="unbounded">
<xs:complexType>
<xs:attribute name="Id" form="unqualified" type="xs:int" />
<xs:attribute name="Text" form="unqualified" type="xs:string" />
</xs:complexType>
</xs:element
to a complex type with a different name. Actually, here's the whole file:
<?xml version="1.0" ?>
<xs:schema id="NewDataSet" targetNamespace="http://tempuri.org/SampleResponse.xsd"
xmlns:mstns="http://tempuri.org/SampleResponse.xsd"
xmlns="http://tempuri.org/SampleResponse.xsd"
xmlns:xs="http://www.w3.org/2001/XMLSchema"
xmlns:msdata="urn:schemas-microsoft-com:xml-msdata"
attributeFormDefault="unqualified" elementFormDefault="unqualified">
<xs:complexType name="AnswerType">
<xs:attribute name="Id" form="unqualified" type="xs:int" />
<xs:attribute name="Text" form="unqualified" type="xs:string" />
</xs:complexType>
<xs:element name="SurveyResponse">
<xs:complexType>
<xs:sequence>
<xs:element name="Question" minOccurs="0" maxOccurs="unbounded">
<xs:complexType>
<xs:sequence>
<xs:element name="Answer" minOccurs="0" maxOccurs="unbounded" type="AnswerType" />
</xs:sequence>
<xs:attribute name="Id" form="unqualified" type="xs:int" />
</xs:complexType>
</xs:element>
</xs:sequence>
<xs:attribute name="Id" form="unqualified" type="xs:string" />
</xs:complexType>
<xs:key name="SurveyResponseQuestionKey" msdata:PrimaryKey="true">
<xs:selector xpath=".//mstns:Question" />
<xs:field xpath="@.Id" />
</xs:key>
<xs:key name="SurveyResponseAnswerKey" msdata:PrimaryKey="true">
<xs:selector xpath=".//mstns:Answer" />
<xs:field xpath="@.Id" />
</xs:key>
<xs:key name="SurveyResponseKey1" msdata:PrimaryKey="true">
<xs:selector xpath=".//Question" />
<xs:field xpath="@.Id" />
</xs:key>
<xs:key name="SurveyResponseKey2" msdata:PrimaryKey="true">
<xs:selector xpath=".//Answer" />
<xs:field xpath="@.Id" />
</xs:key>
</xs:element>
<xs:element name="BaseResponseDataSet" msdata:IsDataSet="true" msdata:EnforceConstraints="False">
<xs:complexType>
<xs:choice maxOccurs="unbounded">
<xs:element ref="SurveyResponse" />
</xs:choice>
</xs:complexType>
</xs:element>
</xs:schema
Alternately, you might want to look at nSurvey, which is a full featured survey application.

Survey System with SOA?

Can anyone tell me how to implement a simple survey system in terms of SOA?

Lets say:

We have a website, where user logins in and takes the survey. Results of survey are stored into Database. once Survey is done, user sees a thank you page/

I am trying make system very simple here, so one can explain me how to implement SOA. We have lot more complecated system to implement.

I just need to see how to implement SOA.

Any other sample or example of complete SOA will be helpful.

Thanks,No body can help me out with small sample application with SOA?

I don't need anyone to design Survey System with SOA, but any simple small app with SOA example will be helpful.

Thanks

SURVEY: How are you doing Global Error Handling in ASP.NET

Best I can tell, there are three basic ways you can deal with global
error handling in ASP.NET. Namely:

1. Derive all your pages from a custom Page class, and override
OnError()

2. Specify a custom 500 handler in Web.Config

3. Specify a custom 500 handler in IIS

and I guess you could add:

4. Let them fall through & spit out ugly error messages

I'm curious to see how people are doing it in the real world.
Personally, I've always used option #1, as it seems to offer the most
flexibility, and I'm already using custom Page objects, so it's no
extra work.

I'm asking this because we're getting close to a public BETA release
of Regressor.NET, and am considering adding support for cases 2 and
3. Before I commit the resources though, I'd like to get a feel for
how many people would benefit from it.

I look forward to seeing what people have to say. Thanks for the
help!

Jason Kester
Automated Crash Reporting and Regression Testing for ASP.NET
http://www.regressor.net/
ps. If anybody is interested in becoming a Beta tester for
Regressor.NET, let me know!Jason Kester schrieb:

Quote:

Originally Posted by

Best I can tell, there are three basic ways you can deal with global
error handling in ASP.NET. Namely:
>
1. Derive all your pages from a custom Page class, and override
OnError()
>
2. Specify a custom 500 handler in Web.Config
>
3. Specify a custom 500 handler in IIS
>
and I guess you could add:
>
4. Let them fall through & spit out ugly error messages

5. Use global.asax to catch errors

greets,
steve

--
Stefan Kalcher

Programming's just like sex, one mistake, you support it for life.
On Mar 12, 1:29 am, "Jason Kester" <jasonkes...@dotnet.itags.org.gmail.comwrote:

Quote:

Originally Posted by

Best I can tell, there are three basic ways you can deal with global
error handling in ASP.NET. Namely:
>
1. Derive all your pages from a custom Page class, and override
OnError()
>
2. Specify a custom 500 handler in Web.Config
>
3. Specify a custom 500 handler in IIS
>
and I guess you could add:
>
4. Let them fall through & spit out ugly error messages
>
I'm curious to see how people are doing it in the real world.
Personally, I've always used option #1, as it seems to offer the most
flexibility, and I'm already using custom Page objects, so it's no
extra work.
>
I'm asking this because we're getting close to a public BETA release
of Regressor.NET, and am considering adding support for cases 2 and
3. Before I commit the resources though, I'd like to get a feel for
how many people would benefit from it.
>
I look forward to seeing what people have to say. Thanks for the
help!
>
Jason Kester
Automated Crash Reporting and Regression Testing for ASP.NEThttp://www.regressor.net/
>
ps. If anybody is interested in becoming a Beta tester for
Regressor.NET, let me know!

In my application, I do the following:

1.) All of my Web forms derive from a base Page class. OnError is
overridden to handle errors there.

2.) I also handle exceptions in Global.asax, in the event that I've
missed something.

3.) Wherever the default handlers in my base class and/or Global.asax
aren't appropriate, I implement suitable exception handling.

4.) The application has a custom web page, which is itself an aspx
page. Some might have a tough time with that design, but it's
*extremely* stable, and doesn't do anything subject to failure.

5.) Every exception is logged to the database (if possible) and to the
Windows event log.

Yeah. I take 'em very seriously.
I'm also a big fan of the custom Page idea. And I agree that logging
everything is important (that's why we wrote Regressor.NET!) It's
amazing how much you find out about your application when every single
exception gets logged.

Curious though, how many exceptions are you really seeing fall through
to Global.asax? I've seen a few posts on this thread from people that
are using Global.asax as a backup, but personally I've never had a
problem with the overriden OnError in my custom page classes. At
least I've never seen anything fall through in person, but then I
guess I'd never know if anything were slipping through the cracks...

Mike, do you forward crash reports directly to your bug tracking
software?

Jason Kester
Automated Crash Reporting and Regression Testing for ASP.NET
http://www.regressor.net/
On Mar 12, 11:04 am, "Mike Hofer" <kchighl...@dotnet.itags.org.gmail.comwrote:

Quote:

Originally Posted by

In my application, I do the following:
>
1.) All of my Web forms derive from a base Page class. OnError is
overridden to handle errors there.
>
2.) I also handle exceptions in Global.asax, in the event that I've
missed something.
>
3.) Wherever the default handlers in my base class and/or Global.asax
aren't appropriate, I implement suitable exception handling.
>
4.) The application has a custom web page, which is itself an aspx
page. Some might have a tough time with that design, but it's
*extremely* stable, and doesn't do anything subject to failure.
>
5.) Every exception is logged to the database (if possible) and to the
Windows event log.
>
Yeah. I take 'em very seriously.- Hide quoted text -
>
- Show quoted text -

On Mar 12, 3:04 pm, "Jason Kester" <jasonkes...@dotnet.itags.org.gmail.comwrote:

Quote:

Originally Posted by

I'm also a big fan of the custom Page idea. And I agree that logging
everything is important (that's why we wrote Regressor.NET!) It's
amazing how much you find out about your application when every single
exception gets logged.
>
Curious though, how many exceptions are you really seeing fall through
to Global.asax? I've seen a few posts on this thread from people that
are using Global.asax as a backup, but personally I've never had a
problem with the overriden OnError in my custom page classes. At
least I've never seen anything fall through in person, but then I
guess I'd never know if anything were slipping through the cracks...
>
Mike, do you forward crash reports directly to your bug tracking
software?
>
Jason Kester
Automated Crash Reporting and Regression Testing for ASP.NEThttp://www.regressor.net/
>
On Mar 12, 11:04 am, "Mike Hofer" <kchighl...@dotnet.itags.org.gmail.comwrote:
>
>
>

Quote:

Originally Posted by

In my application, I do the following:

>

Quote:

Originally Posted by

1.) All of my Web forms derive from a base Page class. OnError is
overridden to handle errors there.

>

Quote:

Originally Posted by

2.) I also handle exceptions in Global.asax, in the event that I've
missed something.

>

Quote:

Originally Posted by

3.) Wherever the default handlers in my base class and/or Global.asax
aren't appropriate, I implement suitable exception handling.

>

Quote:

Originally Posted by

4.) The application has a custom web page, which is itself an aspx
page. Some might have a tough time with that design, but it's
*extremely* stable, and doesn't do anything subject to failure.

>

Quote:

Originally Posted by

5.) Every exception is logged to the database (if possible) and to the
Windows event log.

>

Quote:

Originally Posted by

Yeah. I take 'em very seriously.- Hide quoted text -

>

Quote:

Originally Posted by

- Show quoted text -- Hide quoted text -

>
- Show quoted text -

Unfortunately, no, but that's due to the disconnected nature of our
system. The bug tracking database is housed here, at the software
shop, and the software itself is located on the production server at
the client -- in a different state, on a secure system, behind a
firewall, and to which we have no access. We are not permitted any
access to that system, due to security concerns. (It's a government
agency.)

The database contains an error log table; we are fortunate enough to
be able to receive backups of the database for data mining purposes,
and we mine that table to monitor exceptions for stuff that we missed.
I'm pleased to report that our unhandled exception rate is *extremely*
low.

We use BugTracker.NET here to track defects. It's rudimentary, but it
gets the job done for what we need. If we were able to write a secure
Web service to shuffle the data across the wire to BugTracker, I would
definitely be interested in doing that, but I don't think the client
will approve that any time in the near future. (Money is always a big
concern, and they have other things they want to get done at this
point in time. Since we are doing things pretty well "status quo,"
they're likely going to take the point of view that we can survive as
we are until it becomes a truly pressing concern. And if it ever came
to that, it would speak volumes about my code quality--they'd likely
need to hire a new developer, and I'd be brushing off my resume.)
On Mar 12, 3:04 pm, "Jason Kester" <jasonkes...@dotnet.itags.org.gmail.comwrote:

Quote:

Originally Posted by

I'm also a big fan of the custom Page idea. And I agree that logging
everything is important (that's why we wrote Regressor.NET!) It's
amazing how much you find out about your application when every single
exception gets logged.
>
Curious though, how many exceptions are you really seeing fall through
to Global.asax? I've seen a few posts on this thread from people that
are using Global.asax as a backup, but personally I've never had a
problem with the overriden OnError in my custom page classes. At
least I've never seen anything fall through in person, but then I
guess I'd never know if anything were slipping through the cracks...
>
Mike, do you forward crash reports directly to your bug tracking
software?
>
Jason Kester
Automated Crash Reporting and Regression Testing for ASP.NEThttp://www.regressor.net/
>
On Mar 12, 11:04 am, "Mike Hofer" <kchighl...@dotnet.itags.org.gmail.comwrote:
>
>
>

Quote:

Originally Posted by

In my application, I do the following:

>

Quote:

Originally Posted by

1.) All of my Web forms derive from a base Page class. OnError is
overridden to handle errors there.

>

Quote:

Originally Posted by

2.) I also handle exceptions in Global.asax, in the event that I've
missed something.

>

Quote:

Originally Posted by

3.) Wherever the default handlers in my base class and/or Global.asax
aren't appropriate, I implement suitable exception handling.

>

Quote:

Originally Posted by

4.) The application has a custom web page, which is itself an aspx
page. Some might have a tough time with that design, but it's
*extremely* stable, and doesn't do anything subject to failure.

>

Quote:

Originally Posted by

5.) Every exception is logged to the database (if possible) and to the
Windows event log.

>

Quote:

Originally Posted by

Yeah. I take 'em very seriously.- Hide quoted text -

>

Quote:

Originally Posted by

- Show quoted text -- Hide quoted text -

>
- Show quoted text -

In regards to your questions regarding exceptions that fall through to
global.asax, I've only seen this a handful of times at best. But when
they did, I was *very* thankful it was there. Since we log everything
to our database, data mining helps us to uncover those unhandled
exceptions and treat them as critical defects that require immediate
resolution.
Yeah, it's tough having to work in the real world. Best practices
have a way of slipping through the cracks at most places.

Here at Expat Software we use Fogbugz, so we have the option of
sending out crash report distress calls either by Email or via HTTP.
Either way, Fogbugz will automatically log a new case for us.

Regardless, it sounds like you're well ahead of the game. I suspect
that most shops have never considered logging exceptions at all!

Jason Kester
Automated Crash Reporting and Regression Testing for ASP.NET
http://www.regressor.net/
On Mar 12, 12:14 pm, "Mike Hofer" <kchighl...@dotnet.itags.org.gmail.comwrote:

Quote:

Originally Posted by

>
Unfortunately, no, but that's due to the disconnected nature of our
system. The bug tracking database is housed here, at the software
shop, and the software itself is located on the production server at
the client -- in a different state, on a secure system, behind a
firewall, and to which we have no access. We are not permitted any
access to that system, due to security concerns. (It's a government
agency.)
>

Yeah, it's tough having to work in the real world. Best practices
have a way of slipping through the cracks at most places.

Here at Expat Software we use Fogbugz, so we have the option of
sending out crash report distress calls either by Email or via HTTP.
Either way, Fogbugz will automatically log a new case for us.

Regardless, it sounds like you're well ahead of the game. I suspect
that most shops have never considered logging exceptions at all!

Jason Kester
Automated Crash Reporting and Regression Testing for ASP.NET
http://www.regressor.net/
On Mar 12, 12:14 pm, "Mike Hofer" <kchighl...@dotnet.itags.org.gmail.comwrote:

Quote:

Originally Posted by

>
Unfortunately, no, but that's due to the disconnected nature of our
system. The bug tracking database is housed here, at the software
shop, and the software itself is located on the production server at
the client -- in a different state, on a secure system, behind a
firewall, and to which we have no access. We are not permitted any
access to that system, due to security concerns. (It's a government
agency.)
>

SURVEY: How are you doing Global Error Handling in ASP.NET

Best I can tell, there are three basic ways you can deal with global
error handling in ASP.NET. Namely:
1. Derive all your pages from a custom Page class, and override
OnError()
2. Specify a custom 500 handler in Web.Config
3. Specify a custom 500 handler in IIS
and I guess you could add:
4. Let them fall through & spit out ugly error messages
I'm curious to see how people are doing it in the real world.
Personally, I've always used option #1, as it seems to offer the most
flexibility, and I'm already using custom Page objects, so it's no
extra work.
I'm asking this because we're getting close to a public BETA release
of Regressor.NET, and am considering adding support for cases 2 and
3. Before I commit the resources though, I'd like to get a feel for
how many people would benefit from it.
I look forward to seeing what people have to say. Thanks for the
help!
Jason Kester
Automated Crash Reporting and Regression Testing for ASP.NET
http://www.regressor.net/
ps. If anybody is interested in becoming a Beta tester for
Regressor.NET, let me know!Jason Kester schrieb:
> Best I can tell, there are three basic ways you can deal with global
> error handling in ASP.NET. Namely:
> 1. Derive all your pages from a custom Page class, and override
> OnError()
> 2. Specify a custom 500 handler in Web.Config
> 3. Specify a custom 500 handler in IIS
> and I guess you could add:
> 4. Let them fall through & spit out ugly error messages
5. Use global.asax to catch errors
greets,
steve
Stefan Kalcher
Programming's just like sex, one mistake, you support it for life.
On Mar 12, 1:29 am, "Jason Kester" <jasonkes...@.gmail.com> wrote:
> Best I can tell, there are three basic ways you can deal with global
> error handling in ASP.NET. Namely:
> 1. Derive all your pages from a custom Page class, and override
> OnError()
> 2. Specify a custom 500 handler in Web.Config
> 3. Specify a custom 500 handler in IIS
> and I guess you could add:
> 4. Let them fall through & spit out ugly error messages
> I'm curious to see how people are doing it in the real world.
> Personally, I've always used option #1, as it seems to offer the most
> flexibility, and I'm already using custom Page objects, so it's no
> extra work.
> I'm asking this because we're getting close to a public BETA release
> of Regressor.NET, and am considering adding support for cases 2 and
> 3. Before I commit the resources though, I'd like to get a feel for
> how many people would benefit from it.
> I look forward to seeing what people have to say. Thanks for the
> help!
> Jason Kester
> Automated Crash Reporting and Regression Testing for ASP.NEThttp://www.reg
ressor.net/
> ps. If anybody is interested in becoming a Beta tester for
> Regressor.NET, let me know!
In my application, I do the following:
1.) All of my Web forms derive from a base Page class. OnError is
overridden to handle errors there.
2.) I also handle exceptions in Global.asax, in the event that I've
missed something.
3.) Wherever the default handlers in my base class and/or Global.asax
aren't appropriate, I implement suitable exception handling.
4.) The application has a custom web page, which is itself an aspx
page. Some might have a tough time with that design, but it's
*extremely* stable, and doesn't do anything subject to failure.
5.) Every exception is logged to the database (if possible) and to the
Windows event log.
Yeah. I take 'em very seriously.
I'm also a big fan of the custom Page idea. And I agree that logging
everything is important (that's why we wrote Regressor.NET!) It's
amazing how much you find out about your application when every single
exception gets logged.
Curious though, how many exceptions are you really seeing fall through
to Global.asax? I've seen a few posts on this thread from people that
are using Global.asax as a backup, but personally I've never had a
problem with the overriden OnError in my custom page classes. At
least I've never seen anything fall through in person, but then I
guess I'd never know if anything were slipping through the cracks...
Mike, do you forward crash reports directly to your bug tracking
software?
Jason Kester
Automated Crash Reporting and Regression Testing for ASP.NET
http://www.regressor.net/
On Mar 12, 11:04 am, "Mike Hofer" <kchighl...@.gmail.com> wrote:
> In my application, I do the following:
> 1.) All of my Web forms derive from a base Page class. OnError is
> overridden to handle errors there.
> 2.) I also handle exceptions in Global.asax, in the event that I've
> missed something.
> 3.) Wherever the default handlers in my base class and/or Global.asax
> aren't appropriate, I implement suitable exception handling.
> 4.) The application has a custom web page, which is itself an aspx
> page. Some might have a tough time with that design, but it's
> *extremely* stable, and doesn't do anything subject to failure.
> 5.) Every exception is logged to the database (if possible) and to the
> Windows event log.
> Yeah. I take 'em very seriously.- Hide quoted text -
> - Show quoted text -
On Mar 12, 3:04 pm, "Jason Kester" <jasonkes...@.gmail.com> wrote:
> I'm also a big fan of the custom Page idea. And I agree that logging
> everything is important (that's why we wrote Regressor.NET!) It's
> amazing how much you find out about your application when every single
> exception gets logged.
> Curious though, how many exceptions are you really seeing fall through
> to Global.asax? I've seen a few posts on this thread from people that
> are using Global.asax as a backup, but personally I've never had a
> problem with the overriden OnError in my custom page classes. At
> least I've never seen anything fall through in person, but then I
> guess I'd never know if anything were slipping through the cracks...
> Mike, do you forward crash reports directly to your bug tracking
> software?
> Jason Kester
> Automated Crash Reporting and Regression Testing for ASP.NEThttp://www.reg
ressor.net/
> On Mar 12, 11:04 am, "Mike Hofer" <kchighl...@.gmail.com> wrote:
>
>
>
>
>
>
>
>
>
> - Show quoted text -
Unfortunately, no, but that's due to the disconnected nature of our
system. The bug tracking database is housed here, at the software
shop, and the software itself is located on the production server at
the client -- in a different state, on a secure system, behind a
firewall, and to which we have no access. We are not permitted any
access to that system, due to security concerns. (It's a government
agency.)
The database contains an error log table; we are fortunate enough to
be able to receive backups of the database for data mining purposes,
and we mine that table to monitor exceptions for stuff that we missed.
I'm pleased to report that our unhandled exception rate is *extremely*
low.
We use BugTracker.NET here to track defects. It's rudimentary, but it
gets the job done for what we need. If we were able to write a secure
Web service to shuffle the data across the wire to BugTracker, I would
definitely be interested in doing that, but I don't think the client
will approve that any time in the near future. (Money is always a big
concern, and they have other things they want to get done at this
point in time. Since we are doing things pretty well "status quo,"
they're likely going to take the point of view that we can survive as
we are until it becomes a truly pressing concern. And if it ever came
to that, it would speak volumes about my code quality--they'd likely
need to hire a new developer, and I'd be brushing off my resume.)
On Mar 12, 3:04 pm, "Jason Kester" <jasonkes...@.gmail.com> wrote:
> I'm also a big fan of the custom Page idea. And I agree that logging
> everything is important (that's why we wrote Regressor.NET!) It's
> amazing how much you find out about your application when every single
> exception gets logged.
> Curious though, how many exceptions are you really seeing fall through
> to Global.asax? I've seen a few posts on this thread from people that
> are using Global.asax as a backup, but personally I've never had a
> problem with the overriden OnError in my custom page classes. At
> least I've never seen anything fall through in person, but then I
> guess I'd never know if anything were slipping through the cracks...
> Mike, do you forward crash reports directly to your bug tracking
> software?
> Jason Kester
> Automated Crash Reporting and Regression Testing for ASP.NEThttp://www.reg
ressor.net/
> On Mar 12, 11:04 am, "Mike Hofer" <kchighl...@.gmail.com> wrote:
>
>
>
>
>
>
>
>
>
> - Show quoted text -
In regards to your questions regarding exceptions that fall through to
global.asax, I've only seen this a handful of times at best. But when
they did, I was *very* thankful it was there. Since we log everything
to our database, data mining helps us to uncover those unhandled
exceptions and treat them as critical defects that require immediate
resolution.
Yeah, it's tough having to work in the real world. Best practices
have a way of slipping through the cracks at most places.
Here at Expat Software we use Fogbugz, so we have the option of
sending out crash report distress calls either by Email or via HTTP.
Either way, Fogbugz will automatically log a new case for us.
Regardless, it sounds like you're well ahead of the game. I suspect
that most shops have never considered logging exceptions at all!
Jason Kester
Automated Crash Reporting and Regression Testing for ASP.NET
http://www.regressor.net/
On Mar 12, 12:14 pm, "Mike Hofer" <kchighl...@.gmail.com> wrote:
> Unfortunately, no, but that's due to the disconnected nature of our
> system. The bug tracking database is housed here, at the software
> shop, and the software itself is located on the production server at
> the client -- in a different state, on a secure system, behind a
> firewall, and to which we have no access. We are not permitted any
> access to that system, due to security concerns. (It's a government
> agency.)
>
Yeah, it's tough having to work in the real world. Best practices
have a way of slipping through the cracks at most places.
Here at Expat Software we use Fogbugz, so we have the option of
sending out crash report distress calls either by Email or via HTTP.
Either way, Fogbugz will automatically log a new case for us.
Regardless, it sounds like you're well ahead of the game. I suspect
that most shops have never considered logging exceptions at all!
Jason Kester
Automated Crash Reporting and Regression Testing for ASP.NET
http://www.regressor.net/
On Mar 12, 12:14 pm, "Mike Hofer" <kchighl...@.gmail.com> wrote:
> Unfortunately, no, but that's due to the disconnected nature of our
> system. The bug tracking database is housed here, at the software
> shop, and the software itself is located on the production server at
> the client -- in a different state, on a secure system, behind a
> firewall, and to which we have no access. We are not permitted any
> access to that system, due to security concerns. (It's a government
> agency.)
>

Surveys

hello Everyone,

I am a new programmer, I will be writing surveys. Does anyone know where I can get sample code or survey templates to get started on how to write surveys?

Thanks is advance.Check out these 2 resources:

NSurvey
http://www.nsurvey.org/

WebSurvey Control
http://www.sycbp.com/controls/websurvey/
Hello, surveys are nothing but webforms, where users can fill data in a form, and then you send the data to an email or database.
So, what is your level of information in how to create a webform ?
You can use the following as a starting point:
W3Schools.com
ASP.NET Quick Tutorials
ASPXtreme

regards.

Survey: What do you name your User table?

Most of the sites that I build have to deal with security at some
point, and this means that somewhere in the database there needs to be
a list of Users.

The naming convention that I (and most everybody I've ever worked with
that cares about such things) use dictates that a table should be named
according to what it contains, and that this name should be singular.
So, Customer, User, Entry are all good, while Customers, Users, Entries
are not so good. Thus, nobody has to deal with Junior Dev Jimmy's
magic ID generation code that occasionally tries to bind a column to
"EntrieID".

The issue I keep running into is that "User" is essentially a reserved
word in ASP.NET, being a property of Page. Thus, I can't use it as the
ClassName for my DataObject that wraps the User table. Thus, I
probably shouldn't be naming the table "User", since every other
DataObject always is named after the table it represents.

I've tried going with "Login" to describe users, but this usually
crashes into somebody's Login.aspx Page object, and besides it's not
quite descriptive enough for my tastes.

That leaves us with "Users" (thus breaking our naming convention),
"tblUser" "UserTable" or "UserRecord" (which all look silly on the
url), "Individual" or "Dude" (which I've actually gone with in the
past).

I'm curious what other people have come up with to attack this problem.
I'm sure I'm not the only one running into it. Let me know what you
think!

Jason Kester
Expat Software Consulting Services
http://www.expatsoftware.com/because tables are sets, i (like the sqlserver dev group) always make them
pural, so my users table name is Users. in your case UserInfo is probably a
good name.

-- bruce (sqlwork.com)

"jasonkester" <jasonkester@.gmail.com> wrote in message
news:1125699677.612465.206070@.g43g2000cwa.googlegr oups.com...
> Most of the sites that I build have to deal with security at some
> point, and this means that somewhere in the database there needs to be
> a list of Users.
> The naming convention that I (and most everybody I've ever worked with
> that cares about such things) use dictates that a table should be named
> according to what it contains, and that this name should be singular.
> So, Customer, User, Entry are all good, while Customers, Users, Entries
> are not so good. Thus, nobody has to deal with Junior Dev Jimmy's
> magic ID generation code that occasionally tries to bind a column to
> "EntrieID".
> The issue I keep running into is that "User" is essentially a reserved
> word in ASP.NET, being a property of Page. Thus, I can't use it as the
> ClassName for my DataObject that wraps the User table. Thus, I
> probably shouldn't be naming the table "User", since every other
> DataObject always is named after the table it represents.
> I've tried going with "Login" to describe users, but this usually
> crashes into somebody's Login.aspx Page object, and besides it's not
> quite descriptive enough for my tastes.
> That leaves us with "Users" (thus breaking our naming convention),
> "tblUser" "UserTable" or "UserRecord" (which all look silly on the
> url), "Individual" or "Dude" (which I've actually gone with in the
> past).
> I'm curious what other people have come up with to attack this problem.
> I'm sure I'm not the only one running into it. Let me know what you
> think!
>
> Jason Kester
> Expat Software Consulting Services
> http://www.expatsoftware.com/
UserProfile, UserRegistrationInfo, RegisteredUsers, UserCredentials...

Johm

Survey: What do you name your User table?

Most of the sites that I build have to deal with security at some
point, and this means that somewhere in the database there needs to be
a list of Users.
The naming convention that I (and most everybody I've ever worked with
that cares about such things) use dictates that a table should be named
according to what it contains, and that this name should be singular.
So, Customer, User, Entry are all good, while Customers, Users, Entries
are not so good. Thus, nobody has to deal with Junior Dev Jimmy's
magic ID generation code that occasionally tries to bind a column to
"EntrieID".
The issue I keep running into is that "User" is essentially a reserved
word in ASP.NET, being a property of Page. Thus, I can't use it as the
ClassName for my DataObject that wraps the User table. Thus, I
probably shouldn't be naming the table "User", since every other
DataObject always is named after the table it represents.
I've tried going with "Login" to describe users, but this usually
crashes into somebody's Login.aspx Page object, and besides it's not
quite descriptive enough for my tastes.
That leaves us with "Users" (thus breaking our naming convention),
"tblUser" "UserTable" or "UserRecord" (which all look silly on the
url), "Individual" or "Dude" (which I've actually gone with in the
past).
I'm curious what other people have come up with to attack this problem.
I'm sure I'm not the only one running into it. Let me know what you
think!
Jason Kester
Expat Software Consulting Services
http://www.expatsoftware.com/because tables are sets, i (like the sqlserver dev group) always make them
pural, so my users table name is Users. in your case UserInfo is probably a
good name.
-- bruce (sqlwork.com)
"jasonkester" <jasonkester@.gmail.com> wrote in message
news:1125699677.612465.206070@.g43g2000cwa.googlegroups.com...
> Most of the sites that I build have to deal with security at some
> point, and this means that somewhere in the database there needs to be
> a list of Users.
> The naming convention that I (and most everybody I've ever worked with
> that cares about such things) use dictates that a table should be named
> according to what it contains, and that this name should be singular.
> So, Customer, User, Entry are all good, while Customers, Users, Entries
> are not so good. Thus, nobody has to deal with Junior Dev Jimmy's
> magic ID generation code that occasionally tries to bind a column to
> "EntrieID".
> The issue I keep running into is that "User" is essentially a reserved
> word in ASP.NET, being a property of Page. Thus, I can't use it as the
> ClassName for my DataObject that wraps the User table. Thus, I
> probably shouldn't be naming the table "User", since every other
> DataObject always is named after the table it represents.
> I've tried going with "Login" to describe users, but this usually
> crashes into somebody's Login.aspx Page object, and besides it's not
> quite descriptive enough for my tastes.
> That leaves us with "Users" (thus breaking our naming convention),
> "tblUser" "UserTable" or "UserRecord" (which all look silly on the
> url), "Individual" or "Dude" (which I've actually gone with in the
> past).
> I'm curious what other people have come up with to attack this problem.
> I'm sure I'm not the only one running into it. Let me know what you
> think!
>
> Jason Kester
> Expat Software Consulting Services
> http://www.expatsoftware.com/
>
UserProfile, UserRegistrationInfo, RegisteredUsers, UserCredentials...
Johm