Gettting Results in text back from SQL Server

• Leon Steenkamp

  Newbie

  Points: 5

  More actions

  March 10, 2005 at 12:31 am

  #85564

  Hi

  I need to get in a c# program the same results that you get if you use SQL Query Analyzer. For example if you execute a stored procedure in the Query pane, and you set on the query menu Results in text, you get a combined result output of the Grid pane and the Message pane. Is there a way that I can set in a program to SQL server to do this type of results. At the moment I can get the message pane information back via the InfoMessage method of SqlConnection, But I need both the results.

   

  Kind Regards

  Leon  Steenkamp

• Kathi Kellenberger

  SSChampion

  Points: 11811

  More actions

  March 10, 2005 at 8:37 pm

  #546526

  If you are using ADO.Net, look into the dataset, SQLDataAdapter, SQLCommand and DataView classes.   

  Aunt Kathi Data Platform MVP
  Author of Expert T-SQL Window Functions
  Simple-Talk Editor