Thank you very much for all your replies! I used my original code with joining the table to itself at last. I was looking for some really simple way on how to handle this, but it looks there's no free lunch in T-SQL :) Thanks again for all your valuable input! Michal

final update: all done. the correct way on how to do this was: 1) create a new table with the same columns, change Int32 column to Int64 2) script out all keys and indexes from the old table and create them on the new table 3) make sure the DB is in the simple recovery mode 4) INSERT the rows from the old table into the new table in batches, truncating the LOG after each batch. I was also inserting the identity column values, so I have also set the IDENTITY_INSERT to ON before the batch loop. that's it :) thanks for your help, guys. Michal

You could have an IDictionary and preinitialize it with {typeof(Foo), typeof(Bar< Foo >)}, {typeof(Deh), typeof(Bar< Deh >)...} Mark Churchill Director Dunn & Churchill Free Download: Diamond Binding: The simple, powerful, reliable, and effective data layer toolkit for Visual Studio. modified on Thursday, February 07, 2008 6:13:04 AM

In SQL Server 2005, If not caring about normalization, NEWID() will autogenerate a uniqueidentifier INSERT INTO [GSTDB].[dbo].[TableName] ([Field1]) VALUES (NEWID()) GoodLuck!!

I did this more than once with Windows applications. I wrote the useful code in the constructor of the form, but didn't show the form. In Program.cs , instead of Form.Show(new ManiForm()); I just wrote new MainForm();

sorry again, how did you manage it? how is the performance? greetings, thomas

DataTable.Select() is throwing the same exception. Any ideas? Thanks, Michal

Yep, in .Net 2 theres a new IPC channel specificly for interprocess communication. It's pretty cool in the fact that you can use configuration file to change the channel used so if you want to switch from interprocess to intermachine for some reason you can easily do it :)

OK, so I resolved the issue. It's certainly not the most elegant solution, but it works. I will still appreciate if someone tells me how this should be done "professionally" :) Instead of a lock, I'm using an ordinary while loop. The while loop has an advantage over lock of being able to execute something while it's waiting for a signal. Lock simply sits there and does nothing until the lock is released. So I placed the while loop inside the Form.Closing() event handler. This while loop is blocking the form from closing itself (and thus disposing of itself). Inside this loop (apart from waiting for a signal) I'm executing Application.DoEvents() every 50 ms. This ensures that the Invoke, waiting on the second thread, gets processed. If you've got some better suggestion, please tell me. Thanks, Michal

Thanks for the hint! The final compilable notation would be this: public static T1 GenericMethod(IComparable value1, IComparable value2) where T1 : struct { if (value1.CompareTo((T1)value2) > 0) { return (T1)value1; } return (T1)value2; } Michal

Ok, guys, so the correct answer is that it was not created with the "WITH SCHEMABINDING" option. Now it works ok. Michal

i think the aim of the changes to the resume and suspend methods was that code that executes outside a thread doesn't know what resources the thread is using. If for instance there was a database transaction open in the thread that you are putting to sleep you could create chaos for all users of the application not just the specific instance that the thread is running in. I think the general plan is to check for the state of a variable somewhere in your code while(_running) {DoStuff();} else { ReleaseExpensiveResources(); Thread.Sleep(Timeout.Infinite); } This way the thread won't suspend immedeately but it will suspend cleanly when it releases. Russ

Thank you very much, you helped me a lot by placing a correct name on the issue. Thanks, Michal

That's perfect!!

Yes, that's one of the options I was talking about, but is that really a systematical solution to implement a distinct table for each data type? I don't think so. There must be a way to "join" the individual datatype tables' values' relations in one master table. Thanks, Michal

Great, thank you very much. Michal

Yes. With Int16/32/64 the field is updated automatically. With byte, it's not. The DataSet doesn't even allow the byte field to be set to "AutoIncrement = true". Michal

Rahithi, thanks. It's a COM library I'm referencing, so I can't use the System.Reflection namespace directly I guess. But maybe I could use the System.Reflection namespace to get the external DLL's version by using a non-static method System.Reflection.Assembly.GetModule().ModuleVersionId. But I have yet to find out how to do that. Unfortunately, getting the fileversion information thru FileVersionInfo.GetVersionInfo() doesn't work neither since it keeps returning "1.0.0.0" for a DLL that has a Runtime version of "v2.0.50727". What am I trying to accomplish here is to get the information that's visible in the Properties tab under "Runtime Version" if you click on the appropriate library in the References solution folder. Any idea? Thanks, Michal Kreslik

Actually, after some fiddling, I've found a way how to do it. You don't need to "cast" the type if you use a generic method: class Program { static void MyMethodWithUnknownInputType(T[] Argument) { Console.WriteLine("Current input type is: {0}", Argument.GetType().ToString()); Console.WriteLine("Array contents:"); foreach (T Item in Argument) { Console.Write("{0} ", Item.ToString()); } Console.WriteLine("\n"); } static void Main() { string[] MyStringArray = { "String1", "String2", "String3", "String4", "String5" }; int[] MyIntArray = { 2, 4, 8, 16, 32 }; MyMethodWithUnknownInputType(MyStringArray); MyMethodWithUnknownInputType(MyIntArray); } } The output of this program: Current input type is: System.String[] Array contents: String1 String2 String3 String4 String5 Current input type is: System.Int32[] Array contents: 2 4 8 16 32 Michal -- modified at 18:36 Wednesday 13th September, 2006

Hello MyProject's Properties => Build => At the lower part of the screen check "XML documentaion file" => Specify file location. NB. The file should be at the same location as your dll when you reference to it from another project. Regards:rose: