C# Discussion Boards - CodeProject

Re: Dataset save as new .mdb

Eddy Vluggen20-Jul-10 0:05

Eddy Vluggen

20-Jul-10 0:05

shoubi wrote:
I have another question, however it is not related to this.

No problem, but you would have gotten more reactions if you created a new post.

shoubi wrote:
How do I import this dll into the C++

Using a Platform Invoke[^] would be the easy way to call unmanaged code. If you want to wrap an existing unmanaged type, then look here[^].

Enjoy Smile | :)

I are Troll Suspicious | :suss:

How to notify exception in worker thread to Main thread

Praveen Raghuvanshi15-Jun-10 22:17

Praveen Raghuvanshi

15-Jun-10 22:17

Hi,

I need to notify any exception in the worker thread to the main/ calling thread. How to achieve this and what is the best way to do it.
Googled around and came to know that the exceptions in the worker thread are not handled by the main thread.

Thanks,

Praveen Raghuvanshi
Software Engineer,

India.

Re: How to notify exception in worker thread to Main thread

Gonzalo Cao15-Jun-10 22:56

Gonzalo Cao

15-Jun-10 22:56

Hi,

You can use 'Application.ThreadException'. it will handle any unhandled exception that raises in a sub-thread, anyway this only allows you to have a application wide event for handling all your sub-threads. Maybe you can create an event yourself and call it on the catch block. This way you control the exceptions on the sub-thread and send it to UI thread.

Hope this helps.

Re: How to notify exception in worker thread to Main thread

Praveen Raghuvanshi16-Jun-10 19:08

Praveen Raghuvanshi

16-Jun-10 19:08

Thanks Gonzalo!

I have tried above mentioned event mechanism. Just thought of something better available. Smile | :)

Praveen Raghuvanshi
Software Engineer,

India.

Re: How to notify exception in worker thread to Main thread

Gonzalo Cao16-Jun-10 21:21

Gonzalo Cao

16-Jun-10 21:21

You welcome Smile | :)

.

I guess then the only way would be you taking care of picking the expcetion in the sub-thread and moving it to UI manually.

Regards.

Hello Can you help?

levan omadze15-Jun-10 21:40

levan omadze

15-Jun-10 21:40

Hello.
In the database tree structure of how to write?
After the move in the C#

Re: Hello Can you help?

OriginalGriff15-Jun-10 22:05

OriginalGriff

15-Jun-10 22:05

From your description of the problem, no.

Please clarify your question - in English it does not make a lot of sense...

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

Hello

levan omadze15-Jun-10 21:39

levan omadze

15-Jun-10 21:39

Hello.
In the database tree structure of how to write?
After the move in the C#

Re: Hello

Peace ON15-Jun-10 21:44

Peace ON

15-Jun-10 21:44

Can you please give some detail, so that it is easier to answer your question.

And please don't cross post. Read this[^] guideline before you post your question.

HTH

Jinal Desai - LIVE
Experience is mother of sage....

Yahoo woeid based weather forecasts

faheemnadeem15-Jun-10 21:01

faheemnadeem

15-Jun-10 21:01

Hi,
I am building a GPS assisted application, which is to display a weather forecast for the closest location with reference to current location.

I am using yahoo weather forecasts.

What i have done:
1. I can successfully request a weather for a place if i know its WOEID (Note: only some places have weather forecasts).
2. In order to get a WOEID of the current location i can query "FLICKR" using YQL and passing current latitude and longitude and get a WOEID back for that place.

Problem:
Is there any way i can request a weather forecast for a nearest location to acquired WOEID of current location.

Thank you in advance,

Microsoft Word Viewer on C#

Mohammad.Elcharfa15-Jun-10 20:51

Mohammad.Elcharfa

15-Jun-10 20:51

Hi Guys,

I would appreciate it if someone has found/created an MS Word Viewer/Editor Control on Visual Studio.

Thanks,

Re: Microsoft Word Viewer on C#

Abhinav S15-Jun-10 21:46

Abhinav S

15-Jun-10 21:46

If you are looking for a word .doc editor in C#, you can find several on the internet. See here.

My signature "sucks" today

C# & SQL Datetime

mrkeivan15-Jun-10 19:18

mrkeivan

15-Jun-10 19:18

Hey guys, I'm having trouble searching for a date I fetch in C# in my database
in my application the date time value is in this format: 6/16/2010 9:41:19 AM in the database I use

CONVERT(VARCHAR(10),SR.StuDateOfReg,101)

to convert my date and extract only the date part but what I get is 06/15/2010.
I thought there should be no difference between 6/16/2010 and 06/16/2010,
when I execute this query

... WHERE CONVERT(VARCHAR(10),SR.StuDateOfReg,101) >= CONVERT(VARCHAR(10),'6/15/2010',101)

I don't get anything back but when I go for

... WHERE CONVERT(VARCHAR(10),SR.StuDateOfReg,101) >= CONVERT(VARCHAR(10),'06/15/2010',101)

It works!

so how can I change one to another?

regards,

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.

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