greenapple.Conner.Filling C# (CSharp) Метод

        public DataTable Filling(string sqlstr)
        {
            DataTable table = new DataTable();
            try
            {
                if (conn.State == ConnectionState.Open)
                { }
                else
                    conn.Open();

                table.Clear();
                comm.CommandText = sqlstr;
                comm.Connection = conn;
                adapt.SelectCommand = comm;
                adapt.Fill(table);
                conn.Close();
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message+"\nSQL:"+sqlstr);
            }
            return table;
        }