Datatable to string array.

[=?Utf-8?B?cm9nZXJfMjc=?=]

hey, I have a datatable here, but I need to make it into a string array. how
do I do that?

[=?UTF-8?B?R8O2cmFuIEFuZGVyc3Nvbg==?=]

roger_27 wrote:

hey, I have a datatable here, but I need to make it into a string array. how
do I do that?

You loop through the records and oncvert the values from each field in
the records into a string.

--
Göran Andersson
_____
http://www.guffa.com

[ClayB]

Maybe some code like this will work for you. (You may have to check
for DBNulls or null in your table).
string[,] stringArray = new string[dataTable1.Rows.Count,
dataTable1.Columns.Count];

for(int row = 0; row < dataTable1.Rows.Count; ++row)
{
for(int col = 0; col < datatable1.Columns.Count; col++)
{
stringArray[row, col] = dataTable1.Rows[row][col].ToString();
}
}

===================
Clay Burch
Syncfusion, Inc.

[=?Utf-8?B?cm9nZXJfMjc=?=]

Excellent. thanks for the help guys.

here is my solution

string connectionString = "Put Connection String Here";

//make datatable
DataTable tables = new DataTable("Tables");

//this code gets a list of all the tables in the database and puts them in a
DataTable.

using (SqlConnection connection = new SqlConnection(connectionString))
{
SqlCommand command = connection.CreateCommand();
command.CommandText = "select table_name as Name from
INFORMATION_SCHEMA.Tables where TABLE_TYPE = 'BASE TABLE'";
connection.Open();
tables.Load(command.ExecuteReader(CommandBehavior. CloseConnection));
}

//make the array list to use
ArrayList arr = new ArrayList();

//put all the items in each row into a new item in the arraylist.
//since the dataTable is 1 item per row, it cant be done this way
foreach (DataRow dr in tables.Rows)
{
arr.Add(dr);
}

now each table in my database can be accessed by idex number in the arraylist

MessageBox.show("Here is my 3rd table in the database " + arr[2].ToString());

[=?Utf-8?B?cm9nZXJfMjc=?=]

actually.. heres one that works better. it stores them as straight strings so
you can go
if(arraylist[0].tostring == "wow")
{
code
}
//make data table object called Tables
DataTable tables = new DataTable("Tables");

//this code takes every table in the data base and puts them in a data table
1 column big, with each
//row being a table
using (SqlConnection connection = new SqlConnection(Connection string or
Connection String Variable here!))
{
SqlCommand command = connection.CreateCommand();
command.CommandText = "select table_name as Name from
INFORMATION_SCHEMA.Tables where TABLE_TYPE = 'BASE TABLE'";
connection.Open();
tables.Load(command.ExecuteReader(CommandBehavior. CloseConnection));
}

//make an arraylist
ArrayList arTables = new ArrayList();

//go through each row of data, which is 1 column wide
//and add it to the array list!
foreach (DataRow dr in tables.Rows)
{
arTables.Add(dr.ItemArray[0].ToString());
}

[Cor Ligthert [MVP]]

Roger,

Just a peanut, but what you are using is not a string array. It is far away
from that.
It is an arraylist filled with datarows (not even items).

Cor

"roger_27" <ro*****@discussions.microsoft.comschreef in bericht
news:FA**********************************@microsof t.com...

Excellent. thanks for the help guys.

here is my solution

string connectionString = "Put Connection String Here";

//make datatable
DataTable tables = new DataTable("Tables");

//this code gets a list of all the tables in the database and puts them in
a
DataTable.

using (SqlConnection connection = new SqlConnection(connectionString))
{
SqlCommand command = connection.CreateCommand();
command.CommandText = "select table_name as Name from
INFORMATION_SCHEMA.Tables where TABLE_TYPE = 'BASE TABLE'";
connection.Open();
tables.Load(command.ExecuteReader(CommandBehavior. CloseConnection));
}

//make the array list to use
ArrayList arr = new ArrayList();

//put all the items in each row into a new item in the arraylist.
//since the dataTable is 1 item per row, it cant be done this way
foreach (DataRow dr in tables.Rows)
{
arr.Add(dr);
}

now each table in my database can be accessed by idex number in the
arraylist

MessageBox.show("Here is my 3rd table in the database " +
arr[2].ToString());

[=?Utf-8?B?cm9nZXJfMjc=?=]

yeah I know. but I realized that I need something dynamic because I will
never know how big to make them

[PFC Sadr]

you know.. if you just used ADO classic instead of this ADO.net _CRAP_
then you could have 2 recordsets open; via the same connection-- at
the same time

ADO.net is crap sorry dog; it's all going to change again this summer
with Visual Fred 3.0


On Mar 13, 8:11 am, roger_27 <[e-mail]>
wrote:

yeah I know. but I realized that I need something dynamic because I will
never know how big to make them

[=?ISO-8859-1?Q?G=F6ran_Andersson?=]

PFC Sadr wrote:

you know.. if you just used ADO classic instead of this ADO.net _CRAP_
then you could have 2 recordsets open; via the same connection-- at
the same time

Which is keeping two connections open behind the scene.

ADO.net is crap sorry dog; it's all going to change again this summer
with Visual Fred 3.0


On Mar 13, 8:11 am, roger_27 <[e-mail]>
wrote:

>yeah I know. but I realized that I need something dynamic because I will
never know how big to make them

--
Göran Andersson
_____
http://www.guffa.com

[Todos Menos [MSFT]]

I'm not positive I beleive you dog

-Todos


On Mar 13, 1:30 pm, Göran Andersson <[e-mail]:

PFC Sadr wrote:

you know.. if you just used ADO classic instead of this ADO.net _CRAP_
then you could have 2 recordsets open; via the same connection-- at
the same time

Which is keeping two connections open behind the scene.

ADO.net is crap sorry dog; it's all going to change again this summer
with Visual Fred 3.0

On Mar 13, 8:11 am, roger_27 <[e-mail]>
wrote:

yeah I know. but I realized that I need something dynamic because I will
never know how big to make them

--
Göran Andersson
_____http://www.guffa.com

[Todos Menos [MSFT]]

C# doesn't support strings. sorry

it's just old-fashioned; when we invented C# we wanted it to be
REVOLUTIONARY
so we called them all cSharpStrings

-Todos
On Mar 12, 3:34 pm, roger_27 <[e-mail]>
wrote:

hey, I have a datatable here, but I need to make it into a string array. how
do I do that?

[=?ISO-8859-1?Q?G=F6ran_Andersson?=]

I am not positive that I care if you "beleive" me or not.
Todos Menos [MSFT] wrote:

I'm not positive I beleive you dog

-Todos


On Mar 13, 1:30 pm, Göran Andersson <[e-mail]:

>PFC Sadr wrote:

>>you know.. if you just used ADO classic instead of this ADO.net _CRAP_
then you could have 2 recordsets open; via the same connection-- at
the same time

Which is keeping two connections open behind the scene.

>>ADO.net is crap sorry dog; it's all going to change again this summer
with Visual Fred 3.0
On Mar 13, 8:11 am, roger_27 <[e-mail]>
wrote:
yeah I know. but I realized that I need something dynamic because I will
never know how big to make them

--
Göran Andersson
_____http://www.guffa.com

--
Göran Andersson
_____
http://www.guffa.com

[susiedba]

ok, smarty pants

what defines a new connection

because from where im standing; they have the same SPID; so thus they
are the same connection

On Mar 13, 3:11 pm, Göran Andersson <[e-mail]:

I am not positive that I care if you "beleive" me or not.

Todos Menos [MSFT] wrote:

I'm not positive I beleive you dog

-Todos

On Mar 13, 1:30 pm, Göran Andersson <[e-mail]:

PFC Sadr wrote:
you know.. if you just used ADO classic instead of this ADO.net _CRAP_
then you could have 2 recordsets open; via the same connection-- at
the same time
Which is keeping two connections open behind the scene.

>ADO.net is crap sorry dog; it's all going to change again this summer
with Visual Fred 3.0
On Mar 13, 8:11 am, roger_27 <[e-mail]>
wrote:
yeah I know. but I realized that I need something dynamic because I will
never know how big to make them
--
Göran Andersson
_____http://www.guffa.com

--
Göran Andersson
_____http://www.guffa.com

[Oliver Sturm]

Hello Todos,

Let me tell you that you're a funny kind of idiot. Let me also say, to be
clear, that I'd much prefer it if you took your crap elsewhere.
Oliver Sturm
--
http://www.sturmnet.org/blog

[Todos Menos [MSFT]]

I like his postings

at least Todos doesn't block people that disagree with him.
that is called CENSORSHIP and the USA should not stand for it


On Mar 14, 2:26 pm, "Oliver Sturm" <[e-mail]:

Hello Todos,

Let me tell you that you're a funny kind of idiot. Let me also say, to be
clear, that I'd much prefer it if you took your crap elsewhere.

Oliver Sturm
--http://www.sturmnet.org/blog

[RobinS]

"Oliver Sturm" <ol****@sturmnet.orgwrote in message
news:xn****************@msnews.microsoft.com...

Hello Todos,

Let me tell you that you're a funny kind of idiot. Let me also say, to be
clear, that I'd much prefer it if you took your crap elsewhere.
Oliver Sturm
--
http://www.sturmnet.org/blog

He's a troll. This is a new alias for him. He trolls over in the VB group
as aaronkempf, susiedba, dbahooker, larrylinson, and those are just the
ones I can remember.

Robin S.