I Have A Dataset Which Contains A Single Row. How Can I Transfer All The Values Of That Row Into A String Array?

Question

1.00/5 (1 vote)

See more:

C#

Insert values from data set which contains one single row into a string array

Posted 21-May-14 3:35am

Member 10830580

Add a Solution

Comments

johannesnestler 21-May-14 9:48am

Sounds simple, so hard to tell wher you stuck... General answer: create an string array with a size like your column count (row has 5 columns, so array size needs to be 5 too). Then loop through all you (row-) columns and fill the Array for each. (don't Forget to convert all the values to string - which is just a call to ToString())

Francine DeGrood Taylor 21-May-14 13:11pm

Create a List<object> (you don't have to know beforehand how many columns there are, and you can always ToArray it) and loop through your column values, getting the object value from the column. If you want to get fancy, convert it to string, then translate it into the appropriate data type using the column type (if you want to get that fancy). Depends on what you want to do with it after you put it into your collection.

Francine DeGrood Taylor 21-May-14 13:12pm

Are you going to use the information as an array, or do you want to read it into a custom class object?

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

DamithSL · Answer 1 · 2014-05-21T08:59:00

Solution 1

try like below

C#

string[] items = dataSet1.Tables[0].Rows[0].OfType<string>().ToArray();

Posted 21-May-14 8:59am

DamithSL

Updated 21-May-14 9:00am

v2

cigwork · Answer 2 · 2014-05-21T09:00:00

Some sample data to work with...

C#

// Set up a datatable containing a single row for the sake of example.
// If given a dataset then DataTable myTable = myDataSet.Tables[0];
DataTable myTable = new DataTable("Fred");
//  Some columns with random and arbitrary datatypes.
myTable.Columns.Add(new DataColumn("Int", typeof(Int32)));
myTable.Columns.Add(new DataColumn("Guid", typeof(Guid)));
myTable.Columns.Add(new DataColumn("DateTime", typeof(DateTime)));
myTable.Columns.Add(new DataColumn("Bool", typeof(Boolean)));
myTable.Columns.Add(new DataColumn("String", typeof(String)));

myTable.Rows.Add(new Object[] {1, Guid.NewGuid(),
                               DateTime.MaxValue, false, "a string"});

Extraction ...

C#

// Query the first (only) row in our demo table.
// Of course the ::ToString method for a datatype may not give you a format
// that you want but that's another problem.
IEnumerable<string> qryColumns = from object item in myTable.Rows[0].ItemArray
                                 select item.ToString();

// Dump the query results to a string array.
string[] op01 = qryColumns.ToArray<string>();