Interested to Buy Any Domain ? << Click Here >> for more details...
How to execute a stored procedure.and how to call it form a
asp page
- 2 Answers
- 5694 Views
- I also Faced
- E-Mail Answers
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
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
When should I use server transfer and response redirect?
How does http session work?
What is server transfer?
What is odata in web api?
Explain the concept of MVC Scaffolding?
Explain the features that make asp.net more used framework? : asp.net mvc
Explain one critical mapping?
where can i gather the materials for MCP certification
Securitywise What are the Enhancements in 2.0?
How would you get asp.net running in apache web servers? Explain it's limitations.
What is sta?
Why is it preferred to not use finalize for clean up?
Why cyclomatic complexity is important?
What is custom events? How to create it?
i develop a web application and i gave security setting i.e autherization and athentication now it work properly on my local system , now question is ,is this security setting ie autherization and athentication which i gave in web.config will it be enough strong to secure my application on internet or i have to use some 3rd party tool or software to get security .if yes --how ? if no--what is the alternate?
