stored procedure

Imports System.Data.SqlClient
Imports System.Data

...

Dim con As New SqlConnection
Dim cmd As New SqlCommand

Try
	With con
		.ConnectionString = ConfigurationManager.ConnectionStrings("dbConnectionString").ConnectionString
		.Open()
	End With

	With cmd
		.Connection = con
		.CommandText = "StoredProcedureName"
		.CommandType = CommandType.StoredProcedure

		.Parameters.Add("@ParamA", SqlDbType.NVarChar, 0).Value = "..."
		.Parameters.Add("@ParamB", SqlDbType.Int).Value = 1

		.ExecuteNonQuery()
	End With
Catch ex As Exception
	' обработка ошибок
Finally
	cmd.Dispose()
	con.Close()
End Try

Imports System.Data.SqlClient

Imports System.Data

...

Dim con As New SqlConnection

Dim cmd As New SqlCommand

Try

With con

.ConnectionString = ConfigurationManager.ConnectionStrings("dbConnectionString").ConnectionString

.Open()

End With

With cmd

.Connection = con

.CommandText = "StoredProcedureName"

.CommandType = CommandType.StoredProcedure

.Parameters.Add("@ParamA", SqlDbType.NVarChar, 0).Value = "..."

.Parameters.Add("@ParamB", SqlDbType.Int).Value = 1

.ExecuteNonQuery()

End With

Catch ex As Exception

' обработка ошибок

Finally

cmd.Dispose()

con.Close()

End Try


Total	3915	685987
Today	9	9
This Week	211	16807
This Month	706	65647

Андрей Арутюнян

персональный блог

Tag Archives: stored procedure

Вызов Stored Procedure с параметрами в SQL Server