Saving Data from Dataset to file

Question

I am fairly new at programming in C#. I am using Visual C# 2008 Express, and I have a dataset that I would like to save/export the data to a file. I would like to have that data be saved to either a Text file, or an Excel file. I have not been able to locate how to do this and I completely lost. Any help would be greatly appreciated. This program is a christmas present to my mother who has become quite the collector.

Answer 1

SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[YourTable]') if it exist then it will display the result,,,with table name ,,,tpe and everything

Answer 2

Select your database and open new query window and

EXEC sp_tables @table_type = "'table'"

Answer 3

hi,

there are two tables sys.tables and sys.objects, in which data base maintain table information
please try.

select * from sys.tables where name = 'Table1'

select * from sys.objects where type = 'U' and type_desc = 'USER_TABLE'

hope this will help you.