public static class Claris
    {
        private static string connString = "server=SERVER_IP;database=DBASE_NAME;uid=DBLOGIN;password=DBPASS;Min Pool Size=1;Max Pool Size=20;MultipleActiveResultSets=True;Pooling=True;Enlist=true;";
 
        public static DataTable get(string query)
        {
            DataTable result = new DataTable();
            result.Rows.Clear();
            try
            {
                using (SqlConnection conn = new SqlConnection(connString))
                {
                    conn.Open();
                    
                        SqlDataAdapter da = new SqlDataAdapter();
                        da.SelectCommand = new SqlCommand(query, conn);
                        da.Fill(result);

                    conn.Close();
                }
            }
            catch (Exception e)
            {
                System.Windows.Forms.MessageBox.Show(e.Message);
            }
            return result;
        }

        public static void fillInBackground(DataTable table, string query)
        {
            table.Rows.Clear();
            Thread myThread = new System.Threading.Thread(delegate()
            {
                try
                {
                    using (SqlConnection conn = new SqlConnection(connString))
                    {
                        conn.Open();
                        SqlDataAdapter da = new SqlDataAdapter ();
                        da.SelectCommand = new  SqlCommand(query, conn);
                        da.Fill(table);
                        conn.Close();
                    }
                }
                catch (SqlException e)
                {
                    mfunc.info(e.Message);
                }
            });
            myThread.IsBackground = true;
            myThread.Start();
        }       

    }