<div>
Are you using DataAdapters to update the DB? If so, use the RowUpdating event<br />
<br />
<a href="http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqldataadapter.rowupdating.aspx" rel="ugc">http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqldataadapter.rowupdating.aspx</a><br />
<br />

</div>


Are you using DataAdapters to update the DB? If so, use the RowUpdating event

http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqldataadapter.rowupdating.aspx [http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqldataadapter.rowupdating.aspx]



<div>
It works great! <br />
<br />
Thank you.
</div>


<div>
<div class="content wysiwyg-content">
I want to add some logging code to records that has been change or added.<br />
<br />
I've add the followings fields to my tables<br />
<br />
Syscreator - int<br />
Syscreated - datetime<br />
Sysmodifier - int<br />
Sysmodifed -datetime<br />
<br />
How can i automatic update all records with this info if there is something added or changed.<br />
<br />
I user vb.net and a SQL server.<br />
<br />
On form close I check if the is something changed or added or deleted.<br />
<br />
Hope to here from somebody!<br />
<br />
Bart
</div>
</div>


I want to add some logging code to records that has been change or added.

I've add the followings fields to my tables

Syscreator - int
Syscreated - datetime
Sysmodifier - int
Sysmodifed -datetime

How can i automatic update all records with this info if there is something added or changed.

I user vb.net and a SQL server.

On form close I check if the is something changed or added or deleted.

Hope to here from somebody!

Bart

Need help with saving saving syscreator and sysmodifier on records how as been change added?

Visual Basic .NET (VB.NET) is an object-oriented programming language implemented on the .NET framework, but also supported on other platforms such as Mono and Silverlight. Microsoft launched VB.NET as the successor to the Visual Basic language. Though it is similar in syntax to  Visual Basic pre-2002, it is not the same technology,

Visual Basic.NET

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.

Microsoft SQL Server 2005

The .NET Framework is not specific to any one programming language; rather, it includes a library of functions that allows developers to rapidly build applications. Several supported languages include C#, VB.NET, C++ or ASP.NET.