Re: How should I call an exe file using C# - C# Discussion Boards

Heath Stewart30-Dec-03 7:36

30-Dec-03 7:36

Sorry, your question didn't quite make sense. "Record" instead of "item" would've been the optimal word. I didn't quite follow what you meant.

The way you're doing it (or using the COUNT aggregate and checking for a result value of 1) is fine, but you can create a multi-field index that is unique, thus making a UNIQUE index as you could in MSDE/SQL Server. I know you said you didn't want to do this, but I don't know if you were aware that multi-field indexes are possible.

Just open the Indexes Window for your table. On a new line, type an index name (like "Name"), and select the first field you want. Below that, select the second field you want but do not type an index name. You can do this for up to 10 rows. Finally, go back to the first row and set Unique to Yes. This is documented in the MS Access help. This should also cause an OleDbException to be thrown, which you can catch in a try-catch block and handle gracefully. We do this with SQL Server on our web site quite a bit and just show friendly errors when they occur while logging more information to the trace log (or other event target).

-----BEGIN GEEK CODE BLOCK-----
Version: 3.21
GCS/G/MU d- s: a- C++++ UL@ P++(+++) L+(--) E--- W+++ N++ o+ K? w++++ O- M(+) V? PS-- PE Y++ PGP++ t++@ 5 X+++ R+@ tv+ b(-)>b++ DI++++ D+ G e++>+++ h---* r+++ y+++
-----END GEEK CODE BLOCK-----

Re: Value in Database

Mazdak30-Dec-03 9:30

Mazdak

30-Dec-03 9:30

Heath Stewart wrote:
I don't know if you were aware that multi-field indexes are possible.

I didn't aware of that. I do it in this way now Smile | :)

Well thank you. I learn something useful from you man. Smile | :)

Mazy

No sig. available now.

Creating an XML File

deanoA29-Dec-03 22:08

deanoA

29-Dec-03 22:08

Hi!

How do you create an xml file using a C# windows forms?
And also, please tell me to how to read and write on it. Thanks a lot!

ps
Is it possible to query an xml file using C# code? if yes, can you tell me how?

"To teach is to learn twice"

Re: Creating an XML File

Colin Angus Mackay29-Dec-03 22:36

Colin Angus Mackay

29-Dec-03 22:36

First of all, it is not the Windows Forms part of the .NET framework that deals with XML. The XML classes are found in System.Xml namespace (although access to Xml files can also be made through the System.Data classes if they are database-like.

Did you try searching CodeProject? I found the following articles that explain different ways of dealing with XML files:

Reading an XML file using .NET[^]

XML Data Files, XML Serialization, and .NET[^]

Load and Save objects to XML using serialization[^]

XMLFoundation[^]

XML Serialization in .NET[^]

--Colin Mackay--

"In the confrontation between the stream and the rock, the stream always wins - not through strength but perseverance." (H. Jackson Brown)

Enumerators in .NET: See how to customise foreach loops with C#

Re: Creating an XML File

Manster31-Dec-03 3:31

Manster

31-Dec-03 3:31

Daljv,
Here is an article I wrote which does all of the things you want to do programatically in C# in a windows application.

http://codeproject.com/csharp/CSPersonalOrganizer1.asp

Good Luck Poke tongue | ;-P

How should I call an exe file using C#

Saqib Razzaq29-Dec-03 20:25

Saqib Razzaq

29-Dec-03 20:25

I could not find any function in C# that allows to call exe files. I need some function that does the equal of Visual C 6's WinExec (strCommand, nCmdShow).

e.g. WinExec ("calc.exe", 0);
opens the windows calculator and
WinExec ("notepad.exe", 0); opens the notepad.

Some same stuff in C# ????

Re: How should I call an exe file using C#

Yaron K.29-Dec-03 20:38

Yaron K.

29-Dec-03 20:38

Try Exec ? See help.

Re: How should I call an exe file using C#

Saqib Razzaq29-Dec-03 20:49

Saqib Razzaq

29-Dec-03 20:49

I found it in MSDN and ExecCommand (strCommand, strArgs);

but I do not know in which namespace they exists. The msdn page that show the description of this method does not tell the namespace requirements. If you know please do let me know.

Re: How should I call an exe file using C#

Juergen Posny29-Dec-03 22:09

Juergen Posny

29-Dec-03 22:09

Exec is an internal method within the visual studio ide.
For generic tasks, you should try the 'Process' object.
You can find it in the 'System.Diagnostics' namespace.
ex :
Process.Start("IExplore.exe", "www.northwindtraders.com");

Re: How should I call an exe file using C#

Saqib Razzaq29-Dec-03 22:30

Saqib Razzaq

29-Dec-03 22:30

Thanks alot.

it solved my problem

Expand/Collapse feature in c#

pc_2k1129-Dec-03 19:35

pc_2k11

29-Dec-03 19:35

hi there,
is there any way to gain the expand collapse feature using c#.I mean something similar to the one we are seeing here.the thread expand/collapse feature..looking forward for the replies and thx in advance.

Re: Expand/Collapse feature in c#

Heath Stewart30-Dec-03 5:40

Heath Stewart

30-Dec-03 5:40

You should try searching the forums using "Search Comments" above (search this, the lounge, and anything else that seems relevent). There is code out there and this has been answered before. Google will also reveal some results.

Changing the paper size at run time

Yaron K.29-Dec-03 19:32

Yaron K.

29-Dec-03 19:32

Hi

I have a code which prints to the printer using the PrintDocument & PrintPreviewDialog classes.

I need to specify at run time which paper size I want to use: A4, Letter, A3 etc. These are not custome sizes but rather standard sizes, listed in the PaperKind enum.

How can I force a certain paper size at run time? The PaperSize.Kind property is read only.

thanks

Re: Changing the paper size at run time

Mazdak29-Dec-03 23:42

Mazdak

29-Dec-03 23:42

In your Print_Page event of PrintDocument:

e.PageSettings.PaperSize

Mazy

No sig. available now.

Re: Changing the paper size at run time

Mehdi Moshtaghi30-Dec-03 0:27

Mehdi Moshtaghi

30-Dec-03 0:27

To Mazdak!!
Damn man don't you have anything else to do. Go study your exams !!! Cool | :cool:

Re: Changing the paper size at run time

Yaron K.30-Dec-03 2:25

Yaron K.

30-Dec-03 2:25

Thanks, but i still have the same problem.

I am trying to:

private void pd_PrintPage(object sender, PrintPageEventArgs e)
{
e.PageSettings.PaperSize.Kind = PaperKind.A3;
}

but i does not compile because PaperSize.Kind is read-only.

Re: Changing the paper size at run time

Heath Stewart30-Dec-03 5:35

Heath Stewart

30-Dec-03 5:35

You have to construct a new PaperSize like so:

private void pd_PrintPage(object sender, PrintPageEventArgs e)
{
  // I don't rem
  e.PageSettings.PaperSize =
    new PaperSize("Custom", 11.69 * 100, 16.54 * 100);
}

You should also take a look at the PrinterSetttings.PaperSizes documentation. This is a collection that contains each PaperSize that the printer supports. You can enumerate and determine if the printer supports A3 and then get that PaperSize:

foreach (PaperSize size in PrinterSettings.PaperSizes)
  if (size.Kind == PaperKind)
    return size;
return null; // or throw an Exception that A3 is not supported

Re: Changing the paper size at run time

IntegraSoft31-Dec-03 9:37

IntegraSoft

31-Dec-03 9:37

I tried this ans it doesnt work, The paper size is still 8.5 x 11. Do I Have to do something else.

Thanks.

Carlos Eduardo Hernandez P.

Re: Changing the paper size at run time

Heath Stewart31-Dec-03 9:40

Heath Stewart

31-Dec-03 9:40

See Mazdak's answer that he(/she?) copied from MSDN. I was just answering why you couldn't change the paper size with the code you were using. I thought it seemed weird that the original reply was doing this in PrintDocument.PrintPage.

Re: Changing the paper size at run time

IntegraSoft31-Dec-03 9:46

IntegraSoft

31-Dec-03 9:46

I try that as well and it didnt work. Am i doing somehting wrong?

thanks.

Carlos Eduardo Hernandez P.

Re: Changing the paper size at run time

Heath Stewart31-Dec-03 11:04

Heath Stewart

31-Dec-03 11:04

Are you sure the printer supports that size of paper? Use the other technique I mentioned where you get the sizes that it supports and see if that paper size is in the collection.

Re: Changing the paper size at run time

IntegraSoft1-Jan-04 7:50

IntegraSoft

1-Jan-04 7:50

I try using the enumeration of papersize and it didnt work. But I really need to define a custom size, not one defined on the printer. Before using .Net, I was using VB6, and in Windows 98, Windows 95, it was very easy to print in any paper size in the printer. But after windows NT, or windows 2000, my vb6 applications could not print on any sizes on those windows. I found out that after windows nt, it has to be creted a form and then attach it to the printer and print. Could it be that I have to do the same thing.

Thanks.

Carlos Eduardo Hernandez P.

Re: Changing the paper size at run time

Heath Stewart1-Jan-04 9:29

Heath Stewart

1-Jan-04 9:29

Why didn't enumerating work? That's supported by the Framework plus some Windows function that are P/Invoked and has more to do with the print server and the printer driver than the printer itself.

As far as forms, A3 is already supported so long as you use the dimensions that I gave in a previous example - no rounding! You could try it, though. After all, all the print classes and methods in the Framework are just wrappers for all the functionality in Windows anyway.

Re: Changing the paper size at run time

Mazdak30-Dec-03 6:26

Mazdak

30-Dec-03 6:26

THis is sample code from MSDN:

private void MyButtonPrint_Click(object sender, System.EventArgs e)
   {
      // Set the paper size based upon the selection in the combo box.
      if (comboPaperSize.SelectedIndex != -1) {
         printDoc.DefaultPageSettings.PaperSize = 
            printDoc.PrinterSettings.PaperSizes[comboPaperSize.SelectedIndex];
      }

      // Set the paper source based upon the selection in the combo box.
      if (comboPaperSource.SelectedIndex != -1) {
         printDoc.DefaultPageSettings.PaperSource = 
            printDoc.PrinterSettings.PaperSources[comboPaperSource.SelectedIndex];
      }
      
      // Set the printer resolution based upon the selection in the combo box.
      if (comboPrintResolution.SelectedIndex != -1) 
      {
         printDoc.DefaultPageSettings.PrinterResolution= 
            printDoc.PrinterSettings.PrinterResolutions[comboPrintResolution.SelectedIndex];
      }

      // Print the document with the specified paper size, source, and print resolution.
      printDoc.Print();
   }

Mazy

No sig. available now.

interop - array of structs with embedded strings

lavinder29-Dec-03 17:45

lavinder

29-Dec-03 17:45

Hi all

In one of my vc dlls, following structure and function have been declared:

struct mystruct
{
uint u1;
TCHAR arr1[30];
TCHAR arr2[15];
uint u2;
}

int testfunc(mystruct** arrptr)

i have declared c# equivalent of structure as

public class mystruct
{
public uint u1;
[MarshalAs(UnmanagedType.ByValTStr, SizeConst = 30)]
public string arr1;
[MarshalAs(UnmanagedType.ByValTStr, SizeConst = 15)]
public string arr2;
public uint u2;
}

Internally testfunc is implementing arrptr as pointer to array of structures.

My query is what should be declaration of this function. Should i pass class variable by ref, or IntPtr or ???

Thanks in advance

lsb

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