Hi friends,

I need to know how to give confirmation when deleting row in datagrid?

Could anybody answer me?

__________________
Krishnakumar.S
Beware of Everything -that is un true; stick to the Truth shall succeed slowly but steadily

we can add the javascript to each and every Delete link button (one per row). We will do that in ItemDataBound event handler.

See the following code...

Here we check whether the item (row) is of type Item or AlternatingItem. We then add DHTML OnClick event handler that calls a client side function getconfirm().

The Confirmation JavaScript function

This function displays a javascript confirmation dialog to the user. If user clicks on Ok the function returns true and the form is posted back as usual. If user clicks on cancel it returns false indicating event cancellation. This will cancel the postback of the form.

__________________
S.VinothkumaR
Behind me is infinite power,
Before me is Endless Possibility,
Around me is Boundless Opportunity,
Why should I fear!

You can add confirm message to any html tag like this,

__________________
S.VinothkumaR
Behind me is infinite power,
Before me is Endless Possibility,
Around me is Boundless Opportunity,
Why should I fear!

You notice that I added a TemplateColumn and I wrote myself the ItemTemplate
the item template has the following code
<a id="lnkDelete" href='<%#DataBinder.Eval(Container,"DataItem.Produ ctID")%>'
onclick="return confirm('Are you sure you want to delete')"
onserverclick="DeleteProduct"
runat="server">delete</a>
------------------------------------------------------------------
the DeleteProduct Method code is here:
protected void DeleteProduct(object s, System.EventArgs e)
{
//Cast the s object to an HtmlAnchor, I'm sure it is an HtmlAnchor
HtmlAnchor deleteLnk = (HtmlAnchor)s;

//Retrive the ProductID from the HRef attribute
int productID = int.Parse(deleteLnk.HRef);

//Perform delete procedure.
string deleteSql = "DELETE FROM Products WHERE ProductID="+productID;
SqlCommand cmdDelete = new SqlCommand(deleteSql,myConn);
myConn.Open();
cmdDelete.ExecuteNonQuery();
BindGrid();
myConn.Close();
}
-------------------------------------------------------------------------
(or)


private void BindGrid()
{
SqlCommand cmd = new SqlCommand("SELECT * FROM Products",myConn);
dgItems.DataSource = cmd.ExecuteReader(CommandBehavior.CloseConnection) ;
dgItems.DataBind();
if(dgItems.Items.Count!=0)
{
//string that hold the javascript confirm message
string confirm = "return confirm('Are you sure you want to delete?')";
foreach( DataGridItem item in dgItems.Items)
{
LinkButton deleteBtn=(LinkButton)item.Cells[2].Controls[0];
deleteBtn.Attributes.Add("onclick",confirm);
}
}
}