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

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

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.

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());

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());
}

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" <(E-Mail Removed)> schreef in bericht
news:FA771EBF-7959-478E-9CBE-(E-Mail Removed)...
> 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());

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

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 <roge...@discussions.microsoft.com>
wrote:
> yeah I know. but I realized that I need something dynamic because I will
> never know how big to make them

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 <roge...@discussions.microsoft.com>
> 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

I'm not positive I beleive you dog

-Todos




On Mar 13, 1:30 pm, Göran Andersson <g...@guffa.com> wrote:
> 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 <roge...@discussions.microsoft.com>
> > 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