Ad:

ASP.NET Discussion Thread
Unsolved
Views: 755

Mar 1st, 2009

prevent a file from being deleted unless its selected first

Expand Post »

hi all.
ok i have been able to create an error message - if the user tries to delete a row which has not been selected first; but it still deletes from the gridview...

ASP.NET Syntax (Toggle Plain Text)
void DeleteRowButton_Click(Object sender, EventArgs e) 
{
 
LinkButton btn = sender as LinkButton;
GridViewRow row = btn.NamingContainer as GridViewRow; 
 
if (row == GridView1.SelectedRow) { 
GridView1.DeleteRow(GridView1.SelectedIndex);
 
// delete file from server
 
}
 
else
 
lblDeleteResult.Text = "Please select this file first, if you wish to delete it"; 
 
}
void DeleteRowButton_Click(Object sender, EventArgs e) 
{

LinkButton btn = sender as LinkButton;
GridViewRow row = btn.NamingContainer as GridViewRow; 
 
if (row == GridView1.SelectedRow) { 
GridView1.DeleteRow(GridView1.SelectedIndex);

// delete file from server

}

else

lblDeleteResult.Text = "Please select this file first, if you wish to delete it"; 
 
}

but the asp.net delete command- Delete="Delete From tbl....Where.......etc" deletes the file from the gridview regardless. How can one prevent the delete command from running unless the row is selected first?

p.s. the delete command is specified in the .aspx file

thanks

Last edited by julseypart; Mar 1st, 2009 at 9:47 am.

Similar Threads

Cannot remove Golden Palace casino!! in Viruses, Spyware and other Nasties
Please Help! i got rb4.tmp and many other rb.tmp files in my RecycleBin & cant del em in Viruses, Spyware and other Nasties
Here is the doc file for the assignment in C++
hotoffers nightmare in Viruses, Spyware and other Nasties
Hotoffers get me mad !! in Viruses, Spyware and other Nasties

julseypart

Reputation Points: 10

Solved Threads: 0

Light Poster

Offline

42 posts
since Oct 2008

Permalink

Mar 3rd, 2009

Re: prevent a file from being deleted unless its selected first

enable /disable the delete button in gridview based on the row selection.then this same code will works for u.let me know it works for u?

srikanthkadem

Reputation Points: 11

Solved Threads: 11

Junior Poster in Training

Offline

68 posts
since Mar 2008

Permalink

Mar 3rd, 2009

Re: prevent a file from being deleted unless its selected first

good idea!, does anyone have some sample code to allow only the delete button on the 'selected row' visible?

julseypart

Reputation Points: 10

Solved Threads: 0

Light Poster

Offline

42 posts
since Oct 2008

Permalink

Mar 10th, 2009

Re: prevent a file from being deleted unless its selected first

hi,

u can create delete button with in gridview itslef.check this example

ASP.NET Syntax (Toggle Plain Text)
    <asp:GridView ID="gdview"  runat="server" ShowFooter="true" AutoGenerateColumns="False"  DataKeyNames="CategoryID"  OnRowCancelingEdit="gdview_RowCancelingEdit" OnRowDeleting="gdview_RowDeleting" OnRowEditing="gdview_RowEditing" OnRowUpdating="gdview_RowUpdating" Width="100%" AllowPaging="True" PageSize="5" OnPageIndexChanging="gdview_PageIndexChanging" OnRowDataBound="gdview_RowDataBound"  >
        <Columns>
            <asp:BoundField HeaderText="Category Name" DataField="CategoryName" SortExpression="CategoryName" >
                <ItemStyle Height="20px" Width="150px" />
            </asp:BoundField>
 
            <asp:CommandField ShowEditButton="True">
                <ItemStyle Width="100px" />
            </asp:CommandField>
            <asp:TemplateField>
 
 
 
            <ItemTemplate>
            <asp:LinkButton ID="lnkdel" runat="server" Text="Delete" CommandName="Delete"></asp:LinkButton>
 
            </ItemTemplate>
            <ItemStyle Width="100px" />
 
            </asp:TemplateField>
        </Columns>
 
 
 </asp:GridView>
  protected void Page_Load(object sender, EventArgs e)
    {
 
        if (!Page.IsPostBack)
        {
            bindgrid();
            total = 0;
 
        }
 
    }
 
    public void bindgrid()
    {
        SqlConnection conn = new SqlConnection("Data Source='localhost';Initial Catalog='Northwind';Integrated Security=SSPI;Persist Security Info=False ");
        SqlCommand cmd = new SqlCommand("select CategoryName,CategoryID from Categories ", conn);
 
        SqlDataAdapter da = new SqlDataAdapter("", conn);
        da.SelectCommand = new SqlCommand("select CategoryName,CategoryID from Categories", conn);
        DataSet ds = new DataSet();
        da.Fill(ds, "data");
        gdview.DataSource = ds.Tables[0].DefaultView;
        gdview.DataBind();
 
 
    }
 protected void gdview_RowDeleting(object sender, GridViewDeleteEventArgs e)
    {
 
        int catid = int.Parse(gdview.DataKeys[0].Value.ToString());
       SqlConnection conn = new SqlConnection("Data Source='localhost';Initial Catalog='Northwind';Integrated Security=SSPI;Persist Security Info=False ");
        SqlDataAdapter da = new SqlDataAdapter("", conn);
        conn.Open();
        da.DeleteCommand = new SqlCommand("delete from Categories where CategoryID="+catid, conn);
        da.DeleteCommand.ExecuteNonQuery();
        conn.Close();
        bindgrid();
    }
    <asp:GridView ID="gdview"  runat="server" ShowFooter="true" AutoGenerateColumns="False"  DataKeyNames="CategoryID"  OnRowCancelingEdit="gdview_RowCancelingEdit" OnRowDeleting="gdview_RowDeleting" OnRowEditing="gdview_RowEditing" OnRowUpdating="gdview_RowUpdating" Width="100%" AllowPaging="True" PageSize="5" OnPageIndexChanging="gdview_PageIndexChanging" OnRowDataBound="gdview_RowDataBound"  >
        <Columns>
            <asp:BoundField HeaderText="Category Name" DataField="CategoryName" SortExpression="CategoryName" >
                <ItemStyle Height="20px" Width="150px" />
            </asp:BoundField>
            
            <asp:CommandField ShowEditButton="True">
                <ItemStyle Width="100px" />
            </asp:CommandField>
            <asp:TemplateField>
            
          
          
            <ItemTemplate>
            <asp:LinkButton ID="lnkdel" runat="server" Text="Delete" CommandName="Delete"></asp:LinkButton>
            
            </ItemTemplate>
            <ItemStyle Width="100px" />
        
            </asp:TemplateField>
        </Columns>
 

 </asp:GridView>
  protected void Page_Load(object sender, EventArgs e)
    {

        if (!Page.IsPostBack)
        {
            bindgrid();
            total = 0;
           
        }

    }

    public void bindgrid()
    {
        SqlConnection conn = new SqlConnection("Data Source='localhost';Initial Catalog='Northwind';Integrated Security=SSPI;Persist Security Info=False ");
        SqlCommand cmd = new SqlCommand("select CategoryName,CategoryID from Categories ", conn);

        SqlDataAdapter da = new SqlDataAdapter("", conn);
        da.SelectCommand = new SqlCommand("select CategoryName,CategoryID from Categories", conn);
        DataSet ds = new DataSet();
        da.Fill(ds, "data");
        gdview.DataSource = ds.Tables[0].DefaultView;
        gdview.DataBind();

      
    }
 protected void gdview_RowDeleting(object sender, GridViewDeleteEventArgs e)
    {
       
        int catid = int.Parse(gdview.DataKeys[0].Value.ToString());
       SqlConnection conn = new SqlConnection("Data Source='localhost';Initial Catalog='Northwind';Integrated Security=SSPI;Persist Security Info=False ");
        SqlDataAdapter da = new SqlDataAdapter("", conn);
        conn.Open();
        da.DeleteCommand = new SqlCommand("delete from Categories where CategoryID="+catid, conn);
        da.DeleteCommand.ExecuteNonQuery();
        conn.Close();
        bindgrid();
    }

greeny_1984

Reputation Points: 25

Solved Threads: 29

Posting Whiz

Offline

372 posts
since Apr 2007

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in ASP.NET Forum Timeline: Read value from DB

Next Thread in ASP.NET Forum Timeline: Asp .Net with xml

DaniWeb Message

Cancel Changes

User Name
Password