Answer Posted / ramesh

This u cn run in sql server

"execute SP_Name Parameter1,Parameter2,..."

Dim SQLDBDataReader As SqlClient.SqlDataReader
Dim SQLDataTable As New DataTable

SQLCmd.CommandText = "GetAuthors"
SQLCmd.CommandType = CommandType.StoredProcedure
SQLCmd.Connection = SQLCon
SQLCmd.Parameters.Add(New SqlClient.SqlParameter
("AuthorName", SqlDbType.VarChar, 100,
ParameterDirection.Input, False, 30, 0, "",
DataRowVersion.Current, "Y%")) SQLDBDataReader =
SQLCmd.ExecuteReader() SQLDataTable.Columns.Add
("AuthorName", GetType(Int32), "") SQLDataTable.Columns.Add
("AuthorLocation", GetType(String), "")

Dim FieldValues(1) As Object 'A Temporary Variable to
retrieve all columns in a row and fill them in Object array

While (SQLDBDataReader.Read)
SQLDBDataReader.GetValues(FieldValues)
SQLDataTable.Rows.Add(FieldValues)

End While

What are the built-in objects in asp.net?

1004

---

What is scope of an application variable in asp.net?

992

---

Why we use asp.net for website development?

900

---

How to turn off cookies for a page?

986

---

What is ispostback property?

915

---

Explain the use of errorprovider control in .net?

965

---

Are xaml file compiled or built on runtime?

976

---

Explain the use of fragment caching.

1100

---

How do you implement sql caching in asp.net?

1062

---

What are the various types of validation controls provided by asp.net?

982

---

Explain an object, class and method.

1000

---

What is the difference between a multi-layer and multi-tier applications?

1021

---

Briefly describe the role of global.asax?

992

---

What is asp.net caching?

1016

---

What is the difference between a candidate key and primary key?

1026

---