How to fetch value of hidden filed from selected row in gridview.

update / insert Hi all, I have a strored procedure which has an update statement to update all student records. But before or after updating all the you have the code which does the actual INSERT or UPDATE. Or you can write a trigger. You can look up how to use triggers in SQL Server Books Online. I would agree on Pete's suggestion to write trigger user attempts to modify the data using some DML(INSERT, UPDATE or DELETE) statements on a table. There are 3 types You can use BEFORE trigger and AFTER trigger in your scenario to keep the old records. Here is the syntax for Sname, Marksecured, [date]) select SSN, Sname, Marksecured , GETDATE() from test2 update test2 set marksecured = 90 where ssn = 1 end Thanks & Regards

two queries(Insert and update) in one stored procedure HI. . . I am using C# and 2005 i would like to write two queries(Insert and update) in one stored procedure. . i have a registration page in be successfully insert at the same time i have to update the email address which i entered in the new record this email address field will be update in the last 10 records simantanesly. . .pls help me. . . If in the table, you can use a trigger in this scenario after the insert, Hi, Not sure why last 10 rows would do some thing like, INSERT INTO <table> . . . and then, UPDATE <table> SET <email column> = <email value> WHERE <auto-incremented column for your reply. . not for 10 rows i have to update company email id in the previously entered records. . . you mean new record insert into the database then you need to update the company email for previous record with the email you 15th record) then which record company email id will be update ? 14th record's company email id ? Tanisha, A stored procedure if it does not. If we refer to the Books Online documentation, it gives examples that are similar to: IF EXISTS

allows the creation of multiple triggers for any given INSERT, UPDATE, or DELETE statement. CREATE TRIGGER trigger_name ON { table | view } [ WITH ENCRYPTION ] { { { FOR | AFTER | INSTEAD OF } { [ INSERT ] [ , ] [ UPDATE ] [ , ] [ DELETE ] } [ WITH APPEND ] [ NOT FOR REPLICATION ] AS [ { IF UPDATE ( column ) [ { AND | OR } UPDATE ( column ) ] [ . . . n ] | IF ( COLUMNS_UPDATED ( ) { bitwise_operator } updated_bitmask ) { comparison_operator } column_bitmask [ . . . n ] } ] sql_statement triggering statements. At most, one INSTEAD OF trigger per INSERT, UPDATE, or DELETE statement can be defined on a table or ALTER VIEW before defining the INSTEAD OF trigger. { [DELETE] [ , ] [INSERT] [ , ] [UPDATE] } Are keywords that specify which data modification statements, when attempted referential relationship specifying a cascade action ON DELETE. Similarly, the UPDATE option is not allowed on tables that have a referential relationship specifying a cascade action ON UPDATE. WITH APPEND Specifies that an additional trigger of an existing additional criteria that determine whether the attempted DELETE, INSERT, or UPDATE statements cause the trigger action(s) to be carried out SQL statements go into effect when the DELETE, INSERT, or UPDATE operation is attempted. Triggers can include any number and kind

to lock the records while updating user other user cannot update How to lock the records if one user is login as well Regards D When multiple users attempt to simultaneously update a record, the database locking model ensures that the update from each user succeeds as a unit, but each update overwrites the previous update. An explicit (pessimistic) locking model prevents unexpected loss of data being edited. The simplest way to investigate this type of scenario is to fire up two instances of Query Analyzer. Use transaction and then use the UPDLOCK hint to use an update lock rather than a shared lock while reading the row hint, see the Locking Hints topic in SQL Server Books OnLine. Here's a link to the topic: http: / / msdn.microsoft library / ms172398(v = sql.90).aspx Regards You can use Update (U) lock mode-> Used on resources that can be updated ReleaseMutex(); } } Hope this will help you !! Regards D For the Update statement you can Lock the Record like below one set

fetch value of hidden filed from selected row in gridview. Scenario: I have a grid view. . the grid view contains hidden hidden field should be retained in viewstate and then when Update button is clicked i want to pass this value as here? Good day you guy ! _ __ __ __ __ __ __ __ __ _ Watch Resident Evil: Afterlife Online Free Surely will. Good day Amanda. Create New Account

the reports.Each station should have the capablity to see online data and reports.How i put these data in website software for this.Which technolgy can i use for this scenario. You can do it by using; 1. Windows Service: To database. 2. ASP.net for website Portal : To show all online data to all stations, you can upload your webite on your database. And users from each station can easily see online data from website. In this website you can show reports this senario better is u make a central database with online web application , where every station have access data and update online at one palce using web application this is best for

computer is offline, or it can be run in an online-only mode without permanently installing anything on the end users automatically replacing any outdated files. The developer can specify the update behavior, and a network administrator can control update strategies (for example, by making an update mandatory). Updates can also be rolled back to a previous what versions to deploy), applications are provided the ability to update themselves by automatically checking to see if there are newer is System.Deployment.Application , which offers CheckForDetailedUpdate , CheckForUpdate , DownloadFileGroup , and Update methods, along with asynchronous versions of the same. Properties such control these and their behavior programmatically at runtime. A Deployment Scenario As the following publishing example highlights, the typical ClickOnce deployment scenario involves no programming. For this example, I loaded a Quoteminder a selection and click Next to then set the applications online / offline availability. You can choose to make an application available online only, or both online and offline. In this example, the

different places when ever we insert a new record or update anything in one server that should be updated in other Rather than creating an app to synchronize, depending on your scenario consider implementing one of these SQL Server 2000 Replication techniques offline for scheduled maintenance without impact on performance and put online again and logs from other nodes can be applied to