using System;
using System.Data;
using System.Windows.Forms;
using InterSystems.Data.CacheClient;

namespace SqlRuTest
{
  public partial class Form1 : Form
  {
    public Form1()
    {
      InitializeComponent();
    }

    private void button1_Click(object sender, EventArgs e)
    {
      using (var cn = new CacheConnection("server=localhost;port=1972;namespace=%SYS;uid=_system;pwd=SYS"))
      {
        cn.Open();
        var ds= new DataSet();
        
        var cmd = Config.Databases.List(cn);
        // или var cmd = Config.Namespaces.List(cn);

        cmd.Parameters.Add(new CacheParameter("Names", "*"));
        cmd.Parameters.Add(new CacheParameter("CPFFile", null));
        cmd.Parameters.Add(new CacheParameter("Flags", "0"));
        cmd.Parameters.Add(new CacheParameter("Format", "0"));
        
        var adapter = new CacheDataAdapter { SelectCommand = cmd };
        adapter.Fill(ds);
        dataGrid1.DataSource = ds;
      }
    }
  }
}