Running a store proceedure in SQL Server 2000

[bkedersha]

Running a stored procedure in SQL Server 2000

 

I created a new stored procedure in SQL Server 2000. How do I get ASP.Net to run one or many stored procedures when a user clicks on a button? :confused: :confused:

Edited August 24, 2005 by bkedersha

[hrabia]

You have to use ADO.NET or extra framework (like Enterprise Library - Data Application Block). Look for tutorials in internet.

[mike55]

Here is an example:

dim cmdLogin as new sqlCommand

'Sets the cmdLogin to a new instance and the type of Stored procedure.
cmdLogin = New SqlCommand("<<procedureName>>", cnConn)
cmdLogin.CommandType = CommandType.StoredProcedure

'Add your parameters
cmdLogin.Parameters.Add(New SqlParameter("@UserEmail", SqlDbType.NVarChar, 254))
cmdLogin.Parameters("@UserEmail").Direction = ParameterDirection.Output
cmdLogin.Parameters("@UserEmail").Value = UserEmail

'Call the execute statement.
cmdLogin.ExecuteNonQuery()