Re: Value in Database - C# Discussion Boards

Form flashes beneath an OpenFileDialog or 2nd Form

30-Dec-03 19:57

Heath Stewart wrote:
With the MSDE/SQL Server, you'd simply enter (newid()) as the default value for the field in the table on the server and that's it.

Yes that could be done in ACCESS too.

Heath Stewart wrote:
If you're using a strongly-typed DataSet, it's possible that you might have the DataColumn.AllowDBNull and / or the DataColumn.

Hehhee...you know what error I get now after set AllowDBNull to true?

---------------------------
Error when committing the row to the original data store.
---------------------------
Cannot change a proposed value in the RowChanging event. Do you want to correct the value?
---------------------------
Yes No
---------------------------

The whole point of using guid is be aware of Primarykey in the application rather than that AotoNomber. I don't wanna miss it. Frown | :(

Mazy

No sig. available now.

flipdoubt30-Dec-03 4:15

flipdoubt

30-Dec-03 4:15

This happens more often with Debug builds than Release builds, but I often have a Form with lots of controls and, hence, lots of painting to do that launches another Form, whether it is an Open File Dialog or a new Form. Basically, the Form at the bottom of the z-order does some ugly flashing while the OpenFileDialog or new Form closes.

I've tried SuspendLayout/ResumeLayout on the Form at the bottom but this doesn't seem to help with its constituent controls. Any ideas on how to stop this?

I can show you screenshots if you think that would help.

Re: Form flashes beneath an OpenFileDialog or 2nd Form

Heath Stewart30-Dec-03 5:58

30-Dec-03 5:58

SuspendLayout and ResumeLayout are really only useful when initializing controls. Once they're initialized, it's pointless to use them.

As for the problem, do you notice the flickering when passing another window over your application (a window from another application)? If so, painting isn't the error exactly. Whatever occurs in your app in this case when you close the form is eating up enough CPU cycles - or blocking the main UI thread completely - to cause slow repainting of invalidated regions.

If the behavior is the same whether you pass one of your windows, or a window from another application over yours (or minimize -> restore, whatever to invalidate your form), then you might have to consider overriding several of the more offensive controls and enable double-buffered painting. See the Control.SetStyle method and ControlStyles enumeration documentation for details.

If many of these controls are already custom controls that you've written, using a double-buffered approach to painting (if you haven't already) will help, but you should also be mindful of the invalidated region when handling OnPaint (its better to override OnEventName methods when possible, as opposed to handling the events in a child class) and only repaint the invalidated regions (again, if you haven't already).

Value in Database

Mazdak30-Dec-03 1:17

30-Dec-03 1:17

I wanna check in my database if an item exist,what do you suggest is the best way for that?I myself get a quey whith WHERE condition contain that value ,if it return null so it doesn't exist. I use MS Access so I can't use stored procedure.
I want a way other than Unique property.

Mazy

No sig. available now.

Heath Stewart30-Dec-03 5:51

30-Dec-03 5:51

Do you mean you want to check to see if a column, table, view, etc. exists in your database? If so, you can do this easily in SQL Server / MSDE (which is a hell of a lot better than MS Access, and MSDE is free (it is SQL Server without some of the advanced features and limited connections)) using the SCHEMA_INFORMATION tables.

For MS Access, it doesn't provide such meta-data that I'm aware of (I did a lot of programming with access many years ago, but haven't in the last couple years...thank God!). You can use a Module and use the object model to see if objects exists, but I'm not sure how you could execute such a function without using an interop assembly for MS Acccess.

You really should take a look at MSDE, though. It's a royalty-free, relatively small installation (you can even have up to 16 instances of MSDE/SQL Server running on a single machine) with REAL security (both SQL and Windows authentication modes) and is a true RDBMs.

Sorry I couldn't answer your question the way you wanted, but 1) I don't think it's possible (from what I remember, and from what the MS Access documentation says - or rather doesn't say), and 2) MS Access sucks for any serious programs. You can also take advantage of the System.Data.SqlClient namespace elements with MSDE, too - which gives you much better support that generic OLE DB (which is an abstract data access mechanism, after all).

Mazdak30-Dec-03 6:32

30-Dec-03 6:32

Thanks for reply but I don't want to look about a column. I kmow those things about SCHEMA_INFORMATION and other things you say,I want to chheck existence of a record in table. I have two column:First Name and LastName. I want to check if First Name+LastName is unique. I do it in the way that I mentioned in first message but I want to know if there is better way or not.

Mazy

No sig. available now.

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).

Mazdak30-Dec-03 9:30

How should I call an exe file using C#

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

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# ????

Yaron K.29-Dec-03 20:38

Yaron K.

29-Dec-03 20:38

Try Exec ? See help.

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.

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");

Expand/Collapse feature in c#

Saqib Razzaq29-Dec-03 22:30

Saqib Razzaq

29-Dec-03 22:30

Thanks alot.

it solved my problem

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

Changing the paper size at run time

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.

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

Mazdak29-Dec-03 23:42

29-Dec-03 23:42

In your Print_Page event of PrintDocument:

e.PageSettings.PaperSize

Mazy

No sig. available now.

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:

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.

Heath Stewart30-Dec-03 5:35

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