Run 2 querys or more

Question

Run 2 querys or more

Navigation

#1 by (1 votes)

2

I would like to execute 2 queries in C # when the button is clicked, but I can only execute one.

public static void excluireventos()
{
    string connectionString = Conn.tank();
    using (SqlConnection connection = new SqlConnection(connectionString))
    {
        connection.Open();
        string query = string.Format("TRUNCATE TABLE Active" + "TRUNCATE TABLE Active_Number");
        using (SqlCommand cmd = new SqlCommand(query,connection))
        {
            cmd.ExecuteNonQuery();
            Globals.UpdateLogs("Todos os eventos foram excluidos com exito!");
        }
    }
}

The two queries are TRUNCATE , if I put one will usually more if I put two of the error in the program and date.

How can I perform 2 queries or more?

sql c# .net ado.net

asked by anonymous 15.11.2016 / 21:35

1 answer

Where should I put the Try / Catch blocks using MVC? How to make this effect in css?

score 1 · Accepted Answer

You are only executing a query , you can execute more than one command in it, as long as they are separated by a semicolon:

public static void excluireventos() {
     using (var connection = new SqlConnection(Conn.tank())) {
         connection.Open();
         using (SqlCommand cmd = new SqlCommand("TRUNCATE TABLE Active; TRUNCATE TABLE Active_Number", connection)) {
             cmd.ExecuteNonQuery();
             Globals.UpdateLogs("Todos os eventos foram excluidos com exito!");
         }
    }
}

I gave a simplified one in the code.