C#

[Serializable]
MyCollection : CollectionBase
{
  public MyCollection() {}
  public MyCollection(string name)
  {
    this._name = name;
  }
  
  private string _name;
  public string Name
  {
    get { return _name; }
    set { _name = value; }
  }
 
  ... overrides for CollectionBase methods ...
}

class MyClass
{
public string SQL2KConnStr = "..(my connection string)..";
public object ExecuteSql(string sql)
 {
   SqlConnection conn = new SqlConnection(this.SQLExpressConnStr);
   if (conn.State == ConnectionState.Open)
   {
      conn.Close();
   }
   conn.Open();
   switch(sql.Trim().Substring(0,6).ToLower()){
   case "select":
      SqlDataAdapter adapter = new SqlDataAdapter(sql, conn);
      DataSet ds = new DataSet();
      adapter.Fill(ds, "QueriedTab");
      return ds.Tables["QueriedTab"]; //Return a data table.
      break;
   default:
      SqlCommand cmd = new SqlCommand();
      //cmd.CommandType = CommandType.Text;
      cmd.Connection = conn;
      cmd.CommandText = sql;
      return cmd.ExecuteNonQuery(); //Return a number of affected rows.
 }
}

string SqlSelect = "select * from ...";
MyClass mc = new MyClass();
DataTable tab = (DataTable)mc.ExecuteSql(SqlSelect);
myDataGrid.DataSource = tab;
tab.Dispose();