Delete Functionality in GridView with Confirmation Using jQuery UI Dialog

��

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE PROCEDURE [dbo].[Products_SelectAll]

AS

BEGIN

  SET NOCOUNT ON;

 

  SELECT

  [ProductID],

  [ProductName],

  [SupplierID],

  [CategoryID],

  [QuantityPerUnit],

  [UnitPrice],

  [UnitsInStock],

  [UnitsOnOrder],

  [ReorderLevel],

  [Discontinued]

  FROM [dbo].[Products]



END

GO





SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE PROCEDURE [dbo].[Products_Delete]

( 

   @productID int

)

AS

BEGIN

  SET NOCOUNT ON;

 

  DELETE FROM [dbo].[Products]

  WHERE [ProductID] = @productID

END

GO