Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Connected & Disconnected Dataset
Message
General information
Forum:
ASP.NET
Category:
ADO.NET
Miscellaneous
Thread ID:
00738411
Message ID:
00738827
Views:
13
Thank you Stephane


>Well i'm not sure what kind of sample you're looking for, basically you need the tables to have a Identity column (int set to IDENTITY) and a timestamp column type timestamp. You're using SQL Server right?
>
>Then your updates statements would be like this:
>
>SqlConnection cn = new SqlConnection(connectString);
>string sql = "update myTable set field1 = 'someValue', field2 = 'moreValue'....
>   where Timestamp_column = @par1 and Identity_column = @par2";
>
>SqlCommand cmd = new SqlCommand();
>cmd.CommandType = CommandType.Text;
>
>// set the parameters : SqlParameters = new......
>...
>
>int result = cmd.ExecuteNonQuery();
>...
>
>
>I am still learning .NET, so i hope others can jump in to get you more samples.
>
>>Stephane,
>>Can you please send me some example about your approach and (Identity_column & TimeStamp).
>>
<><><><><><><><><><><><><><><><><><><><>
<><> REMEMBER,,,,KNOWLEDGE IS POWER <><>
<><><><><><><><><><><><><><><><><><><><>
Previous
Reply
Map
View

Click here to load this message in the networking platform