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 ...