Re: Guid in DataTable - C# Discussion Boards

30-Dec-03 9:30

I use Guid for my Table instead of autonumber in my database table. I show this table in a grid.When I use autonumber it generate primary key in datagrid of my application,now here there is no number and it doeasn't happend and when user add a new row in datagrid of my application they get error that this record is null. How can I handle it so Guid automatcly generate in datagrid like autonumber.Any idea?

Mazy

No sig. available now.

Heath Stewart30-Dec-03 11:23

30-Dec-03 11:23

For an MS Access database to do this, it doesn't appear to be possible. You can, however, store a GUID as a Text field in MS Access. If you're using a DataGrid, you can use Guid.NewGuid when a new row is created (handle the DataTable.RowChanging and check that Action is DataRowAction.Add - this only works if using a DataSet or DataTable).

Having the client generate the Guid will further ensure that the GUID is unique, since they are mathematically proven to be unique on different machines, but fast generation on a single machine can produce the same GUID (and we've verified that with our own tests).

Mazdak30-Dec-03 19:30

30-Dec-03 19:30

Heath Stewart wrote:
you can use Guid.NewGuid when a new row is created (handle the DataTable.RowChanging and check that Action is DataRowAction.Add - this only works if using a DataSet or DataTable).

Yes Heath.That exactly what I did but it seams some checking happpend before this event and it sho a messagebox that said this field can not be null,Do you want to correct the vale? (or something like this),and then RowChanging fire. Of course my problem is only when user add data in datagrid itself. Frown | :(

Mazy

No sig. available now.

Heath Stewart30-Dec-03 19:39

30-Dec-03 19:39

If you're using a strongly-typed DataSet, it's possible that you might have the DataColumn.AllowDBNull and / or the DataColumn.Unique properties set to false and true, respectively. These conditions might be validated before any events are fired on the underlying rows.

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.

Mazdak30-Dec-03 19:57

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