00thilani wrote: both have same attributes Attributes? Do you mean "columns"? 00thilani wrote: superkeys I am unfamiliar with that term. Do you mean "primary key"? Or perhaps "foreign key"? Perhaps this will work: SELECT curr_val, Items_Rs - Items_Is AS items_difference, Amount_Rs - Amount_Is AS difference_amount FROM ( SELECT curr_val, count(*) AS Items_Rs, SUM(amount) AS Amount_Rs FROM RECEIVE WHERE coin_note='n' GROUP BY curr_val ) AS Received INNER JOIN ( SELECT curr_val, count(*) AS Items_Is, SUM(amount) AS Amount_Is FROM ISSUE WHERE coin_note='n' GROUP BY curr_val ) AS Issued ON Issued.curr_val = Received.curr_val Scottish Developers events: * .NET debugging, tracing and instrumentation by Duncan Edwards Jones and Code Coverage in .NET by Craig Murphy * Developer Day Scotland: are you interested in speaking or attending? My: Website | Blog

you have to add code on click of save button in this code ypou will traverse all the rows one by one and will save data of each row one by one. or you can first take data to save in a string for each row data will be comma seperated and rows will be semicolon seperated and at the time of saving you can get sepearate them and then save one row each time.

00thilani wrote: How to excecute stored procedure by using c# application in run time? Have you searched anywhere yet? The following classes will be useful to you: * SqlConnection[^] * SqlCommand[^] * SqlDataReader[^] The following properties and methods on the command will be useful to you: * CommandType[^] * ExecuteReader()[^] If you try something and it doesn't work then show us what you've tried and we can help you out. There are plenty examples in the links that I gave you. If you are still stuck, show us what you did and we can correct it for you. Scottish Developers events: * .NET debugging, tracing and instrumentation by Duncan Edwards Jones and Code Coverage in .NET by Craig Murphy * Developer Day Scotland: are you interested in speaking or attending? My: Website | Blog