hi,

    I have two tables and both are referenced. I want to perform Edit/Delete.
I am displaying all the record in table format.

checkbox rollno batchno color_code(select control) qty

The user will check the checkbox to edit/delete the corr record. Rollno, batchno, qty are textboxes. I want to assign same name to all columns(rollno to txtRollNo) for all records. When i submit the form, how can i identify which record to modify/delete coz i want to do only the checked records.

Thanx in advance

You cannot do edit and delete actions in a single submit, I think. They can select some records and submit them for edit or delete but not both.

If that is the case, you can two buttons with same name(btnAction) and different values viz. Edit and Delete. When edit button is clicked, only the value "Edit" will be passed to the action page. Similarly, when delete button is pressed, only value "Delete" will be passed to action page. From the value of Request.Form("btnAction"), you can know which action (edit / delete) is required by the user.

Hope that helps

Hello madhu,

  You didnt catch my point. I have two button for delete and edit.
My aim is to check the checkbox and click Edit button to edit and delete button to delete.
The form is generating dynamically by retrieving from the database.
I am not sure that howmany records are there in the database.
So, i want to assing same to all controls(each field).
Ex, rollno -> txtRollNo
batchno -> txtBatchNo

If you select all checkboxes, there is no problem.
If you select random(1, 3, 4, 5) checkboxes, hown can i read particular data to edit.
When you submit the form all the data is submitted.
For rollno, 12, 23, 12, 23, 45, 45 (if there are 6 records). Coz i assigned same to rollno textboxes.


Thanx

Dear simply you assign the ID value to the check boxes and submit to the next page either it is Edit or Delete page But pass the value of check box



(*_*)

Numan
--------------------------------------------------
It is not important what you get But important is how you got it

tsimsha,

You better name all those controls with some uniqueness. Say, append the corresponding Primarykey value to txtRollNo. That way you can have different names for it all. And while referencing that after submit, use the same way to pick the data update the table.

Anyways, you got to have the same name for all check boxes listed there, so that all those valules come in a comma separated string, which can be used for concatenating with the control names and thus making update possible.

Hope that helps.
Cheers!

_________________________
- Vijay G
Strive for Perfection

Numan's idea is correct. You can use the same name for the checkboxes. But give different values for each checkbox. The ID of the record is the best choice for values.

In that case, you will get values of all selected checkboxes as a comma seperated string in the action page.

If you use unique names, you need to extract the ID of the record and then combine them to form this comma seperated values. I think, we can make the system do that work if we follow Numan's idea. This list can be directly used in the delete query - delete from <table name> where <id> in <comma seperated list>

Hi all,

  Thank you very much. I got it from your suggesions.