Re: Changing date format - C# Discussion Boards

9-Jul-07 21:12

Hi!

I'm working with Microsoft SQL Database. Dead | X|

Anybody knows how to change date format form code:
Now it's MM/DD/YYYY but i want DD/MM/YYYY. Cry | :((

Thank you. Rose | [Rose]

--------------------------------
visit: http://pmartike.deviantart.com/

Muhammad Gouda9-Jul-07 21:42

Muhammad Gouda

9-Jul-07 21:42

I am familier with MS Access rather than SQL
And to do that there, I choose my format in the database designe phase (Set the date field format to whatever you want). and do not need coding for this.
I think SQL Server provides same thing

Mohamed Gouda
Egypt

Harini N K9-Jul-07 21:55

Harini N K

9-Jul-07 21:55

Hi
Use SET DATEFORMAT

See the example below:

<br />
Example 1 : executes without any error <br />
<br />
use northwind<br />
go<br />
<br />
set dateformat dmy<br />
go<br />
<br />
select top 10 * from Orders where requireddate >= '15-08-1996'<br />
<br />
Example 2 : gives error <br />
<br />
use northwind<br />
go<br />
<br />
set dateformat mdy<br />
go<br />
<br />
select top 10 * from Orders where requireddate >= '15-08-1996'

Harini

pmartike9-Jul-07 22:07

9-Jul-07 22:07

And this works from code in .NET?

Thanks anyway! Wink | ;)

--------------------------------
visit: http://pmartike.deviantart.com/

Md Mustafa9-Jul-07 22:41

Md Mustafa

9-Jul-07 22:41

just type cast datetimr to string and give parameter as your desire format
like:-
.ToString("dd/mm/yyyy");

Mohammad Mustafa

pmartike10-Jul-07 0:27

10-Jul-07 0:27

this returns me a string like this: "10/46/2007" if i used for today's date.. OMG | :OMG:

--------------------------------
visit: http://pmartike.deviantart.com/

Vikram A Punathambekar10-Jul-07 0:35

Vikram A Punathambekar

10-Jul-07 0:35

mm represents minutes. Use MM for the month.

Cheers,
Vıkram.

After all is said and done, much is said and little is done.

pmartike10-Jul-07 1:58

10-Jul-07 1:58

thanks

--------------------------------
visit: http://pmartike.deviantart.com/

PIEBALDconsult10-Jul-07 8:28

PIEBALDconsult

10-Jul-07 8:28

Please consider using an ISO 8601 compliant format -- .ToString ( "yyyy-MM-dd" )

pmartike10-Jul-07 21:25

how to refresh the mdi child form.

10-Jul-07 21:25

Thanks!
Problem solved Big Grin | :-D

--------------------------------
visit: http://pmartike.deviantart.com/

monuSaini9-Jul-07 20:52

9-Jul-07 20:52

Hello every body,

I want to refresh or reload the form1 on the click event of button on form2.

Actually form1 contains the listview and form2 is edit form on the click event of update button i want to refresh the form1 in order to see the updated result.

But i am unable to do so.

Regards,
Rahul

rahul saini

Martin#9-Jul-07 21:02

Martin#

9-Jul-07 21:02

Hello,

monuSaini wrote:
But i am unable to do so.

Why? Do you think, you have no access to the form1,
or haven't you found the Refresh() method of the form?

All the best,

Martin

monuSaini9-Jul-07 21:07

9-Jul-07 21:07

Hello Martin,

Thanks for rply.

But it is not working.

the updated row does't showe the updated result.

Only when i reloads or re populates it is appears.

Regards,

rahul saini

Martin#9-Jul-07 21:10

Martin#

9-Jul-07 21:10

Hello,

monuSaini wrote:
the updated row does't showe the updated result.

Have you tried to use the Refresh method?

I think we have to see some code snippeds.

All the best,

Martin

monuSaini9-Jul-07 21:21

9-Jul-07 21:21

Hi,

Yes I had
But no result.

I had an refresh button in form1 that populates it. Can I generate that click event from form2

Regards,

rahul saini

how to create a HELP document

Martin#9-Jul-07 21:29

Martin#

9-Jul-07 21:29

monuSaini wrote:
Can I generate that click event from form2

Here is your thread where you asked it![^]

Additionaly I would suggest this article from Colin Angus Mackay[^]

All the best,

Martin

MS Lee9-Jul-07 20:50

MS Lee

9-Jul-07 20:50

Hello PPL,
Hope all r fine,

i hv a doubt in,
i hv a word document, and in my form there is a help butten, if we click the help button then my word document should be get display with in the specified area,
i think i hv to make the word document as a html right na?

gimme me a clear idea to me ... Confused | :confused:

self confidence+hard work=SUCCESS

engsrini9-Jul-07 20:59

engsrini

9-Jul-07 20:59

Save your word document as webpage, create a form and place a webbrowser control.
Whenever user clicks Help button dispaly the form with webbrowser navigating to your Help document page.

srini

MS Lee9-Jul-07 21:09

MS Lee

9-Jul-07 21:09

can v make the help document to display within the specified panel..
how can v?
and how to create a help document as a tree structure Confused | :confused:

self confidence+hard work=SUCCESS

Rahul.RK9-Jul-07 21:41

Rahul.RK

9-Jul-07 21:41

he hi..

Do one thing just create a .chm file.

you have to use "windows HTML help workshop" for that.

Just search on net u will get help.

For creating .chm it will take time but it will be easier next time.

Thanks

Rahul Kulkarni

MS Lee9-Jul-07 21:49

MS Lee

9-Jul-07 21:49

no dude, i hv to display the document with in the form only......
Confused | :confused:

self confidence+hard work=SUCCESS

how to call click event od button on another form

engsrini12-Jul-07 1:17

engsrini

12-Jul-07 1:17

You can create word document as you like, and can navigate the document using webbrowser control.

You can use HypherLinks for making the help documents as like in BookMarks.

monuSaini9-Jul-07 20:19

Re: how to call click event od button on another form

9-Jul-07 20:19

Hello every body,

I am new in windows application.

Can we call the click event of button (which is on from1) from form2.

Regards,
Rahul

rahul saini

Michael Sync9-Jul-07 20:24

Michael Sync

9-Jul-07 20:24

- Make public function in Form1

- Call it from Form2

eg:
objForm1.PublicButtonClick();

Thanks and Regards,
Michael Sync ( Blog: http://michaelsync.net)

Re: how to call click event od button on another form

monuSaini9-Jul-07 20:36