Answer Posted / ashish sharma

create table uname
(
id int,
uname varchar(10)
)

create trigger insert_Uname
on uname
for insert
as
declare @nm varchar(10)
select @nm = uname from inserted
print @nm

so when we insert any record in the above table
the username will be get printed.

Explain the difference between data reader and data set?

483

---

Define table relations?

553

---

What are the ado.net objects?

510

---

Which name space is used to get assembly details?

515

---

What is difference between executenonquery and executequery?

468

---

---

What are the data access namespaces in .NET?

628

---

Which provider is used to connect ms access, oracle, etc…?

522

---

What is the difference between statement and preparedstatement interface?

563

---

What provider ado.net use by default? Explain the role of data provider in ado.net?

523

---

What are the steps you will take to improve performance?

459

---

Explain why canot we use multiple inheritance and garbage collector paralelly in .net?

587

---

What is ado.net in vb net?

498

---

What is commandbuilder in ado.net?

522

---

What are all the different methods under sqlcommand?

516

---

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?

549

---