code_junkie

Last inserted record ID problems using typed DataSet and DataGridView

Nov 13th, 2011
77
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.14 KB | None | 0 0
  1. Public Sub InsertSupplier(ByVal SupplierObject As Supplier) Implements ISupplierRepository.InsertSupplier
  2. SupplierObject.SupplierID = MyBase.ExecuteNonQueryWithReturnValue("usp_Northwind_InsertSupplier", SupplierObject.CompanyName)
  3. End Sub
  4.  
  5. USE [Northwind]
  6. GO
  7. /****** Object: StoredProcedure [dbo].[usp_Northwind_InsertSupplier] Script Date: 1/1/2009 10:59:01 AM ******/
  8. SET ANSI_NULLS ON
  9. GO
  10. SET QUOTED_IDENTIFIER ON
  11. GO
  12. CREATE PROCEDURE [dbo].[usp_Northwind_InsertSupplier]
  13. @CompanyName nvarchar(40)
  14. AS
  15. INSERT INTO dbo.Suppliers
  16. VALUES (@CompanyName)
  17.  
  18. RETURN @@Identity
  19.  
  20. Public Function ExecuteNonQueryWithReturnValue(ByVal storedProcedureName As String, ByVal ParamArray parameterValues() As Object) As Object Implements Interfaces.IRepository(Of T).ExecuteNonQueryWithReturnValue
  21. Dim Output As Object
  22. Dim db As Database = DatabaseFactory.CreateDatabase()
  23. Dim dbCommand As Common.DbCommand = db.GetStoredProcCommand(storedProcedureName, parameterValues)
  24. db.ExecuteNonQuery(dbCommand)
  25. Output = CType(db.GetParameterValue(dbCommand, "@RETURN_VALUE"), Object)
  26. Return Output
  27. End Function
  28.  
  29. CREATE PROCEDURE YourSP
  30. (@ID int OUTPUT, ...
Add Comment
Please, Sign In to add comment