1

I need to run several queries inside one function. My working code for single query is as below:

C# Code:

try
    {
        OracleConnection con = new OracleConnection();
        con.ConnectionString = "Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=10.0.0.24)(PORT=1521)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=DEVL)));User Id=aaziz;Password=123211;";
        con.Open();
        string cmdQuery = "Insert into M.person (RED_NO, USED_FLAG) VALUES ('12', '0')";
        OracleCommand cmd = new OracleCommand(cmdQuery);
        cmd.Connection = con;
        cmd.CommandType = CommandType.Text;
        cmd.ExecuteNonQuery();
        con.Dispose();
    }
catch (Exception ex)
    {
        Console.WriteLine(ex.Message);

How to modify it to accommodate multiple SQL queries?

2
  • Have you tried adding a second query? Did it not work? Commented Nov 7, 2013 at 13:33
  • That's what I asking how to perform it. Commented Nov 7, 2013 at 13:37

1 Answer 1

1
try
{
    OracleConnection con = new OracleConnection();
    con.ConnectionString = "Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=10.0.0.24)(PORT=1521)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=DEVL)));User Id=aaziz;Password=123211;";
    con.Open();
    string cmdQuery = "Insert into M.person (RED_NO, USED_FLAG) VALUES ('12', '0')";
    OracleCommand cmd = new OracleCommand(cmdQuery);
    cmd.Connection = con;
    cmd.CommandType = CommandType.Text;
    cmd.ExecuteNonQuery();


    cmd.Parameters.Clear();
    cmd.CommandText = "INSERT NEW QUERY HERE";
    cmd.ExecuteNonQuery();

    cmd.Parameters.Clear();
    cmd.CommandText = "INSERT NEW QUERY HERE";
    cmd.ExecuteNonQuery();

    cmd.Parameters.Clear();
    cmd.CommandText = "INSERT NEW QUERY HERE";
    cmd.ExecuteNonQuery();

    cmd.Parameters.Clear();
    cmd.CommandText = "INSERT NEW QUERY HERE";
    cmd.ExecuteNonQuery();

    con.Dispose();
}
catch (Exception ex)
{
    Console.WriteLine(ex.Message);
Sign up to request clarification or add additional context in comments.

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.