Answer Posted / guest

@@rowcount gives the number of rows given as an result of
previous query ran.

Create procedure get_emp_count ( @emp_id int)
As
Select * from emp where emp_id =@emp_id

If @@rowcount = 0
Begin
Select 'no rows with emp_id= '
Select @emp_id
End

What is data adapter in ado.net with example?

1046

---

What is the meaning of object pooling?

1238

---

What is namespace in ado.net?

1022

---

What is datasource in ado.net?

1074

---

Define partial class?

984

---

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

993

---

What is connection string?

1009

---

What is disconnected scenario in entity framework?

1119

---

What is dbcontext and dbset in entity framework?

938

---

What is method to get XML and schema from Dataset? getXML() and get Schema ()

976

---

Which property is used to check whether a DataReader is closed or opened?

1052

---

What is ado.net in vb net?

929

---

What is ado and dao?

962

---

What is the difference between ADO and ADO.Net?

1086

---

How to find the given query is optimised one or not?

979

---