Answer / shanthi bhushan

Trigger is procedure which is automatically fires when we
modify the data in table(After i.e.,Data Manipulation wiil
be one)

Answer / naresh

Trigger is just like a storedprocedure but the only
difference is it is automatically call when the event ocour
or fire.

Answer / srividhya.s

Triggers are simply stored procedures that are executed
automatically by the database whenever
some event (usually a table update) happens.

sample:

CREATE [OR REPLACE]
TRIGGER trigger_name
BEFORE (or AFTER)
INSERT OR UPDATE [OF COLUMNS] OR DELETE
ON tablename
[FOR EACH ROW [WHEN (condition)]]
BEGIN
DBMS_OUTPUT.PUT_LINE(’Ur message to be
displayed ’ :NEW.NAME);
END;

Answer / roopesh kumar

A trigger is a DB object like proc. or func. stored in data
dictonary. It will fire implicitly with event on which it
written.

Main use of a trigger are

-- we can take backup of data.
-- Can be used for auditing purpose.
-- For applying complex bussiness rule.
Etc.

Answer / srini

Trigger is a special kind of stored procedure executed
certain event occurs.

Answer / sudha

trigger is stored procedure it execute the one event
when another event is happenning for example it can do the
insert operation as well as select operation.

Answer / monika mudgal

Trigger are events that perform some action.

Answer / aarthi

trigger is used nto change the control from one state to
another

I loaded the dataset with a table of 10 records. One of the records is deleted from the backend, how do you check whether all the 10 records were present while updating the data(which event and steps) and throw the exception 28 can datareader hold data from multiple tables?

0 Answers  

How to retrieve the third table value from the data set?

2 Answers   Network Solutions,

What providers does ado.net uses internally ?

3 Answers   Digital GlobalSoft,

How to load multiple tables into a dataset?

0 Answers  

What is partial class?

0 Answers  

What are the different ado.net namespaces are available in .net?

0 Answers  

What is the DataTableCollection?

0 Answers  

What is the difference between SqlCommand and SqlCommandBuilder?

0 Answers  

Can we do database operations without using any of the ado.net objects?

0 Answers  

OleDbDataAdapter ole=new OleDbDataAdapter(new OleDbCommand ("select * from login",oleDbConnection1)); OleDbCommandBuilder cmd=new OleDbCommandBuilder(ole); ole.Fill(dataSet11,"login"); DataRow drow=dataSet11.Tables ["login"].NewRow(); drow[0]=textBox1.Text; drow[1]=textBox2.Text; drow[2]=textBox3.Text; dataSet11.Tables["login"].Rows.Add (drow); ole.UpdateCommand=cmd.GetUpdateCommand(); ole.Update(dataSet11,"login"); MessageBox.Show("one row added"); this gives exception.how to solve it

1 Answers   Nimaya,

what is a dataview?why is it used for?

4 Answers   Choice Solutions,

What is the advantage of ado.net?

0 Answers