Deleting a row in datagrid

[looserash]

hi,

Can anyone please help me solve the problem m facing with the datagrid.
I want to delete a row in the datagrid and correspondingly i want that data to be deleted in database .

thanks,

[indianmaestro]

in the datagrid add one more column with links for each row
for the link (onclick event) write the code to delete the row based on the id of that perticular row from the database table

at the end redirect the page to the same page so the item deleted will not be shown in the grid, or else u have to refresh the page to see the effect.

[looserash]

hi,

i have added that delete button column and i have written the code ..its not working and after deleting i have binded the datagrid so hlep me with this.
thank u.

[Rajalakshmimca08]

How to delete a row from datagrid?

button1_click()
{
int i=dataGridView1.CurrentRow.Index;
dataGridView1.Rows.RemoveAt(i);
}

another methos is:

int i=dataGridView1.CurrentRow.Index;
DataTable dt = dataGridView1.DataSource as DataTable;
DataRow rw=dt.Rows[i];
rw.Delete();

[Rajalakshmimca08]

how to delete a row in the datagrid and correspondingly that data to be deleted in database ?


private void delete_Click(object sender, EventArgs e)
{
string ss = dataGridView1.CurrentRow.Cells[0].Value.ToString();
con.Open();
string s = "delete from stutbl where regno='" + ss + "'";
SqlCommand cmd = new SqlCommand(s, con);
cmd.ExecuteNonQuery();
}