Delete command is not working in ASP.NET

Question

0.00/5 (No votes)

See more:

I am trying to delete a row from gridview in asp.net on the base of primary key.
I don't know where i am missing in my code. Please help to find out my error.

What I have tried:

C#

//that is my method which i am using
 protected void deleting() {

            conn.Open();
            string del = "Delete from Task_Assingment where [Row#] = @Row#";
            SqlCommand sq = new SqlCommand(del, conn);
            sq.ExecuteNonQuery();
            conn.Close();

        }
//in that code Row# is my column name(which is my primary key)

Posted 24-Mar-17 10:29am

Hassaan_Malik

Updated 24-Mar-17 16:18pm

Bryian Tan

v2

Add a Solution

Comments

[no name] 24-Mar-17 16:54pm

Your code has nothing to do with any gridview.

Hassaan_Malik 24-Mar-17 17:11pm

actually i have added a button (select index) in each row of gridview. The on clicking the button i am calling that method (deleting) to delete my row from the gridview. Got it?

[no name] 24-Mar-17 20:11pm

Sure if you say so. This code STILL does not have anything to do with any gridview.

j snooze 24-Mar-17 17:07pm

I would also say you are not actually passing in a row number anywhere or replacing the @Row# in your query with the actual row number. You need to tell your query what to replace @Row# with or it has no idea what you're talking about.

CHill60 24-Mar-17 19:53pm

And even if you get the delete from your database working you may still need to refresh or rebind the DataGrid

Karthik_Mahalingam 25-Mar-17 1:39am

@Row# is not added to parameter list

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CyberSaint · Accepted Answer · 2017-03-24T16:18:00

need to have initialization of row# to delete the entire row. just assign the id to given variable to make it work.
where [row#] must have to be assigned to id can use cell_row_click in Grid to select the very first id by using [e.index] method to assign the id or any other means to have flow to be created from id of dB to grid . thank you