use the server date and time - C# Discussion Boards

Re: Control panel date Time

Dimitri Witkowski3-Jan-10 21:59

Dimitri Witkowski

3-Jan-10 21:59

System.Diagnostics.Process.Start("rundll32.exe", "shell32.dll,Control_RunDLL timedate.cpl,,0").Dispose();

Re: Control panel date Time

dan!sh 3-Jan-10 22:02

dan!sh

3-Jan-10 22:02

Like this:

System.Diagnostics.Process.Start("timedate.cpl");

50-50-90 rule: Anytime I have a 50-50 chance of getting something right, there's a 90% probability I'll get it wrong...!!

Re: Control panel date Time

Dimitri Witkowski3-Jan-10 22:04

Dimitri Witkowski

3-Jan-10 22:04

Yeah, this is the shorter way

Event Log Task Category

Jassim Rahma3-Jan-10 21:39

Jassim Rahma

3-Jan-10 21:39

The value allowed for the Task Category in the WriteEntry is short which means it's numeric only but how can I use a string value just like you can see in the event log of SQL Server...

Re: Event Log Task Category

Ashfield4-Jan-10 1:40

Ashfield

4-Jan-10 1:40

I think you have answered your own question. If the eventlog stores it as a short then you cannot put a string in it.

Bob
Ashfield Consultants Ltd
Proud to be a Code Project MVP

Re: Event Log Task Category

Jassim Rahma4-Jan-10 1:59

Jassim Rahma

4-Jan-10 1:59

then how Microsoft is doing it?! I can see string category in the eventlog of SQL Server!!

Re: Event Log Task Category

Ashfield4-Jan-10 5:00

Ashfield

4-Jan-10 5:00

Not really. This explains it [^]

Bob
Ashfield Consultants Ltd
Proud to be a Code Project MVP

use the server date and time

Jassim Rahma3-Jan-10 21:37

Jassim Rahma

3-Jan-10 21:37

I have 10 workstation on Vista and XP all connected to a windows server with SQL Server 2008 Express install on the server. Is there any way to use the server date and time on my application instead of using the date and time on the workstation? so even if the workstation date and tiome is wrong it will use the correct date and time from the server?

Re: use the server date and time

Abhinav S3-Jan-10 21:58

Abhinav S

3-Jan-10 21:58

Get the server date using a query. Then, use this date across your client application.

There are only 10 types of people in this world — those who understand binary, and those who don't.

Invalidate and redraw

AlexB473-Jan-10 21:02

AlexB47

3-Jan-10 21:02

Hi all,
i use, to move a circle in a panel (in a form), a code line such as this:

Grapichs e;

for(...)
{
panel.Invalidate(new Rect(list[i-1].x,list[i-1].y,list[i-1].widht,list[i-1].height));
e.DrawEllipse(list[i].x,list[i].y,list[i].widht,list[i].height);
}

can you help me with a solution that resolve a flicker problem? Is possible to create a doublebuffer in a panel object?

Thanks.

Alex

Re: Invalidate and redraw

Jimmanuel4-Jan-10 0:54

Jimmanuel

4-Jan-10 0:54

AlexB47 wrote:
Is possible to create a doublebuffer in a panel object?

Yes. Create a class that inherits from Panel and in the constructor you can set this.DoubleBuffered to true.

Badger | [badger,badger,badger,badger...]

Re: Invalidate and redraw

AlexB474-Jan-10 1:23

AlexB47

4-Jan-10 1:23

Can you help me with example? I use a panel object with "drag and drop" from toolbar into form (I'm novice programmer in C#).
Thanks a lot!

Alex

Re: Invalidate and redraw

Jimmanuel4-Jan-10 2:59

Jimmanuel

4-Jan-10 2:59

Well, I was about to reply with an example but as usual, Luc already has one handy Smile | :)

Re: Invalidate and redraw

Luc Pattyn4-Jan-10 2:44

Luc Pattyn

4-Jan-10 2:44

Hi,

this[^] has all you need.

Smile | :)

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

Merry Christmas and a Happy New Year to all.

Re: Invalidate and redraw

AlexB474-Jan-10 3:46

AlexB47

4-Jan-10 3:46

Good ... I test this solution!
Many Thanks!
Smile | :)

Alex

Re: Invalidate and redraw

Luc Pattyn4-Jan-10 4:00

Luc Pattyn

4-Jan-10 4:00

you're welcome.

Smile | :)

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

Merry Christmas and a Happy New Year to all.

Reading excel sheet issue

Priya Prk3-Jan-10 20:49

Priya Prk

3-Jan-10 20:49

Dear All,

Im trying to read data from excel through Oledb.

OleDbConnection connCura = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;
                        Data Source=" + path + ";Extended Properties=Excel 8.0");
                    OleDbDataAdapter da = new OleDbDataAdapter("SELECT * FROM [Sheet1$]", conn);

The problem is that if the 'Sheet1' in the excel file had a another name instead of 'Sheet1', then im getting this error:

System.Data.OleDb.OleDbException: External table is not in the expected format. at ConfigQeKMS.ReadImportFile.ReadTheFile(String path, String extension, String scheiTeken) in C:\Documents and Settings\KaneshkaB\Desktop\30 DEC 2009\QeKms\ConfigQeKMS\ReadImportFile.cs:line 61

Can anyone tell me how to fix this?

Thanks.

Re: Reading excel sheet issue

Aman Bhullar3-Jan-10 21:03

Aman Bhullar

3-Jan-10 21:03

Check the Article if this can help you
http://www.codeproject.com/tips/50009/Loading-Excel-data-into-a-GridView.aspx[^]

Regards
Aman Bhullar
www.arlivesupport.com[^]

Re: Reading excel sheet issue

Priya Prk3-Jan-10 23:40

Priya Prk

3-Jan-10 23:40

Thanks Aman, it worked Smile | :)

Delegate

Isaac Gordon3-Jan-10 19:59

Isaac Gordon

3-Jan-10 19:59

Hi Experts
I am Working Win Form in .NET 2005(C#).
i am making user control that have only one progress bar and label show the %age of progress bar.Now i am creating a window Form on that i use This user
control.when suppose i start for loop from 1 to 1000 then progress bar also running according to my for loop in user control.

main problem is that when loop is running in the form that i have used this control then how to send the value to progress so that it increase the progress bar value.

Dinesh Sharma.

Re: Delegate

Abhinav S3-Jan-10 20:36

Abhinav S

3-Jan-10 20:36

A similar question has already been answered before. Try here[^].

There are only 10 types of people in this world — those who understand binary, and those who don't.

C# textbox not working in vc++

Anu_Bala3-Jan-10 19:23

Anu_Bala

3-Jan-10 19:23

Hi,
Im using textbox in C# and i use this as C# dll in VC++.
But i cannot enter any value in that textbox.
Do i want to use any events for entering data..Pls help me?

Anu

Re: C# textbox not working in vc++

Richard MacCutchan3-Jan-10 22:20

Richard MacCutchan

3-Jan-10 22:20

You have asked a similar question twice already. Please post your question once only.

Re: C# textbox not working in vc++

Priya Prk3-Jan-10 23:48

Priya Prk

3-Jan-10 23:48

is the textbox not readonly? or enabled= false ?

Graphs in Report Sharp-Shooter

nagendrathecoder3-Jan-10 19:16

nagendrathecoder

3-Jan-10 19:16

Hi All,
I am using Report Sharp-Shooter of PerpetuumSoft for reporting in my project.
I want to insert graph/chart in my reports.

Can anybody tell me or provide some link to me on how to add graph/charts in Report Sharp-Shooter.

I have searched on google but i am mostly getting the links of purchase or free download of software.

Thanks,
Nagendra.

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