C# Discussion Boards - CodeProject

your idea plz: customer account number

10-Dec-09 4:22

It sounds like you need to port to WPF (there was, for me, a fair learning curve) as the old winforms stuff just isn't as flexible as WPF in terms of display and will lookk flat. WPF has built-in themes such as:

PresentationFramework.Aero
PresentationFramework.Classic
PresentationFramework.Luna
PresentationFramework.Royale

You can also download themes to skin your application as well

Here is a source.
http://www.codeplex.com/wpfthemes[^]

CCC solved so far: 2 (including a Hard One!)
37!?!! - Randall, Clerks

Jassim Rahma10-Dec-09 3:19

Jassim Rahma

10-Dec-09 3:19

can you please tell me your idea plz..

I want to create an accoutn number for every customer when they entered his details in my C# application..

and of course it must be unqiue account number

I though of the following:

DayOfYear + Month + Day + DayOfWeek + the_primary_key_from_customer_table

any other better idea?

Keith Barrow10-Dec-09 3:37

10-Dec-09 3:37

the_primary_key_from_customer_table should be enough.Just have a RegisterdDate column that is datestamped the the user is set up if you need to know this info, I wouldn't put it on the primary key.

Another common thing is to register a user with their e-mail address, each of which is unique (but a user might have > 1e-mail addess), but you need to ensure that all potential users have an e-mail before using this method. This way you can send a confirmation e-mail to ensure they are in charge of the address.

You could also generate a GUID to identify the user and use that as a PK.

Note that whatever you do, preventing a user from registering twice under different accounts is fatastically difficult (or possibly impossible!).

CCC solved so far: 2 (including a Hard One!)
37!?!! - Randall, Clerks

Jassim Rahma10-Dec-09 3:48

Jassim Rahma

10-Dec-09 3:48

no but thisis to be printed on the invoice of the customer so email and guid won't be ok..

what i wanted is something like a long number just to avoid tell customer that your account number is# 1 or #2

Andrew Rissing10-Dec-09 3:56

Andrew Rissing

10-Dec-09 3:56

You could just start your seed for your customer table at something like 10,000 or something.

Keith Barrow10-Dec-09 3:59

10-Dec-09 3:59

Now I understand what you want a bit better. Even if the you have customer no 1 it can still be printed 00000001.

You just need to decide how many digits you want at the outset though you can add more leading zeros if necessary. This will also free up more keys given the same number of digits, as you don't tie the key to the date which uses the first 8 up according to your scheme.

CCC solved so far: 2 (including a Hard One!)
37!?!! - Randall, Clerks

Eddy Vluggen10-Dec-09 4:43

Eddy Vluggen

10-Dec-09 4:43

I'd suggest not using the PK; sometimes people want to change their number, for whatever reason, and you'd have to update all the references.

Add an extra identity-field, set the seed to 8738234 and increment with 1 Smile | :)

I are Troll Suspicious | :suss:

converting date to another date format

PIEBALDconsult10-Dec-09 5:36

PIEBALDconsult

10-Dec-09 5:36

If you are trying to generate a number that the user can easily speak over the phone or type into an email you want to consider the number of digits.

If you do:

YearsSince2000 , DayOfYear , MemberThatDay

You could have it be 2+3+3 = 8 digits, but you would limit the number of accounts created in a day to 1000 (and only 100 years), which may be too low. (Unless you choose a base higher than ten, but I don't recommend that.)

benjamin yap10-Dec-09 2:53

benjamin yap

10-Dec-09 2:53

Hi,

i would like to convert this DateTime format from

"Sat, 05 Dec 2009 14:37:55 GMT"

to

"05 Dec"

Please advice. Thanks Big Grin | :-D

Re: converting date to another date format

Keith Barrow10-Dec-09 3:10

Re: converting date to another date format

10-Dec-09 3:10

DateTime foo = DateTime.Now;
Console.WriteLine(foo.ToString("dd MMM"));

Should sort you out. I'm feeling helpful today, other people will probably just tell this stuff is easily googled (which it is).

CCC solved so far: 2 (including a Hard One!)
37!?!! - Randall, Clerks

benjamin yap10-Dec-09 4:56

benjamin yap

10-Dec-09 4:56

many thanks

Regular Expression Help

Randal Vance Cunanan10-Dec-09 2:39

Randal Vance Cunanan

10-Dec-09 2:39

I want to validate a string containing the first name of a person.

The regegular expression should return a match if the first letter of the name is capitilized and
the rest are lowercase. The first name could also be multiple name.

sample:
John
John Raymond
Gary John Smith

Thanks a lot.

Re: Regular Expression Help

Ian Shlasko10-Dec-09 2:51

Ian Shlasko

10-Dec-09 2:51

Something like this?

([A-Z][a-z]*)(\s+[A-Z][a-z]*)*

Of course that'll fail for the more exotic names, but you can modify it.

Proud to have finally moved to the A-Ark. Which one are you in?
Author of Guardians of Xen (Sci-Fi/Fantasy novel)

Re: Regular Expression Help

Randal Vance Cunanan10-Dec-09 2:54

Randal Vance Cunanan

10-Dec-09 2:54

Thanks a lot. That's all I need.

Re: Regular Expression Help [modified]

Luc Pattyn10-Dec-09 2:55

Luc Pattyn

10-Dec-09 2:55

An example[^] and another example[^] which should tell you it ain't simple to come up with a good algorithm.

Also not all names get camel-cased, see this famous architect[^].

Smile | :)

Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles]

I only read code that is properly indented, and rendered in a non-proportional font; hint: use PRE tags in forum messages

modified on Thursday, December 10, 2009 9:15 AM

Re: Regular Expression Help

Keith Barrow10-Dec-09 3:12

I Want Sqlite dll for Visual Studio 2003

10-Dec-09 3:12

Top marks for J-C v-D!

CCC solved so far: 2 (including a Hard One!)
37!?!! - Randall, Clerks

savitri10-Dec-09 1:06

savitri

10-Dec-09 1:06

Hi All,

I am savitri here.New to this part of forum. I am doing one application for Psion Teklogix Device in VC# 2003.It is Windows CE 4.2. For that i am using Visual Studio 2003. I want to create database in device. I am not getting how to use sqlite operation in device programming. I am not getting any Dll's for that SQLite.
So please tell me how to create and connect in device level programming. Give me some hints or solution.I am searching alot but not got any result.Getting struck here only. please do needful for me.
Please tell me how to connect in C# using sqlite dll's.

Regards,
Savitri Frown | :(

Re: I Want Sqlite dll for Visual Studio 2003

Migounette10-Dec-09 2:39

Migounette

10-Dec-09 2:39

Look at this: old project but should be good start

http://code.google.com/p/managed-sqlite/[^]

Domain name verification

RugbyLeague10-Dec-09 1:05

RugbyLeague

10-Dec-09 1:05

I am trying to verify some domain names from our internal customer list. I am using Dns.GetHostAddresses but it doesn't seem to find half of the domains - many I can type into IE and up pops the web page. Is GetHostAddresses broken (I have tried the deprecated methods too and they don't seem to work either)

Rob Philpott10-Dec-09 2:00

Rob Philpott

10-Dec-09 2:00

Do you not want to use GetHostByName?

Regards,
Rob Philpott.

RugbyLeague10-Dec-09 4:12

RugbyLeague

10-Dec-09 4:12

That doesn't seem to work either - I get "The requested name is valid, but no data of the requested type was found" on even some quite well known domain names

Rob Philpott10-Dec-09 5:43

Rob Philpott

10-Dec-09 5:43

That's strange, as my understanding is that's what Internet Explorer etc. will call behind the scenes to resolve domain names. Sorry, as confused as you. Frown | :(

Regards,
Rob Philpott.

RugbyLeague10-Dec-09 5:46

RugbyLeague

10-Dec-09 5:46

It's an odd one.