how to do this??????Urgent

everest · August 25th, 2005, 03:08 PM

am showing a database table in a datagrid. I have added a delete event in it. can any one tell me how do i get the value of the cell of the selected row. For example, i am showing value in grid like:
Delete ID Name Address
[u]Delete</u> 1 A abc st.
[u]Delete </u> 2 B xyz st.
[u]Delete</u> 3 C lll ave

In the above scenario, how do i get the value 1 when user clicks on the delete button for the first row

thanks

melvik · August 29th, 2005, 11:40 PM

u have e (DataGridCommandEventArgs) in DeleteCommand of ur DataGrid.
to get the Index item of Selected Delete u can use

Code:

e.Item.ItemIndex

HTH.

Always:),
Hovik Melkomian.

everest · August 30th, 2005, 07:42 PM

This will give you the row index, but i need the value of ID field in order to delete it from database. any suggestions

melvik · August 31st, 2005, 07:24 AM

so use this code in ur DeleteCommand function

Code:

dataSet_Name.table_Name.Rows[e.Item.ItemIndex].Delete();

HTH.

Always:),
Hovik Melkomian.