public Task<int> ExecuteAsync(MySqlConnection con, string sSQL)
{
return Task.Run(() =>
{
string constring = "Server = localhost; Database = jhcisdb;Port=3333; Uid = root; Pwd = 123456; AllowZeroDateTime = True;CharSet=utf8;default command timeout=100000";
jcon = new MySqlConnection(constring);
// using (var newConnection = new SqlConnection(sConnectionString))
using (var newCommand = new MySqlCommand(sSQL, con))
{
newCommand.CommandType = CommandType.Text;
con.Open();
return newCommand.ExecuteNonQuery();
}
});
}
//-------------------------------
private async Task ExecuteSomeData()
{
//Use Async method to get data
await ExecuteAsync(jcon, sqlAll);
}
//----------------------------------------------
private void BtnTest_Click(object sender, EventArgs e)
{
ExecuteSomeData();
//MessageBox.Show("OK");
}
ไม่มีความคิดเห็น:
แสดงความคิดเห็น