Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1023
  • Last Modified:

Can someone Convert this from the VB.NET to the C# ?



Protected Sub GridView1_RowDeleting(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewDeleteEventArgs) Handles GridView1.RowDeleting  

0
Scripter25
Asked:
Scripter25
  • 7
  • 3
1 Solution
 
SammyCommented:
protected void GridView1_RowDeleting(object sender, System.Web.UI.WebControls.GridViewDeleteEventArgs e) {
    }

and make sure you gridview has the following
onrowdeleting="GridView1_RowDeleting"  

take a look here for more on the subject
http://msdn2.microsoft.com/en-us/library/system.web.ui.webcontrols.gridview.rowdeleting(VS.80).aspx

HTH
0
 
Scripter25Author Commented:
Ok I think you are correct but I am having an issue that is preventing me from testing it out,,,


When I try to do the delete it provides the following error

Deleting is not supported by data source 'SqlDataSource1' unless DeleteCommand is specified.

Which is pretty understandable error for me the only problem is is when I go to the 'SqlDataSource1' and choose "Configure Data Source" when I attempt to add "Update, Delete" functionality to it it is just greyed out.

The SQL statment for that 'SqlDataSource1' is a simple select
0
 
Scripter25Author Commented:
Ok disregard the last statement I just figured out that in order for those options to be available you have to have a primary key set to the table
0
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
Scripter25Author Commented:
Aight now I tested out what I have but it does not work
 though I do not understand fully your reply on this can you be a bit more descriptive

This is what I have



    void GridView1_RowDeleting(Object sender, GridViewDeleteEventArgs e)
    {

        // Cancel the delete operation if the user attempts to remove
        // the last record from the GridView control.
        if (GridView1.Rows.Count <= 1)
        {
            Response.Write("I Hope this works");
        }

    }  

But what are you talking about in regards to the onrowdeleting="GridView1_RowDeleting"  
0
 
Scripter25Author Commented:
ok Now I figured out what you were talking about regarding onrowdeleting but this is what I get now

Error      1      No overload for 'GridView1_RowDeleting' matches delegate 'System.Web.UI.WebControls.GridViewDeletedEventHandler'      C:\Documents and Settings\Scott\My Documents\Visual Studio 2005\WebSites\shotdrive\upload.aspx      18
0
 
Scripter25Author Commented:
This is my code

        <asp:GridView ID="GridView1" runat="server" AllowPaging="True" AllowSorting="True"
            AutoGenerateColumns="False" CellPadding="4" DataSourceID="SqlDataSource1" ForeColor="#333333"
            GridLines="None" Style="z-index: 103; left: 160px; position: absolute; top: 204px" OnRowDeleted="GridView1_RowDeleting" >



    protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
    {
    }
0
 
Scripter25Author Commented:
Ok I figured out that I was using OnRowDeleted when I should have been using OnRowDeleting

But I still have the problem that it is not deleting any rows
0
 
SammyCommented:
can you post the complete code?
0
 
SammyCommented:
something to look at is this walkthrough from MSDN
http://msdn2.microsoft.com/en-us/library/ms972940.aspx

0
 
Scripter25Author Commented:
Figured it all out I was just missing

DataKeyNames="ID" in the GridView. I didnt even have to add the primary key to the Gridview to show. although for future readers of this as to not confuse  the Primary Key does have to be included in the SQLDataSource in order for it to work.
 

Thank you to everyone that helped with this
0
 
A-BMCommented:
Dear,
Don't use delete keyword, try to use another keyword just like "Remove". Because the delete keyword is a reserved keyword in 'SqlDataSource1'
Just like :
<ItemTemplate>
<asp:LinkButton ID="LinkButton23" runat="server" CausesValidation="False" CommandName="Remove" Text="Remove"></asp:LinkButton>
</ItemTemplate>
You can use commandArgument keyword to delete selected row from gridview
as                       CommandArgument = '<%# Eval("Name of the Your Field") %>'
then in item command
if e.commandargument = "Remove";
call function or sub for deleting the row from the datagrid
 YouFunction(E.CommandArgument)
 
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

  • 7
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now