阅读背景:

C#MySqlConnector下一个查询在同一个连接中

来源:互联网 

I have the following code:

我有以下代码:

string myConnection = "server=localhost;database=test;uid=test;password=test";
        string query = "SELECT label_type, label, quantity FROM system_printserver WHERE print=0";
        try
        {
            MySqlConnection myConn = new MySqlConnection(myConnection);
            myConn.Open();
            MySqlCommand command = new MySqlCommand(query, myConn);
            MySqlDataAdapter adapter = new MySqlDataAdapter(command);
            DataTable data = new DataTable();
            adapter.Fill(data);
            dataGridView1.DataSource = data;
            printDocument1.PrintPage += new PrintPageEventHandler(printDocument1_PrintPage);

            MySqlDataReader myReader;
            myReader = command.ExecuteReader();
            while (myReader.Read()) {
                orderNumber = myReader.GetString(1);
                myReader.Close();
                string queryOrder = "SELECT id_order, id_carrier FROM ps_orders WHERE id_order=28329";
                MySqlCommand commandOrder = new MySqlCommand(queryOrder, myConn);

                MySqlDataReader myReaderOrder;
                myReaderOrder = commandOrder.ExecuteReader();
                idCarrier = myReaderOrder.GetString(1);
                printDocument1.Print();
            }
string m



你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: