Create a Master Detail form

ssmsiqbal@gmail.com

New member
Joined
Apr 24, 2010
Messages
1
Programming Experience
Beginner
Hi Every Body,
I am beginner, that's why i am writing this type of question. My problem is as follows:
I have two tables:
Order_Master and Order_Details
Order_Master is having only three Columns : ORder_No, Order_Date, Total_Amt
Order_detail is having: Order_no, Item_description, quantity, Rate, Amount

I am using Group box for Master entry and for Detail Data Grid is there.
Process:
After data entry of Master, there is one AddRow Button, when the user press AddRow button, a panel will Bring to Front with all details column except order_no as bcoz order_no will be the same as of master order_no. after entry in PanelAdd there is save button, when user press that button, it will add one row in datagird.. and so on...
After entering all the details just down there is one save button is there which save the data into database and gives the message "Record Saved Successfully into DataBase".

if it new, WHen user gives the order_no it will display the data if it is stored in database otherwise gives an error message "Data Not Found"..

Please provide me the code.....
I am having a button: BtnAddRow: To Panel Bring to Front
BtnAddSave: It is placed in Panel, which is used for Add a row in DataGrid
BtnSave: which is used for insert the data into the database....
BtnUpdate: Update Button that will allow the user to save any changes made to the datagrid back to the database...
Also, provide me the necessary code to calculate the total amount of the displayed items...
So, pls help me to write code button wise...

Please help me........

Thanks in Advance.....
 
Back
Top