You need to write a procedure something similar to what I have done
Database
Download the database SQL using the Link below.
Download SQL
Stored Proocedure
CREATE PROCEDURE `Customers_CRUD`(
pAction VARCHAR(10)
,pCustomerId INT
,pName VARCHAR(100)
,pCountry VARCHAR(100)
)
BEGIN
-- SELECT
IF pAction = "SELECT" THEN
SELECT CustomerId,
Name,
Country
FROM Customers;
END IF;
-- INSERT
IF pAction = "INSERT" THEN
INSERT INTO Customers(Name, Country)
VALUES (pName, pCountry);
END IF;
-- UPDATE
IF pAction = "UPDATE" THEN
UPDATE Customers
SET Name = pName, Country = pCountry
WHERE CustomerId = pCustomerId;
END IF;
-- DELETE
IF pAction = "DELETE" THEN
DELETE FROM Customers
WHERE CustomerId = pCustomerId;
END IF;
END
Calling the SP
-- SELECT
CALL `ajaxsamples`.`Customers_CRUD`("SELECT", NULL, NULL, NULL);
-- INSERT
CALL `ajaxsamples`.`Customers_CRUD`("INSERT", NULL, 'James', 'Moorey');
-- UPDATE
CALL `ajaxsamples`.`Customers_CRUD`("UPDATE", 5, 'John', 'Moorey');
-- DELETE
CALL `ajaxsamples`.`Customers_CRUD`("DELETE", 5, NULL, NULL);
Calling SP in ASP.Net
This is already explained here.