Quote:data's view in datagrid view & check box attached for selecting rows.
But when i am executing query all data of tblA copying to tblB
but i want only selected row need to copy not all.
Look at your code, how do you tell the procedure which record is to be copied ?
Quote:I am New here & little bit wired , can you please suggest which parameter need to pass
What do you display in datagrid ?.
How do you link a row in datagrid with the record it display ?
Assuming SerialNumber is the Id or record, Do you display it in DataGrid ? Do you keep track of which row in Datagrid is linked to record Id ?
On you check a Datagrid row is checked, you need to get the record Id and then call the stored procedure with the Id as parameter.