asked on

deletecommand current row

How would i put together my delete string for current row

DeleteCommand="DELETE * FROM [forum] WHERE ID= ???

not sure how to add the current row id here?

Pratima

are you using <asp:SqlDataSource

then refer this
http://msdn.microsoft.com/en-us/library/ms972940.aspx

Member_2_5230414

ASKER

i am using

<asp:AccessDataSource ID="AccessDataSource1" runat="server"
DataFile="~/forums/forum.mdb" SelectCommand="SELECT * FROM [forum] WHERE Forum=@forum AND numrep = 0 ORDER by important,lasttime DESC">
<SelectParameters>
<asp:QueryStringParameter Name="forum" QueryStringField="fn" />
</SelectParameters>
</asp:AccessDataSource>

ASKER CERTIFIED SOLUTION

Pratima

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Rose Babu

Hi,

set ID as a DataKeyName for a grid

<asp:GridView DataKeyNames="ID" ID="GridView1" 
     runat="server" AutoGenerateColumns="False" 
     OnRowCommand="GridView1_RowCommand" 
     OnRowDataBound="GridView1_RowDataBound"
     OnRowDeleted="GridView1_RowDeleted" 
     OnRowDeleting="GridView1_RowDeleting">

Open in new window

on clicking delete

protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
  int ID = (int) GridView1.DataKeys[e.RowIndex].Value;

  DeleteRecordByID(ID); 

}

Open in new window

Happy Programming.