How to convert a DataTable to a string in C#?

Posted by Mark Allison on Stack Overflow See other posts from Stack Overflow or by Mark Allison
Published on 2009-07-09T14:06:11Z Indexed on 2010/05/03 19:38 UTC
Read the original article Hit count: 212

Filed under:

datatable

|

conversion

|

c#

Hi there,

I'm using Visual Studio 2005 and have a DataTable with two columns and some rows that I want to output to the console. I hoped there would be something like:

DataTable results = MyMethod.GetResults();
Console.WriteLine (results.ToString());

What's the best way (i.e. least amount of coding from me) to convert a simple DataTable to a string?

Thanks, Mark.

© Stack Overflow or respective owner

Related posts about datatable

DataView.RowFilter Vs DataTable.Select() vs DataTable.Rows.Find()

as seen on Stack Overflow - Search for 'Stack Overflow'
Considering the code below: Dataview someView = new DataView(sometable) someView.RowFilter = someFilter; if(someView.count > 0) { …. } Quite a number of articles which say Datatable.Select() is better than using DataViews, but these are prior to VS2008. Solved: The Mystery of DataView's Poor… >>> More
How to correctly filter a datatable (datatable.select)

as seen on Stack Overflow - Search for 'Stack Overflow'
Dim dt As New DataTable Dim da As New SqlDataAdapter(s, c) c.Open() If Not IsNothing(da) Then da.Fill(dt) dt.Select("GroupingID = 0") End If GridView1.DataSource = dt GridView1.DataBind() c.Close() When I call da.fill I am… >>> More
How to obtain a random sub-datatable from another data table

as seen on Developer IT - Search for 'Developer IT'
Introduction In this article, I’ll show how to get a random subset of data from a DataTable. This is useful when you already have queries that are filtered correctly but returns all the rows. Analysis I came across this situation when I wanted to display a random tag cloud. I already had the… >>> More
How can we copy the column data of one datatable to another,even if there is different column names

as seen on Stack Overflow - Search for 'Stack Overflow'
I have two datatables. First is DataTable NameAdressPhones = new DataTable(); with Three columns Name,Adress and PhoneNo.But I want only two columns Name and Adress data so I am copy those columns (with data) to the new datatable DataTable NameAdress = new DataTable(); For that I do … >>> More
Difference between DataTable.Load() and DataTable = dataSet.Tables[];

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi All , I have a doubt i use the following piece of code get data from a SQLlite data base and Load it into a data table "SQLiteConnection cnn = new SQLiteConnection("Data Source=" + path); cnn.Open(); SQLiteCommand mycommand = new SQLiteCommand(cnn); string… >>> More

Related posts about conversion

Conversion constructor vs. conversion operator: precedence

as seen on Stack Overflow - Search for 'Stack Overflow'
Reading some questions here on SO about conversion operators and constructors got me thinking about the interaction between them, namely when there is an 'ambiguous' call. Consider the following code: class A; class B { public: B(){} B(const A&) //conversion constructor … >>> More
Conversion of bytes into a type without changing the application (ie storing the conversion method i

as seen on Stack Overflow - Search for 'Stack Overflow'
Is there a way to store a conversion strategy (for converting some bytes) into a database and then execute it on the run time. If one were to store a complete java file, you would need to compile it, store the class and some how inject into the already running system. I am not sure how this would… >>> More
General type conversion without risking Exceptions

as seen on Stack Overflow - Search for 'Stack Overflow'
I am working on a control that can take a number of different datatypes (anything that implements IComparable). I need to be able to compare these with another variable passed in. If the main datatype is a DateTime, and I am passed a String, I need to attempt to convert the String to a DateTime… >>> More
Create a Unit Conversion Application with the Zend_Measure Component

as seen on Internet.com - Search for 'Internet.com'
Learn how to create a simple conversion calculator using the Zend Framework's Zend_Measure component ... >>> More
Create a Unit Conversion Application with the Zend_Measure Component

as seen on Internet.com - Search for 'Internet.com'
Learn how to create a simple conversion calculator using the Zend Framework's Zend_Measure component ... >>> More