C# Discussion Boards - CodeProject

Re: C# & SQL Datetime

mrkeivan15-Jun-10 19:27

mrkeivan

15-Jun-10 19:27

Found it myself Big Grin | :-D

I used this function:

CREATE FUNCTION dbo.fnFormatDate (@Datetime DATETIME,  @FormatMask VARCHAR(32))

RETURNS VARCHAR(32)

AS

BEGIN

    DECLARE @StringDate VARCHAR(32)

    SET @StringDate = @FormatMask

    IF (CHARINDEX ('YYYY',@StringDate) > 0)

       SET @StringDate = REPLACE(@StringDate, 'YYYY', DATENAME(YY, @Datetime))

    IF (CHARINDEX ('YY',@StringDate) > 0)

       SET @StringDate = REPLACE(@StringDate, 'YY', RIGHT(DATENAME(YY, @Datetime),2))

    IF (CHARINDEX ('Month',@StringDate) > 0)

       SET @StringDate = REPLACE(@StringDate, 'Month', DATENAME(MM, @Datetime))

    IF (CHARINDEX ('MON',@StringDate COLLATE SQL_Latin1_General_CP1_CS_AS)>0)

       SET @StringDate = REPLACE(@StringDate, 'MON',

                         LEFT(UPPER(DATENAME(MM, @Datetime)),3))

    IF (CHARINDEX ('Mon',@StringDate) > 0)

       SET @StringDate = REPLACE(@StringDate, 'Mon', LEFT(DATENAME(MM, @Datetime),3))

    IF (CHARINDEX ('MM',@StringDate) > 0)

       SET @StringDate = REPLACE(@StringDate, 'MM',

                  RIGHT('0'+CONVERT(VARCHAR,DATEPART(MM, @Datetime)),2))

    IF (CHARINDEX ('M',@StringDate) > 0)

       SET @StringDate = REPLACE(@StringDate, 'M',

                         CONVERT(VARCHAR,DATEPART(MM, @Datetime)))

    IF (CHARINDEX ('DD',@StringDate) > 0)

       SET @StringDate = REPLACE(@StringDate, 'DD',

                         RIGHT('0'+DATENAME(DD, @Datetime),2))

    IF (CHARINDEX ('D',@StringDate) > 0)

       SET @StringDate = REPLACE(@StringDate, 'D', DATENAME(DD, @Datetime))   

RETURN @StringDate

END

dbo.fnFormatDate (SR.StuDateOfReg, 'M/DD/YYYY') >> 6/15/2010

Re: C# & SQL Datetime

Bernhard Hiller15-Jun-10 21:04

Bernhard Hiller

15-Jun-10 21:04

That's not a good design. Change the data type for your date time values to 'datetime'. Furthermore, use parameterized queries. Then your problems should be easily resolved without long functions.

Re: C# & SQL Datetime

PIEBALDconsult16-Jun-10 14:00

PIEBALDconsult

16-Jun-10 14:00

That is horrible. Don't use strings for dates (or numbers); it's terribly inefficient, especially when you convert the data in the table to strings and then compare -- don't do it!

Convert the incoming string to a date and then compare.

Mehdi

ShomaL University of AMOL15-Jun-10 18:43

ShomaL University of AMOL

15-Jun-10 18:43

i want to move a button on a form with a keypress on keyboard.
please help me
what should i do?
danialkhazaei@yahoo.com

Mehdi

ShomaL University of AMOL15-Jun-10 18:42

ShomaL University of AMOL

15-Jun-10 18:42

i want to move a button on a form with a keypress on keyboard.
please help me
what should i do?

Re: Mehdi

Abhinav S15-Jun-10 19:48

Abhinav S

15-Jun-10 19:48

1) You have posted the same question twice. Remove the one that has not been answered to.
2) You have used the joke icon while posting this question. People will not take your question seriously.
3) See here - maybe this can help.

My signature "sucks" today

Re: Mehdi

DaveyM6915-Jun-10 19:50

DaveyM69

15-Jun-10 19:50

Set the KeyPreview of the containing form to true, handle the Form's KeyPress/KeyDown/KeyUp event depending on your needs and set the Button's Location property to the point you want.

Please only post once and give your post a title that indicates the problem in future.

Dave

If this helped, please vote & accept answer!

Binging is like googling, it just feels dirtier. (Pete O'Hanlon)

BTW, in software, hope and pray is not a viable strategy. (Luc Pattyn)

Post with proper subbject

Khaniya15-Jun-10 20:08

Khaniya

15-Jun-10 20:08

Hi mehdi

Post your questions with proper subbject

thanks

Life's Like a mirror. Smile at it & it smiles back at you.- P Pilgrim
So Smile Please

Re: Mehdi

OriginalGriff15-Jun-10 21:33

OriginalGriff

15-Jun-10 21:33

Delete the second copy of your question, before it gets replied to.
Never post your email to any forum - unless you really like spam! CP will send you emails as necessary when people reply to you. (Just like this one)

Did you know:
That by counting the rings on a tree trunk, you can tell how many other trees it has slept with.

Thanks!

venomation15-Jun-10 10:53

venomation

15-Jun-10 10:53

I decided not too use it as a singleton (or in my case as I was being silly a "Global" object !).
Thank's Big Grin | :-D

Re: Thanks!

Abhinav S15-Jun-10 18:29

Abhinav S

15-Jun-10 18:29

venomation wrote:
I decided not too use it as a singleton (or in my case as I was being silly a "Global" object !).

Ok. So what are you answering to?
Are you referring to some other article / post?
Then please post that link here or better, post this message within that same article or link.

My signature "sucks" today

I cannot find a proper way to do this can someone help

safame2015-Jun-10 9:42

safame20

15-Jun-10 9:42

I want to assign 10 threads (it could be n) to a listview of (10000 records).

The listview's first coloumn is email. So I want to send email to a method and get a return string as a result (valid or not). which i want to add to the second column of the listview. Pls help me how to do it?

Code would be much appriciated.

Re: I cannot find a proper way to do this can someone help

Wes Aday15-Jun-10 11:11

Wes Aday

15-Jun-10 11:11

So you deleted your original post to repost your request for code.... why?

Why is common sense not common?
Never argue with an idiot. They will drag you down to their level where they are an expert.
Sometimes it takes a lot of work to be lazy
Individuality is fine, as long as we do it together - F. Burns

Re: I cannot find a proper way to do this can someone help

Luc Pattyn15-Jun-10 11:30

Luc Pattyn

15-Jun-10 11:30

so he decided to completely ignore forum guidelines, ignore and down-vote my earlier reply, delete the question, create a new thread on the same subject, and use a meaningless subject line. Not a compelling start.

Smile | :)

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

Nil Volentibus Arduum

Re: I cannot find a proper way to do this can someone help

Wes Aday15-Jun-10 12:50

Wes Aday

15-Jun-10 12:50

Well it would appear that I was down voted as well... oh the calamity.

Re: I cannot find a proper way to do this can someone help

Luc Pattyn15-Jun-10 13:05

Luc Pattyn

15-Jun-10 13:05

Wes Aday wrote:
oh the calamity

little ones can be cured easily.

Smile | :)

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

Nil Volentibus Arduum

Re: I cannot find a proper way to do this can someone help

Wes Aday15-Jun-10 13:53

Wes Aday

15-Jun-10 13:53

Luc Pattyn wrote:
little ones can be cured easily

Only if you believe the SPAM... Smile | :)

Re: I cannot find a proper way to do this can someone help

safame2015-Jun-10 11:38

safame20

15-Jun-10 11:38

First of all I posted in this forum for the first time.( i know it is a mistake now).

Secondly if my code was working i will not be looking for help. About deleting my code and reposting the question. You only said that it does not look right.

Anyway i will do it myself thanx have a nice day

Smile | :)

Re: I cannot find a proper way to do this can someone help

Luc Pattyn15-Jun-10 11:43

Luc Pattyn

15-Jun-10 11:43

People here are more than willing to help out; however there are some rules to make that easier and to get things a bit streamlined. Good luck with those threads.

Smile | :)

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

Nil Volentibus Arduum

Re: I cannot find a proper way to do this can someone help

safame2015-Jun-10 11:46

safame20

15-Jun-10 11:46

thanx buddy Smile | :)

Re: I cannot find a proper way to do this can someone help

Wes Aday15-Jun-10 12:52

Wes Aday

15-Jun-10 12:52

safame20 wrote:
i know it is a mistake now

Posting was not the mistake that you made.

safame20 wrote:
You only said that it does not look right.

I said no such thing.

decrypting data

dia 201015-Jun-10 9:10

dia 2010

15-Jun-10 9:10

Hi i am new in C#. i am developing a banking system in which each bank sends encrypted messages to each other. i am using 3-DES algorithm.
i am facing following problem.
user sends encrypted message to bank A and bank A decryptes it.here this algorithm works fine but when bank A sends this to Bank B then i am getting this runtime error

"Invalid character in a Base-64 string."

i am using the following code.

string cipherText = richTextBox2.Text.Trim();
            string mykey;                       
            byte[] keyArray;
            byte[] toDecryptArray = Convert.FromBase64String(cipherText);

            StreamReader objReader = new StreamReader("c:\\encryptkey.txt");
            mykey = objReader.ReadToEnd();
            objReader.Close();
            if (mykey.Length < 24) mykey = mykey.PadRight(24, '.');
            keyArray = UTF8Encoding.UTF8.GetBytes(mykey);

            tdes.Key = keyArray;
            tdes.Mode = CipherMode.ECB;
            tdes.Padding = PaddingMode.PKCS7;
            ICryptoTransform myTransform = tdes.CreateDecryptor();
            byte[] resultArray = myTransform.TransformFinalBlock(toDecryptArray, 0, toDecryptArray.Length);

            tdes.Clear();
          
            data = UTF8Encoding.UTF8.GetString(resultArray);

the same code works very fine for first time decryption but not for 2nd time. i am getting error in
byte[] toDecryptArray = Convert.FromBase64String(cipherText);

plz help me.
thanx

Re: decrypting data

Dr.Walt Fair, PE15-Jun-10 9:47

Dr.Walt Fair, PE

15-Jun-10 9:47

So, when you look at it in a debugger, what is the invalid character and where did it come from? Are you sure there are no control characters getting added on somewhere?

CQ de W5ALT

Walt Fair, Jr., P. E.
Comport Computing
Specializing in Technical Engineering Software

Generic List in UserControl

Ian Grech15-Jun-10 9:02

Ian Grech

15-Jun-10 9:02

Hi All;

I have created a user control that contains a generic list. When I instantiate this control in a Windows Form for some reason and array of the list type as (List<of type="">) is being added to the forms resources (.resx file). It runs ok for 2/3 times and then I get an error as follows:

Object of type 'NameSpace.Type[]' cannot be converted to type 'NameSpace.Type[]'. (where Namespace and Type are my class namespace and type.

Both list type and usercontrol are in teh same namespace.

Can anyone please help in clearnign this.

Thanks
Bin

Re: Generic List in UserControl

Henry Minute15-Jun-10 11:36

Henry Minute

15-Jun-10 11:36

I have had this problem before, but not for some time.

If memory serves it is caused by your having changed the Namespace.Type[] class/control/whatever in some way and when you next try to load the parent form it still has the 'old' style one serialized and of course cannot deserialize it. Again purely from memory the work-around is to delete the *.resx file for that form, although renaming/moving it might be safer from a restoration point of view.

Also a long, long, long time ago .NET 1.0/1.1 days this could happen if the 'build' part of the version information changed between runs. Not sure if this still applies though. The work-around here was to change the Version specification from [assembly: AssemblyVersion("X.Y.*.*")] to [assembly: AssemblyVersion("X.Y.*.1")] in AssemblyInfo.cs.

Hope this is of some help. Smile | :)

Henry Minute

Do not read medical books! You could die of a misprint. - Mark Twain
Girl: (staring) "Why do you need an icy cucumber?"
“I want to report a fraud. The government is lying to us all.”
Why do programmers often confuse Halloween and Christmas? - Because 31 Oct = 25 Dec.
Business Myths of the Geek #4 'What you think matters.'

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.