mysql 连接不关闭_MySQL连接不会关闭

这真的很简单，我所要做的就是填充一个数据表，我拥有使用()包围的所有东西，并且连接不会处理/关闭。请帮忙

DataTable loginTbl = MySQLProcessing.MySQLProcessor.StoreProcedureDTTable("Login", ParamArgs, "Login");

public static DataTable StoreProcedureDTTable(string mysqlQuery, List CommandArgs, string queryName)

{

DataTable DTTableTable = new DataTable();

using (MySqlCommand MySQLCommandFunc = new MySqlCommand(mysqlQuery))

{

MySQLCommandFunc.CommandType = CommandType.StoredProcedure;

foreach (string args in CommandArgs)

{

string[] splitArgs = args.Split('|');

MySQLCommandFunc.Parameters.AddWithValue(splitArgs[0], splitArgs[1]);

}

using (MySqlDataAdapter DataDTTables = new MySqlDataAdapter(MySQLCommandFunc))

{

DataDTTables.SelectCommand.CommandTimeout = 240000;

lock (_object)

{

using (MySqlConnection con = new MySqlConnection(ConfigurationManager.ConnectionStrings["mysqlCon"].ConnectionString))

{

MySQLCommandFunc.Connection = con;

DataDTTables.Fill(DTTableTable);

}

}

}

}

DataTable catchConnectionTable = DTTableTable;

DTTableTable.Dispose();

return catchConnectionTable;

}