how to write method that return datatable in CLR C#

i have specific class (.dll) return datatable method , calling in clr below ,but have output result problem .

// clr method

 public static void dtmethodclr()  
   {
    var dt = postbox.dtmethod("select top 4 name,state_desc sys.databases");
    (int = 0; < dt.rows.count; i++)
    {
      if (sqlcontext.pipe != null) sqlcontext.pipe.send(dt.rows[i][0] + dt.rows[i][1].tostring());
    }
  }

but when exec method result below

the problem ,

1 - column name not visible

2 - align not regular

pipe.send(string) sending messages client, not resultsets.

you need use 1 of other methods here:  sqlpipe class , either send individual records, or whole sqldatareader.

david

---

microsoft technology center - dallas
my blog

Visual Studio Languages  ,  .NET Framework  >  Visual C#