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

How to creating a SqlCommand Object?

1133

---

What is datatable in ado.net?

961

---

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

965

---

Which architecture does Datasets follow?

1035

---

What is ado.net and its features?

972

---

Explain how to create dynamic gridview?

966

---

What is ole2 format?

900

---

What is the purpose of using adodb?

955

---

How to bind the controls(best practice) comboboxes to the data in the dataset?

1041

---

What are the namespaces used in ado.net for data access?

976

---

Difference between sqlcommand and sqlcommandbuilder?

1110

---

What are the ado.net connection pooling parameters?

971

---

What is ado data control?

991

---

What is serialization and de-serialization in .net? How can we serialize the dataset object?

960

---

How do I delete a row from a DataTable?

1150

---