when deleting a row from a datagrid how do i get the cell ( 0 ) value

[Shaminda Illangantilaka]

when deleting a row from a datagrid how do i get the cell ( 0 ) value of the
spcific row, to put that value inside the SQL statement under the WHERE
condition

 

[Sonu Kapoor]

Cell 0 is usually the column which contains the delete/update buttons. I am
assuming that you have an ID and want to delete with the ID in the where
clause. For that purpose I suggest to set the ID in the DataKeyField property
and retrieve it in the delete command via:
DataGrid1.DataKeys(e.Item.ItemIndex) which you can use for your SQL.


--
Sonu Kapoor - [MCP]
ASP.NET Moderator
WebSite: http://www.Kapoorsolutions.com
Blog: http://www.Kapoorsolutions.com/blog/
ASP.NET News: http://www.Kapoorsolutions.com/reblogger/

 

[Shaminda Illangantilaka]

Yes, Thanks for the info..I will try that..

Cell 0 is usually the column which contains the delete/update buttons. I
am
assuming that you have an ID and want to delete with the ID in the where
clause. For that purpose I suggest to set the ID in the DataKeyField
property
and retrieve it in the delete command via:
DataGrid1.DataKeys(e.Item.ItemIndex) which you can use for your SQL.


--
Sonu Kapoor - [MCP]
ASP.NET Moderator
WebSite: http://www.Kapoorsolutions.com
Blog: http://www.Kapoorsolutions.com/blog/
ASP.NET News: http://www.Kapoorsolutions.com/reblogger/

when deleting a row from a datagrid how do i get the cell ( 0 ) value of
the
spcific row, to put that value inside the SQL statement under the WHERE
condition