using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Data;

using System.Data.SqlClient;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

using System.Windows.Forms;

namespace DBUtilities
{
 public class Program
 {
  public static void Main(string[] args)
  {
   //Declare the variable
   DataTable MyTable;
   //Calling the function to get the result in DataTable
   MyTable =GetTable("SELECT * FROM tblAccount”);
  }
  public static DataTable GetTable(string strSQL)
  {
   SqlConnection FillConn = new SqlConnection(YourConnetionString);
   System.Data.DataTable UserTable = new System.Data.DataTable();
   FillConn.Open();
   SqlCommand sqlCommand = new SqlCommand();
   sqlCommand.Connection = FillConn;
   sqlCommand.CommandText = strSQL;
   SqlDataAdapter sqlDataAdapter = new SqlDataAdapter();
   sqlDataAdapter.SelectCommand = sqlCommand;
   sqlDataAdapter.Fill(UserTable);
   return UserTable;
  }
 }
}