Re: Is there any way to monitor a text file? - C# Discussion Boards

Re: How to monitor the Sql Server (2000 and 2005) Database change?

18-Sep-06 23:46

hi all,
I need monitor the MS SQL Server (both 2000 and 2005) database changes.
like Sql Profiler.
how to do it?
Thanks in advance.

Christian Graus18-Sep-06 23:47

Christian Graus

18-Sep-06 23:47

I don't believe there's any way to get notifications of tables changing.

Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog

Is there any way to monitor a text file?

CooperWu19-Sep-06 0:08

19-Sep-06 0:08

Thanks for your reply.(f)

If there was the way to monitor the text file.
I have an idea that,
1, create trigger with the table
2, write the operations to a text files.
3, monitor text files changes to get the special table changes.

Any assistance would be really appreciated.

Christian Graus19-Sep-06 0:23

Christian Graus

19-Sep-06 0:23

Yeah, that would work Smile | :)

Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog

CooperWu19-Sep-06 1:01

19-Sep-06 1:01

Thanks for your reply.
(f)

Rob Philpott19-Sep-06 4:39

Rob Philpott

19-Sep-06 4:39

It's a bit grim, but if you're on Sql Server 2005, you can write managed stored procedures in C#, so you could use some mechanism like Remoting to send an update from your managed proc to the listening process. You'd then need to link your managed proc into the trigger.

As far as monitoring file changes, the following code snippet may give you some pointers:

using System.IO;

_watcher = new FileSystemWatcher();
_watcher.Path = folder;
_watcher.IncludeSubdirectories = true;
_watcher.NotifyFilter = NotifyFilters.LastWrite | NotifyFilters.DirectoryName | NotifyFilters.FileName;
_watcher.Changed += new FileSystemEventHandler(OnChanged);
_watcher.Created += new FileSystemEventHandler(OnChanged);
_watcher.Deleted += new FileSystemEventHandler(OnChanged);
_watcher.Renamed += new RenamedEventHandler(OnRenamed);

Regards,
Rob Philpott.

CooperWu19-Sep-06 16:28

Formatting and Rounding Numbers

19-Sep-06 16:28

Thanks for your reply.

Rob Philpott wrote:
Sql Server 2005

we use MS Sql Server both 2000 and 2005

Rob Philpott wrote:
managed stored procedures in C#, so you could use some mechanism like Remoting to send an update from your managed proc to the listening process. You'd then need to link your managed proc into the trigger.

I didn't know about 'Managed stored procedures', can you give me more information about this?

Brendan Vogt18-Sep-06 23:38

Brendan Vogt

18-Sep-06 23:38

Hi,

I worked out a decimal value and return the value like this:

return objWine.CurrencySymbol + (decUnitPrice * intQty);

But the it will display something like:

$100.0000

How do I format this number to display $100.00, and will this function round the decimal numbers?

I hope someone can help.

Regards
ma se

Christian Graus18-Sep-06 23:46

Christian Graus

18-Sep-06 23:46

http://idunno.org/displayBlog.aspx/2004071401[^]

Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog

Stefan Troschuetz18-Sep-06 23:47

Stefan Troschuetz

18-Sep-06 23:47

Standard Numeric Format Strings[^]
Custom Numeric Format Strings[^]

"Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning." - Rick Cook

www.troschuetz.de

CooperWu18-Sep-06 23:54

18-Sep-06 23:54

try

<br />
            decimal d = 100.0000m;<br />
            string s = string.Format("{0:000.00}", d);<br />
            Console.WriteLine(s);<br />

the result :

<br />
100.00<br />

Brendan Vogt19-Sep-06 0:44

Brendan Vogt

19-Sep-06 0:44

This doesn't display right:

String strUnitPrice = String.Format("{0:#,##0.00}", "100.3456");

I want it to round it off to 100.35 (rounded), but it just displays 100.3456.

What am I doing wrong??

CooperWu19-Sep-06 1:06

19-Sep-06 1:06

It should be:

<br />
String strUnitPrice = String.Format("{0:#,##0.00}", 100.3456);<br />

no quote, it must be a number.

And I would suggest you read the reply above mine.
There are more information about String.Format.
or search in on MSDN.

hoping this help.

Brendan Vogt19-Sep-06 1:07

Brendan Vogt

19-Sep-06 1:07

Yeah I did just that and worked, but thanks any how!!

Cheers

How to call Form inside a Form

Mirunab19-Sep-06 1:27

Mirunab

19-Sep-06 1:27

Hi,
Get the value in a string and use System.Math.Round(x,2).Tostring();

Thanks,
Mirunalini

jackyha18-Sep-06 23:22

jackyha

18-Sep-06 23:22

Dear All,

I am doing a project which needs to load different "child" Forms in a specific area in the Main Frame Form.

I tried to create a "child" Form instance inside the Main Form, and every time when Main Form move, it will update the "child" Form's location. But by using this method, the Form keeps flickering even "double buffering" is already enabled.

I am thinking that if it is possible to create a ControlContainer that can load the Forms accordingly, but I am new to C# and not sure what should do.

Anyone knows can please point out which area I should read or any place has the existing sample can refer?

Thanks a lot!

Best Regards,
Jacky Ha

KrunalC18-Sep-06 23:30

KrunalC

18-Sep-06 23:30

I suppose your's is the fit case of MDI application. Set ISMDIContainer property of the Main form to true and load child forms as MDI Child

jackyha18-Sep-06 23:45

jackyha

18-Sep-06 23:45

Hi, KrunalC,

Thanks for your reply!

Yes, this method can work if the Main Form and Child Form are standard ones.

In my case, the Main Form is a shaped Form (using Background Image and Transparent Color), so if set IsMdiContainer, the previously transparent Form Edge will have an edge now.

Another issue is that I only need a specific area in the Main Form to be able to load different "child" Forms. If set IsMdiContainer, it will apply to the whole Main Form. Is there any method to set its size and starting position?

Thanks again!

Best Rgds,
Jacky Ha

Stefan Troschuetz18-Sep-06 23:52

Stefan Troschuetz

18-Sep-06 23:52

Do your child forms really need to be forms? Probably UserControls or maybe even simple Panels will be more suitable.

jackyha18-Sep-06 23:57

jackyha

18-Sep-06 23:57

Hi, Stefan,

You are right! I will try Panel first and then UserControl if Panel can't.

Thanks a lot!

Best Rgds,
Jacky Ha