getting database table schema

[Saso Zagoranski]

Hi!

A question about database tables...
I have a SELECT statement:
SELECT something FROM someTable WHERE code = @code

The parameter code starts with 1 and is autoincremented...

Now I want to add a row to the database and I do it like this:
DataSet dataSet = new DataSet();
dataAdapter.SelectStatement.Parameters[0].Value = 0; // *
dataAdapter.Fill(dataSet); //
*
dataSet.Tables[0].AddRow(....);

The question is about the two rows marked with a *... I do this only to get
the schema of the table...
Is there anyother way to get the schema of the table? And can you the update
just the DataTable, without
it being in a DataSet?

thanks,
saso

[Peter Koen]

"Saso Zagoranski" <sa*************@guest.arnes.si> wrote in
news:bp**********@planja.arnes.si:

Hi!

A question about database tables...
I have a SELECT statement:
SELECT something FROM someTable WHERE code = @code

The parameter code starts with 1 and is autoincremented...

Now I want to add a row to the database and I do it like this:
DataSet dataSet = new DataSet();
dataAdapter.SelectStatement.Parameters[0].Value = 0; // *
dataAdapter.Fill(dataSet);
// *
dataSet.Tables[0].AddRow(....);

The question is about the two rows marked with a *... I do this only
to get the schema of the table...
Is there anyother way to get the schema of the table? And can you the
update just the DataTable, without
it being in a DataSet?

thanks,
saso

HI Saso,

Why don't you perform the update directly with an SqlCommand object if
you don't want to use the DataSet?

A dataTable can be used only in conjunction with a DataSet. So your only
chance is either to use the DataSet features or to stick with standalone-
commands.

greets
Peter

--
------ooo---OOO---ooo------

Peter Koen - www.kema.at
MCAD CAI/RS CASE/RS IAT

------ooo---OOO---ooo------

[Saso Zagoranski]

Thanks Peter!

Good point... I'll try and use the SqlCommand instead :)

saso

"Peter Koen" <koen-newsreply&snusnu.at> wrote in message
news:eK**************@TK2MSFTNGP11.phx.gbl...

"Saso Zagoranski" <sa*************@guest.arnes.si> wrote in
news:bp**********@planja.arnes.si:

Hi!

A question about database tables...
I have a SELECT statement:
SELECT something FROM someTable WHERE code = @code

The parameter code starts with 1 and is autoincremented...

Now I want to add a row to the database and I do it like this:
DataSet dataSet = new DataSet();
dataAdapter.SelectStatement.Parameters[0].Value = 0; // *
dataAdapter.Fill(dataSet);
// *
dataSet.Tables[0].AddRow(....);

The question is about the two rows marked with a *... I do this only
to get the schema of the table...
Is there anyother way to get the schema of the table? And can you the
update just the DataTable, without
it being in a DataSet?

thanks,
saso

HI Saso,

Why don't you perform the update directly with an SqlCommand object if
you don't want to use the DataSet?

A dataTable can be used only in conjunction with a DataSet. So your only
chance is either to use the DataSet features or to stick with standalone-
commands.

greets
Peter

--
------ooo---OOO---ooo------

Peter Koen - www.kema.at
MCAD CAI/RS CASE/RS IAT

------ooo---OOO---ooo------

[Mark Johnson]

maybe this will help.
//------------------------------------------------------------------
DB_Connection.Open();
// Get the Table Names from DataBase
DB_SchemaTable =
DB_Connection.GetOleDbSchemaTable(System.Data.OleD b.OleDbSchemaGuid.Tables,
new object[] {null, null, null, "TABLE"});
// Reserve the Strings for the Table Names
sa_TableNames = new String[DB_SchemaTable.Rows.Count];
for (int i=0;i<DB_SchemaTable.Rows.Count;i++)
{
DataRow dr_Row = DB_SchemaTable.Rows[i];
// Store the Table Name
sa_TableNames[i] = dr_Row["TABLE_NAME"].ToString();
}

Mark Johnson, Berlin Germany
mj*****@mj10777.de
"Saso Zagoranski" <sa*************@guest.arnes.si> schrieb im Newsbeitrag
news:bp**********@planja.arnes.si...

Hi!

A question about database tables...
I have a SELECT statement:
SELECT something FROM someTable WHERE code = @code

The parameter code starts with 1 and is autoincremented...

Now I want to add a row to the database and I do it like this:
DataSet dataSet = new DataSet();
dataAdapter.SelectStatement.Parameters[0].Value = 0; // *
dataAdapter.Fill(dataSet); // *
dataSet.Tables[0].AddRow(....);

The question is about the two rows marked with a *... I do this only to get the schema of the table...
Is there anyother way to get the schema of the table? And can you the update just the DataTable, without
it being in a DataSet?

thanks,
saso