Stored Procedures

[miles]

Hallo,

Zou iemand mij kunne vertellen hoe ik in Visual Studio met ASP.NET of VB.NET een Stored Procedure makkelijk kan aanroepen?

Gr. Miles

 

[beheer25]

Uit de MSDN help van VS2003:

Dim backUpDB As SqlClient.SqlCommand
backUpDB = New SqlClient.SqlCommand
backUpDB.CommandType = CommandType.StoredProcedure
backUpDB.CommandText = "BackUpDBSproc"
backUpDB.Connection = SqlConnection1

SqlConnection1.Open()
backUpDB.ExecuteNonQuery()
SqlConnection1.Close()

Of als je waardes terugverwacht:
This example assigns a stored procedure to a SqlCommand object, executes it, and returns its data to a SqlDataReader. The same concept applies for the other .NET Framework Data Providers.
Example

Dim CustOrderHist As SqlClient.SqlCommand
CustOrderHist = New SqlClient.SqlCommand()
CustOrderHist.CommandType = CommandType.StoredProcedure
CustOrderHist.CommandText = "CustOrderHist"
CustOrderHist.Connection = SqlConnection1

Dim sparam As SqlClient.SqlParameter
sparam = New SqlClient.SqlParameter()
sparam.ParameterName = "@CustomerID"
sparam.SqlDbType = SqlDbType.NChar
CustOrderHist.Parameters.Add(sparam)

Dim Reader As SqlClient.SqlDataReader
CustOrderHist.Parameters("@CustomerID").Value = "ALFKI"
SqlConnection1.Open()
Reader = CustOrderHist.ExecuteReader()
' Insert code to read through the datareader.
SqlConnection1.Close()

Grtz,