/// <summary>
/// Only If Server is MYSQL.
/// </summary>
/// <param name="Query"></param>
/// <param name="useParentconnection"></param>
/// <param name="args"></param>
/// <returns></returns>
public DataTable GetDataTable(string Query, bool useParentconnection, params string[] args)
{
DataTable dt = null;
if (Connect())
{
BinaryBuffer buff = new BinaryBuffer();
buff.BeginWrite();
args = args ?? new string[] { };
buff.Write(1);
buff.Write(args.Length);
for (int i = 0; i < args.Length; i++)
{
buff.WriteField(args[i]);
}
buff.Write((byte)1);
buff.WriteField(Query);
buff.EndWrite();
try
{
Database.WriteBuffer(buff.ByteBuffer, _TcpClient.GetStream());
byte[] data = Database.ReadBuffer(_TcpClient.GetStream());
dt = BinaryBuffer.ConvertBlobToDataTable(ref data);
}
catch (Exception)
{
}
if (!useParentconnection)
{
Disconnect();
}
}
return(dt);
}
