Breaking News: Grepper is joining You.com. Read the official announcement!

c# sql delete row from table

SubZero answered on March 5, 2023 Popularity 6/10 Helpfulness 4/10

answer c# sql delete row from table

c# sql delete row from table

Comment

using System.Data.SqlClient;

// ...

string connectionString = "your connection string here";
string tableName = "your table name here";
int rowId = 123; // the ID of the row to delete

using (SqlConnection connection = new SqlConnection(connectionString))
{
    connection.Open();

    string query = $"DELETE FROM {tableName} WHERE Id = @rowId";

    using (SqlCommand command = new SqlCommand(query, connection))
    {
        command.Parameters.AddWithValue("@rowId", rowId);

        int rowsAffected = command.ExecuteNonQuery();

        if (rowsAffected > 0)
        {
            Console.WriteLine("Row deleted successfully.");
        }
        else
        {
            Console.WriteLine("No rows deleted.");
        }
    }
}

Popularity 6/10 Helpfulness 4/10 Language sql

Source: Grepper

Tags: c# sql

Link to this answer
Share Copy Link

Contributed on Mar 05 2023

SubZero

0 Answers Avg Quality 2/10

Continue with Google

By continuing, I agree that I have read and agree to Greppers's Terms of Service and Privacy Policy.

c# sql delete row from table

Contents

More Related Answers

c# sql delete row from table

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.