How to delete rows from two tables in C# SQL

Guruprasad Shreegiri

How to delete rows from two tables in SQL using C# when 'ID' is same in that two tables(SQL)

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Midhun Tp10y ago
Accepted answer
Hi,
Use below code for deleting SQL data from c#.
string connectionstring = "Data Source=SQLServerName;Initial Catalog=DatabaseName;User id=UserID;Password=Password;";
try
{
using (SqlConnection con = new SqlConnection(connectionstring))
{
con.Open();
using (SqlCommand command = new SqlCommand("DELETE FROM table1 WHERE ID=1;DELETE FROM table2 WHERE ID=1;", con))
{
command.ExecuteNonQuery();
}
con.Close();
}
}
catch (SystemException ex)
{
}
Krishna Rajput Singh10y ago
HelloGuruprasad Shreegiri thank you for writing below links helpful for you///////////:)
http://stackoverflow.com/questions/6085391/how-to-delete-data-from-two-tables-in-single-query
http://www.codeproject.com/Questions/444015/Single-SQL-Query-to-delete-records-in-two-tables
https://msdn.microsoft.com/en-in/library/ms189835.aspx
http://csharp.net-informations.com/dataset/dataset-multiple-tables-sqlserver.htm
Guruprasad Shreegiri10y ago
Thanks. And I'm asking in C#, how to delete rows of two table when name of both columns of tables are same and it should update to SQL both the tables
Midhun Tp10y ago
Hi,
As per my understanding you cannot do it with a single query in SQL. You can use two separate queries for that like this. What is the issue?
Delete from table1 where ID=1;
Delete from table2 where ID=1;