How to update master details data and stock for purchase

Hello , 

check you INBOX here...

Hi No its not like tat. Edit button is to just show the contents of Grid to textbox and combobox above. The  "Update" button is for updating that particular details part(updating temprorily to Grid with new values), and "Update Bill" button is for updating the whole Delivery Memo. My question is when i make changes into the "Qty" i will have to update it to stock, how and when i should update the stock "either after clicking just the "Update" Button or after "Update Bill" button clicked. If u suggest to do after clicking "Update Bill" Problem will be about how to keep hold of that "newStock", if there are more than one rows in Grid.

edit button in datagrid is for to update the row right ?

your question is to update the whole table before binding in datagrid or without click on edit button ??

Hi sorry for making you confused. I just need to update the form to the database. This form is for editing or say modifying purpose.
I am giving the gridview section for you. If you need any thing for that let me know.
Thank you.

Hi , 

can you show me grid section ??

you want to update the griddata before loading??do you want to update data on the button click (view detail) and then show in the datagrid ??

what data you want to update do you want to update the data after purchase ?
 
you are explaining much but please put only important description . no need to describe all describe only the prob part . 

Hi Thanks for the reply. Actually the system i am preparing is a bit different, the stock is maintained on delivery memo and not on sales. This is the way my client is operating as the delivery memo is given to Sales agent. He has to do nothing about Sale bill ( quite unusual but true). So after purchasing material i need to add the stock and after delivery memo i need to reduce the stock. Same is the case with Credit Note as well. I am attaching the screen shot of the procedure i am doing.

In this form there u can see the master detail form, i enter unique invoice no and hit View Det. After that i retrive all the details (master :--- GL Name, Camp , Branch, date , book invoice no) using the same invoiceno i retrive details part and show in the grid. Master things can be updated easily but for details i hit Edit button on the grid and all the details come  up in the above prodtype, name,qty rate, freebag, i makes changes then hit button written "New" (it name changes to Update on View Det click ). After that i update the current row of the data grid. Now my question is before showing into the data grid shall i update the new stock which got changed or below that Amount there are two more buttons for updating whole Invoice where Whole invoice will be updated and Cancel for canceling the updation. So when should i update the stock and whole bill. while updating to grid i calculate the new stock.
Thanks in Advance.
Hope the things are clear now. If there is another way out to this plz let me know.

Hello , 

Can you please tell me why you want to update the stock  table and can you show me the screen shot of your table or datagridview ??

Hi thanks for the reply. I am giving the table details as u asked for.
Actually the issue is i am able to update the master and detail table easily but issue is coming for updating the stock table which just contain the itemid, itemname and currentStock fields. Actually i was thinking of situation say if i first update stock table and if any problem arise and comp shuts down or hangs then just stock will get updated and  proper master and details will not be updated.
So please guide on this situation, or give a solution about when and how i should update the stock and tables.
Thanks in advance.
The table structure is as below.


--
-- Table structure for table `deliverymemodet`
--

CREATE TABLE IF NOT EXISTS `deliverymemodet` (
  `deliveryMemoId` int(5) NOT NULL,
  `prodName` varchar(50) NOT NULL,
  `productType` varchar(50) NOT NULL,
  `prodQty` int(5) NOT NULL,
  `prodRate` double(15,2) NOT NULL,
  `amount` double(15,2) NOT NULL,
  `freeBagType` varchar(50) NOT NULL,
  `freeBags` int(4) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `deliverymemomast`
--

CREATE TABLE IF NOT EXISTS `deliverymemomast` (
  `invoiceNo` int(5) NOT NULL AUTO_INCREMENT,
  `bookDMNo` int(5) NOT NULL,
  `compname` varchar(5) NOT NULL DEFAULT 'AF',
  `fyyear` varchar(10) NOT NULL DEFAULT '13-14',
  `groupLeaderName` varchar(50) NOT NULL,
  `groupLeaderCode` varchar(7) NOT NULL,
  `camp` varchar(50) NOT NULL,
  `branch` varchar(50) NOT NULL,
  `district` varchar(50) NOT NULL,
  `todaysdt` date NOT NULL,
  `dispatchedBy` varchar(50) NOT NULL,
  `vehicleNo` varchar(50) NOT NULL,
  `amountInWords` varchar(300) NOT NULL,
  `totalAmount` double(15,2) NOT NULL,
  PRIMARY KEY (`invoiceNo`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=12 ;

give me table details