How to delete rows from two tables in C# SQL

Question

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

Midhun T P · 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 Singh · Answer

Hello Guruprasad 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 Shreegiri · Answer

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 T P · Answer

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;