Hi I'm developping an application and I need to make two types of inserts into a table with the id field defined as identity. In first insert I need to insert the id field by literally setting its value (with setting identity_insert to on). In the second insert I need sql server to set value for me, I don't specify it in the insert clause. How can I achieve it with Typed DataSet created in Visual Studio? Currently I am able to implement only one behaviour at once. When I perform Update using TableAdapter it always runs Insert method. Can I have two different Insert methods and chose which one I want to use during current Update? Is there any other way than creating two DataSets for different types of Insert or creating a stored procedure that would manage Inserts to a table? This issue involves almost every table in the database so temporary solution with e.g. two DataSets is rather not an option.
Thanks for the help in advance. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "DotNetDevelopment, VB.NET, C# .NET, ADO.NET, ASP.NET, XML, XML Web Services,.NET Remoting" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://cm.megasolutions.net/forums/default.aspx <p><a href="http://feeds.feedburner.com/DotNetDevelopment";><img src="http://feeds.feedburner.com/~fc/DotNetDevelopment?bg=99CCFF&fg=444444&anim=1"; height="26" width="88" style="border:0" alt="" /></a></p> -~----------~----~----~----~------~----~------~--~---
