This is what if ended up with and it seems to work fine. However I am wondering if there is something that I can add that will tell me the procedure finished the task?
Code:Dim cn As SqlConnection = New SqlConnection cn.ConnectionString = Con cn.Open() Dim cmd As SqlCommand = New SqlCommand("sp_InsertInv", cn) cmd.CommandType = CommandType.StoredProcedure Try cmd.ExecuteNonQuery() Catch ex As Exception MessageBox.Show(ex.Message & vbNewLine & _ ex.Source, "Data Error", MessageBoxButtons.OK) End Try




Reply With Quote