C# Discussion Boards - CodeProject

multiple workstations to one database

15-Mar-04 5:45

C, using old Win32 APIs from the Platform SDK.

Microsoft MVP, Visual C#
My Articles

ASGill15-Mar-04 4:28

ASGill

15-Mar-04 4:28

hi,

im developing a system where it'll be running accross about four workstations, these four are all connected to a database server. my question is in C# how and where do i synchronize database operations, for example deletion, adding, modifying and searching.

also.. is there any theoratical document that shows the difference between Java n C#, i search the net but only to get one that was on syntactical differences(by Dare Obasanjo). Any other reading materials?

thx !!

CODER

Re: multiple workstations to one database

Heath Stewart15-Mar-04 5:18

15-Mar-04 5:18

The easiest place to synchronize the request is by using locking in the RDBMS, such as the MSDE or SQL Server (in which case use the System.Data.SqlClient classes for better support). There are many locking features and many ways to lock queries, so see the SQL Server documentation for more information.

You can search MSDN[^] (the one-stop place for most or your Windows development information) for documents that discuss the differences between Java and C#. Keep in mind, however, that C# is just one of many languages that target the CLR. While languages differ in syntax and support of some features of the CLR, they can all access assemblies (including the FCL) written in any other managed language. So the differences you're looking for are between Java (the JVM) and .NET (the CLR), not just C#.

The runtimes are completely separate, though they share common ideas like JIT'ing, garbage collection, and other facilities that OO runtimes utilize.

Microsoft MVP, Visual C#
My Articles

folder path syntax?

Anonymous15-Mar-04 3:32

Anonymous

15-Mar-04 3:32

Hi I'm new to C# and I have a folder path string question. I want to only specify the folder path, not a particular file path. Which syntax is correct @"C:\Program Files"; or @"C:\Program Files\";?

Thanks

Re: folder path syntax?

John Fisher15-Mar-04 4:15

how can i run client software from web?

15-Mar-04 4:15

In most cases, they will both work, since they technically refer to the same place. If you try putting both of these into the Windows Explorer address bar, they will both bring you to the same location.

John

"You said a whole sentence with no words in it, and I understood you!" -- my wife as she cries about slowly becoming a geek.

Re: folder path syntax?

Dave Kreskowiak15-Mar-04 7:05

Dave Kreskowiak

15-Mar-04 7:05

Most of the Win32 API's and the .NET Framework functions will accept either. But, there are a couple of functions, like SetVolumeLabel, that require the trailing backslash.

RageInTheMachine9532

agakyurek15-Mar-04 3:15

agakyurek

15-Mar-04 3:15

I have to do sth like this.When the client visited web page,he will be asked to update our software.When he accepts update,module will be download to client computer.the downloaded module ( i don't know what is it,may be an activex object) will automatically run and find software and update it, in the client machine.So what can i do to implement these in c#.

Re: how can i run client software from web?

Heath Stewart15-Mar-04 5:14

15-Mar-04 5:14

Yes, you can do this using .NET. You write a smart client that is embedded using the OBJECT tag, but not quite in the same way as an ActiveX control (though if you expose your .NET control correctly, you can still script it). I used to have an article detailing this at DevHood, but that site is no longer available so I'm re-writing it for CodeProject (though it's not done yet). You can find more information about this in the .NET Framework SDK, Deploying a Runtime Application using Internet Explorer[^].

Microsoft MVP, Visual C#
My Articles

Printing a blank page

Shaun Becker15-Mar-04 2:47

15-Mar-04 2:47

I am trying to print formatted text with the Win32 Api using the DrawText function and it is printing out a blank page. Does anybody know what I could be doing wrong? Thanks

John Fisher15-Mar-04 4:13

15-Mar-04 4:13

There are many, many ways to write code incorrectly. In this sort of situation, we won't be able to do much without seeing the code that doesn't work.

John

"You said a whole sentence with no words in it, and I understood you!" -- my wife as she cries about slowly becoming a geek.

Shaun Becker15-Mar-04 4:36

15-Mar-04 4:36

Here is the code. Thanks alot

public IntPtr CreateFont(IntPtr hDC, string fontName, int size, FontStyle style)
{
LOGFONT lf = new PrinterApi.LOGFONT();
FONT_WEIGHT_FLAGS weight = FONT_WEIGHT_FLAGS.FW_DONTCARE;

if (Convert.ToBoolean(style & FontStyle.Bold)) {
weight |= FONT_WEIGHT_FLAGS.FW_BOLD;
}

if (Convert.ToBoolean(style & FontStyle.Regular)) {
weight |= FONT_WEIGHT_FLAGS.FW_REGULAR;
}

lf.lfHeight = (-1) * GetFontSize(hDC, size);
lf.lfWidth = 0;
lf.lfEscapement = 0;
lf.lfOrientation = 0;
lf.lfWeight = weight;
lf.lfItalic = Convert.ToByte(style & FontStyle.Italic);
lf.lfUnderline = Convert.ToByte(style & FontStyle.Underline);
lf.lfStrikeout = Convert.ToByte(style & FontStyle.Strikeout);
lf.lfOutPrecision = CHARACTER_PRECISION.OUT_TT_ONLY_PRECIS;
lf.lfClipPrecision = CLIP_PRECISION.CLIP_DEFAULT_PRECIS;
lf.lfPitchAndFamily = (byte)FONT_PITCH.DEFAULT_PITCH | (byte)FONT_FAMILY.FF_DONTCARE;
lf.lfFaceName = new byte[LF_FACESIZE];

byte[] temp = Encoding.ASCII.GetBytes(fontName);
for (int i = 0; i < lf.lfFaceName.Length; i++) {
if (i >= temp.Length) {
lf.lfFaceName[i] = 0;
} else {
lf.lfFaceName[i] = temp[i];
}
}
return CreateFontIndirect(ref lf);
}

int GetFontSize(IntPtr hDC, int size)
{
return size / 72 * GetDeviceCaps(hDC, LOGPIXELSY);
}

public void Method()
{
string Text = "Some Text";

IntPtr hDC = CreateDC(null, @"Network Imagistics im3510 PCL5e", null, 0);
DOCINFO doc = new PrinterApi.DOCINFO();
doc.cbSize = Marshal.SizeOf(typeof(DOCINFO));
doc.lpszDocName = "Test Win32Printer";
doc.lpszOutput = null;

if (StartDoc(hDC, doc)) {
StartPage(hDC);

try {
RECT rectStruct = new PrinterApi.RECT();
rectStruct.Left = 0;
rectStruct.Top = 0;
rectStruct.Right = 600;
rectStruct.Bottom = 600;
IntPtr font = CreateFont(hDC, "Times New Roman", 20, 0);
IntPtr oldFont = SelectObject(hDC, font);
DrawText(hDC, Text, Text.Length, ref rectStruct, DRAWTEXT_FORMAT_FLAGS.DT_NOCLIP);

SelectObject(hDC, oldFont);
DeleteObject(font);
EndPage(hDC);
EndDoc(hDC);
} catch (Exception e) {
AbortDoc(hDC);
throw e;
} finally {
}
}

DeleteDC(hDC);
}

John Fisher15-Mar-04 6:09

15-Mar-04 6:09

Well, I haven't done Win32 printing for a while, but here are a few pointers/questions.

* Why use Win32 printing from C#, when the .NET Framework provides an easier method?

* When using Win32 routines, you need to check return codes, and call GetLastError() -- especially when things aren't working as you expect. It is quite likely that one of the two will give you a strong hint.

* Check basic things like - Is the text color white? - Am I really putting the text where I thought I was? - Can my printer even print in the area that I'm placing the text, or is it cutting that off? - Am I getting back a valid font?

* You are simultaneously dealing with Interop issues and Win32 issues. Unless you understand them both well, the confusion is going to be much greater than if you were dealing with only on at a time.

John

"You said a whole sentence with no words in it, and I understood you!" -- my wife as she cries about slowly becoming a geek.

Shaun Becker15-Mar-04 8:21

15-Mar-04 8:21

The reason that I am trying to use Win32 to print instead of the .Net framework is because the project I am working on is a mass printing system and the .Net framework is too slow to keep up. How do I change the text color? Thanks

Shaun Becker15-Mar-04 9:25

15-Mar-04 9:25

Do you know of a good resource on printing with Win32 Api? Everything that I have found has been very vague and not as detailed as I would like. Thanks alot. I really appreciate your help.

John Fisher15-Mar-04 16:55

Checkbox in Subitem of ListView

15-Mar-04 16:55

I haven't personally found (or really needed) a good printing resource for Win32. However, my impression is that it is primarily generic Win32 GDI calls, with a different dpi and size. So, a reasonable way to test your code would be to separate the code that does actual drawing into a separate function, then send that function any DC handle. When trying it out, you can draw straight to the screen. Once that works, you can draw to the printer DC.

SetTextColor() is what my memory tells me about changing the text color.

John

"You said a whole sentence with no words in it, and I understood you!" -- my wife as she cries about slowly becoming a geek.

katetsai15-Mar-04 2:44

katetsai

15-Mar-04 2:44

Is there any way to add the checkbox control for each subitem in the ListView? thanks in advance for any help.

Heath Stewart15-Mar-04 5:11

15-Mar-04 5:11

You'd have to owner draw the list. Search CodeProject for examples. This will require overriding WndProc and handling notification messages, so experience with Win32 programming will be helpful. There are also third-party controls that offer this behavior out of the box.

Microsoft MVP, Visual C#
My Articles

katetsai15-Mar-04 5:58

katetsai

15-Mar-04 5:58

I've searched the web, and was not able to find any example code. The only one example code in the CodeProject website was way too complicated for my need.

Are you suggesting inherit the ListView & add the checkbox control. I did that, but not sure how to display the control when a new item is added for a subitem (for example, I need a checkbox control display for subitem 2 & 6). I would think it would be the same as adding a image to the specific column, and when click event occurs, switch to another image depending on if the checkbox is checked or not.

thanks in advance.

Heath Stewart15-Mar-04 6:14

15-Mar-04 6:14

You can't simply add the CheckBox control to a sub-item. A sub-item is not a valid windows control and can't be parent to another control. The solution is complicated. If you can't do it, then you should get a third-party control like those from http://www.devexpress.com[^] or http://www.infragistics.com[^].

The .NET controls in Windows Forms encapsulate the Windows Common Controls, which are native controls for Win32. If the functionality you need is not exposed from the .NET controls, you have to go back to the basics of Win32 control programming and handle notification messages and send messages, use Windows styles, and more. That's just the way it is.

Microsoft MVP, Visual C#
My Articles

John Fisher15-Mar-04 6:15

15-Mar-04 6:15

katetsai wrote:
Are you suggesting inherit the ListView & add the checkbox control.

No, he is talking more about using a Panel, or creating a UserControl. Then, do all the drawing and mouse checking for yourself by handling the painting routines, and dealing with MouseDown, MouseUp, MouseMove, etc.

There are many ways to deal with this, it would be an immense help to you if you understood the basics of creating a custom control. So, have a look here: http://www.codeproject.com/cs/miscctrl/cutebutton.asp[^]

John

"You said a whole sentence with no words in it, and I understood you!" -- my wife as she cries about slowly becoming a geek.

Heath Stewart15-Mar-04 6:31

Localizing standard types in PropertyGrid

15-Mar-04 6:31

Actually, I'm talking about extending the ListView, overriding WndProc, P/Invoking a few native APIs like SendMessage, declaring necessary consts and structs, and handling notification messages and sending windows messages as necessary like you would in Win32 programming. I've done it to provide sorted column background colors and sorting arrows on column headers. There are several articles on that here on CodeProject as well (though if you have decent Win32 programming experience it's not hard to figure out since it's what you had to do to extend anything anyway).

For instance, you could handle the NM_CUSTOMDRAW to paint to shift the text and draw the check box (for which you can use ControlPaint.DrawCheckBox if you create a Graphics object from the necessary handles). It's complicated to explain and is content meant for an article. Fortunately, there is articles on this here on CodeProject and elsewhere on the web. To the original poster, you just have to search for the right terms, like ListView SubItem CheckBox C#[^], which came up with several results (including some here on CodeProject).

Microsoft MVP, Visual C#
My Articles

i_blazhko15-Mar-04 1:49

i_blazhko

15-Mar-04 1:49

Hi, All!

I am using PropertyGrid to edit properties of type Font, Size (e.g. standard types).
These properties are expandable in propertygrid and I need to make names of sub-properties (Font.Size, Font.Name, Size.Width etc) locale-dependent.

There are examples how to localize your own-made classes, by overriding GetProperties method (go to http://www.codeproject.com/cs/miscctrl/globalizedpropertygrid.asp or search for "GlobalizedObject", "Globalized Property Grid" to see details).
I successfully used this for my own classes, but in the case of standard classes this does not suit me well:
1) I cannot inherit from Font to just override GetProperties, Font is sealed class.
2) When I make my own class that will wrap Font instance, I will lose advanced editing in PropertyGrid, e.g. combobox with icons for font family name.
3) Also and I am confused with emulating original Font editing: Font has read-only properties Name, Size that can nevertheless be edited in PropertyGrid.

Could someone suggest me way to resolve this problem, so I will have localized sub-properties for properties of standard types Font, Size in PropertyGrid and editors in PropertyGrid for these properties will remain with all their bells and whistles?

Thanks in advance.

Re: Localizing standard types in PropertyGrid

Heath Stewart15-Mar-04 5:10