I have a product table with two three keys, productBrand,productCode and ProductSerial. The structure is attached .

I would like to know how can I update and delete the records using the grid.

Table Structure

CREATE TABLE `products` (

`ProductBrand` VARCHAR(20) NOT NULL,

`productcategory` VARCHAR(35) NOT NULL,

`productCode` VARCHAR(15) NOT NULL,

`productSerial` VARCHAR(50) DEFAULT NULL,

`productName` VARCHAR(70) NOT NULL,

`productDescription` TEXT NOT NULL,

`productInstock` SMALLINT NOT NULL,

`productOrder` SMALLINT DEFAULT NULL,

`productTransit` SMALLINT DEFAULT NULL,

`productDispute` SMALLINT DEFAULT NULL,

`productText` VARCHAR(4000) DEFAULT NULL,

`productHtml` TEXT DEFAULT NULL,

`productImage` BLOB DEFAULT NULL,

`productstatus` VARCHAR(1) DEFAULT NULL,

PRIMARY KEY (`productbrand`,`productCode`,`productSerial`),

INDEX (`productName`),

INDEX (`productbrand`),

INDEX (`productcode`),

INDEX (`productserial`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;



Thanks in advance for your help.