Answer / 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

Answer / sdfsd

exec storedprocedure parameter
sqlhelper cs=new sqlhelper();
cs.parameter.add("name",type).value=value
cs.execD

Where the viewstate is stored after the page postback?

0 Answers  

---

Explain the differences between Server-side and Client-side code?

2 Answers  

---

can we call web service from the browser?

2 Answers   Keane India Ltd,

---

Life cycle of ASP.NET page when a request is made ?

4 Answers   MMTS,

---

hi i am varinder. i am very eager to learn ASP.net in C#. i am beginer to it. i have refer some books but i found it tuff to understand. their language is tuff. So please tell me the best site or best book to learn ASP.net in C#. i will be very thankful. Varinder

1 Answers  

---

What is Active Directory? What is the namespace for that?

2 Answers  

---

How can we communicate with each server in N-tier Architecture? and what are the methods?

0 Answers   Wipro,

---

Which asp.net objects encapsulate the state of the client and the browser?

0 Answers  

---

What is the asp.net mvc folder conventions? : asp.net mvc

0 Answers  

---

What are the two Layouts supported by a Web form in ASP.NET?

0 Answers   MCN Solutions,

---

How can we identify that the Page is Post Back?

0 Answers  

---

Can you nest updatepanel within each other?

0 Answers  

---