How to insert query result to mysql array

Question

I need to add this command.CommandText result to command2.CommandText instead "result"

string connString = "connect data;";

MySqlConnection conn = new MySqlConnection(connString);
MySqlCommand command = conn.CreateCommand();
MySqlCommand command1 = conn.CreateCommand();
MySqlCommand command2 = conn.CreateCommand();

command.CommandText = "SELECT `order_id` FROM `test` WHERE `order_item_type`='line_item' AND `order_offer_send`='0';";
command2.CommandText = "SELECT `meta_value` FROM `test1` WHERE `order_item_id`='" + result + "'";

First of all, please parameterize your Queries, like this: Working with Parameters ! Second: Please show us what you have tried so far. — waka
– waka, Commented Mar 19, 2015 at 14:38

fubo · Accepted Answer · 2015-03-19 14:45:31Z

1

i would work with parameters to avoid SQL Injection attacks and using directive to avoid open connections and a better usage of the gc:

string connString = "connect data;";
string Command = "SELECT `order_id` FROM `test` WHERE `order_item_type`='line_item' AND `order_offer_send`= @order_offer_send limit 1;";
string Command2 = "SELECT `meta_value` FROM `test1` WHERE `order_item_id`= @result limit 1"; 
int OfferID = -1;
string meta_value = null;
using (MySqlConnection mConnection = new MySqlConnection(connString))
{
    mConnection.Open();
    using (MySqlCommand myCmd = new MySqlCommand(Command, mConnection))
    {
        myCmd.Parameters.Add(new MySqlParameter("@order_offer_send", "0"));
        OfferID = (int)myCmd.ExecuteScalar();
    }
    using (MySqlCommand myCmd = new MySqlCommand(Command2, mConnection))
    {
        myCmd.Parameters.Add(new MySqlParameter("@result", OfferID));
        meta_value = (string)myCmd.ExecuteScalar();
    }
}

edited Mar 19, 2015 at 14:45

answered Mar 19, 2015 at 14:38

fubo

46.2k20 gold badges109 silver badges139 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Tony Hopkinson Over a year ago

An other function to get the order for an order_offer_send would be even better. +1 for using by the way.

fubo Over a year ago

you're right, probably this can be done even with a join within one select

Tony Hopkinson Over a year ago

Yeah that would be another option, probably a better one unless there were some re-use opportunities. I was thinking more replacing OfferID in the second query with a function to get it.

Collectives™ on Stack Overflow

How to insert query result to mysql array

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related