I am trying to execute an SQL stored procedure from vb express, i have done this several times and normally its works - with exactly the same code. This time there is no error but the update does not run.
If i execute the procedure in SQL the update works fine.
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim cmd6 = New SqlCommand("stp_UpdateTemptbl_Stops", con)
If con.State = ConnectionState.Closed Then con.Open()
cmd6.CommandText = "stp_UpdateTemptbl_Stops"
cmd6.CommandType = CommandType.StoredProcedure
/****** Object: StoredProcedure [dbo].[stp_UpdateTemptbl_Stops] Script Date: 03/01/2014 21:07:17 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
ALTER PROCEDURE [dbo].[stp_UpdateTemptbl_Stops]
-- Add the parameters for the stored procedure here
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
SET DowntimeCode = s.DowntimeCode
FROM dbo.tbl_MachineData d
INNER JOIN dbo.temptbl_Stops s
ON d.StartDate = s.StartDate
Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.
Microsoft Reports are based on a report definition, which is an XML file that describes data and layout for the report, with a different extension. You can create a client-side report definition language (*.rdlc) file with Visual Studio, and build g…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers.
According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…