How to delete a row in asp.net sql server

Question

0.00/5 (No votes)

See more:

, +

Hello

I have a stored procedure in which i have a delete statement as

delete from table where id=@id

now i want to know how to delete a row in c# asp.net.

what is the code for this.
Plz help

Posted 12-Jun-12 18:42pm

Nikil0012

Add a Solution

Comments

RDBurmon 13-Jun-12 9:29am

Thanks Everyone who replied to this thread , So Saurabh, I think you have got enough responses and you should be able to mark it as your answer and close the thread. Please do so.

3 solutions

Solution 2

Either execute the stored procedure:

C#

using (SqlConnection con = new SqlConnection(strConnect))
    {
    con.Open();
    using (SqlCommand com = new SqlCommand("myProcedureName", con))
        {
        com.CommandType = CommandType.StoredProcedure;
        com.Parameters.AddWithValue("@Param1", "My Parameter 1 value");
        com.Parameters.AddWithValue("@Param2", "My Parameter 1 value");
        com.Parameters.AddWithValue("@Param3", "My Parameter 1 value");
        com.ExecuteNonQuery();
        }
    }

or just execute it as code:

C#

using (SqlConnection con = new SqlConnection(strConnect))
    {
    con.Open();
    using (SqlCommand com = new SqlCommand("DELETE FROM table WHERE id=@ID", con))
        {
        com.Parameters.AddWithValue("@ID", idToDelete);
        com.ExecuteNonQuery();
        }
    }

Posted 12-Jun-12 18:58pm

OriginalGriff

Comments

Code 89 13-Jun-12 2:03am

+5!

Solution 3

select-insert-update-delete-using-stored-procedure-in-sql/[^]

Posted 12-Jun-12 20:34pm

k.Prathap

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)

Prasad_Kulkarni · Accepted Answer · 2012-06-12T18:52:00

Refer this code:

C#

SqlConnection connection = new System.Data.SqlClient.SqlConnection(strConnections);
string Command = "select * from tableName WHERE ID = " + txtID.Text.Trim() + "";
SqlDataAdapter dataAdapter2 = new SqlDataAdapter(Command, strConnections);
System.Data.SqlClient.SqlCommand oCommand = new System.Data.SqlClient.SqlCommand();
connection.Open();
SqlTransaction transaction = connection.BeginTransaction();
oCommand.Connection = connection;
oCommand.Transaction = transaction;
oCommand.CommandText = "deleteVendPymnt";
oCommand.CommandType = CommandType.StoredProcedure;
dataAdapter2.UpdateCommand = oCommand;
dataAdapter2.UpdateCommand.Transaction = transaction;
try
{
 oCommand.ExecuteNonQuery();
 transaction.Commit();
 connection.Close();
 MessageBox.Show("Delete succeed!", "Delete option", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
catch
{
 transaction.Rollback();
 MessageBox.Show("Concurrency error!!!", "Delete option", MessageBoxButtons.OK,  MessageBoxIcon.Stop);
}

Also refer similar answer:
Database Insert and Delete with Stored Procedure[^]