Help on deleting a single row from a datagrid & DB (VB.net&sql server 2000)

[navanova]

hi guys, I'm developing an application using vb.net and sql server 2000. the data in the database are shown on the form using datagrid. I want to delete a single row from the datagrid as well as from the database by just pressing a delete button on the form. How do I do that.

Thank you

[dip_developer]

hi guys, I'm developing an application using vb.net and sql server 2000. the data in the database are shown on the form using datagrid. I want to delete a single row from the datagrid as well as from the database by just pressing a delete button on the form. How do I do that.

Thank you

set the DataKey of the Datagrid to the Primary key of your table. Now for selection of records from the datagrid you may put a checkbox to every row of the grid.
while deleting (in DELETE button's Click event handler) check which checkbox is checked ......retreive the datakey and execute a simple sql query like
DELETE FROM myTable WHERE primary_key_value=datakeyvalue

after that Bind the datagrid again.

[berry]

set the DataKey of the Datagrid to the Primary key of your table. Now for selection of records from the datagrid you may put a checkbox to every row of the grid.
while deleting (in DELETE button's Click event handler) check which checkbox is checked ......retreive the datakey and execute a simple sql query like
DELETE FROM myTable WHERE primary_key_value=datakeyvalue

after that Bind the datagrid again.

Hi dip_developer,
Do you have any example? Because i facing the same problem and i don't know how to set the datakey to primary key.
Thank you very much..

[sindhu]

incude primary key column in the grid bound column. set DataKetield of the datagrid to the name of the Primarykey
suppose ur Primary key is Product_ID

set
DataKeyField="Product_ID"

if u don wanna show the primary key column to the user u can set it as invisible
Datagrid1.Columns[0].visible=false;

to get the primary key value
DataGrid1_ItemCommand(object source, DataGridCommandEventArgs e)
{
int ro = e.Item.ItemIndex;
string strID= datagrid1.Datakeys[ro].tostring();//now u have the primary key of the row
string strQuery= "delete from products where Product_ID='+strID+"'";
deleting procedure....




}