PeterBaileyUk
asked on
run stored procedure from vb.net
I would like to run the stored procedure but I dont need any data from it as its doing an update and some housekeeping.
how do i do that without having to create a reader etc.
normally i would do this:
how do i do that without having to create a reader etc.
normally i would do this:
dtWords = New DataTable
Dim connectionString As String = ConfigurationManager.ConnectionStrings("Dictionary").ConnectionString
Using conn As New SqlConnection(connectionString)
Using cmd As New SqlCommand(StrProcName, conn)
cmd.CommandTimeout = 0
cmd.CommandType = CommandType.StoredProcedure
conn.Open()
cmd.Parameters.AddWithValue("@Client", StrClient)
If OpShortDescCars.Checked = True Or OpShortDescBikes.Checked = True Or OpShortDescLcv.Checked = True Or OpShortDescOthers.Checked = True Then
cmd.Parameters.AddWithValue("@VCategory", StrVehCat)
ElseIf OpShortDescCarsLcvOthers.Checked = True Or OpShortDescBikesQuads.Checked = True Then
cmd.Parameters.AddWithValue("@VCatSuper", StrVehCat)
ElseIf OpShortDescAll.Checked = True Then
' no params
End If
Dim reader As SqlDataReader = cmd.ExecuteReader()
dtWords.Load(reader)
End Using
End Using
Return dtWords
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
so to this
Public Sub CreateAllStrs()
Dim StrProcName As String
StrProcName = "usp_CreateStrStringsPlusTidyup"
Dim connectionString As String = ConfigurationManager.ConnectionStrings("Dictionary").ConnectionString
Using conn As New SqlConnection(connectionString)
Using cmd As New SqlCommand(StrProcName, conn)
cmd.CommandTimeout = 0
cmd.CommandType = CommandType.StoredProcedure
conn.Open()
cmd.ExecuteScalar()
End Using
End Using
End Sub
ASKER
thank you
ASKER
Open in new window