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

What is asp.net response object?

0 Answers  

---

What does the .webpart file do?

0 Answers  

---

What is .netmodule and how is different from .dll and .exe

2 Answers   NIIT,

---

i wand basic interview based questions in asp.net and vb.net

0 Answers   Legio Infotech,

---

Explain the overview of asp.net?

0 Answers  

---

can we store textbox and com components in viewstate?

4 Answers   Microsoft,

---

Which control would you use if you needed to make sure the values in two different controls matched?

4 Answers   Siebel Systems,

---

What are asynchronous callbacks ?

6 Answers   Accenture, BirlaSoft,

---

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

2 Answers  

---

Can the unique key be null?

0 Answers  

---

where is declare global variable in asp.net and what is use of global variable

3 Answers  

---

Explain the advantages of caching?

0 Answers  

---