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?

 

[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()