FieldNames and PrimaryKeys in Table

[Gerrit]

Hello,

I try to display the fieldnames and the primary key of a table, with this
code:

using System;
using System.Collecti ons.Generic;
using System.Text;
using System.Data;
using System.Data.Odb c;

namespace TableFieldsInfo
{
class Program
{
static void Main(string[] args)
{
string cnString =
"DSN=MyDsn;SERV ER=SERVER1;UID= ME;PWD=;DATABAS E=TESTDB";

OdbcConnection cn = new OdbcConnection( );
cn.ConnectionSt ring = cnString;
cn.Open();

OdbcCommand cmd = new OdbcCommand();
cmd.Connection = cn;
cmd.CommandText = "SELECT * FROM ARTICLES";

OdbcDataReader dr =
cmd.ExecuteRead er(CommandBehav ior.CloseConnec tion);

DataTable dt = dr.GetSchemaTab le();

DisplayFields(d t);
}

private static void DisplayFields(S ystem.Data.Data Table table)
{
foreach (System.Data.Da taRow row in table.Rows)
{
foreach (System.Data.Da taColumn col in table.Columns)
{
Console.WriteLi ne("{0} = {1}", col.ColumnName,
row[col]);
}
Console.WriteLi ne("=========== =============== =");
}
}
}
}

I have tried a lot, but I can only make an OdbcConnection.
With this code, I became a list of the fieldnames, but the field who is the
primary key, the output is: IsKey = false.

Do you have an idea how I can get the primary key of my table?

Thank you very much.
--

www.gsnel.nl

[sloan]

See this KB

http://support.microsoft.com/kb/309488


"Gerrit" <gs************ *@hotmail.comwr ote in message
news:d0******** *************** ****@news.chell o.nl...

Hello,

I try to display the fieldnames and the primary key of a table, with this
code:

using System;
using System.Collecti ons.Generic;
using System.Text;
using System.Data;
using System.Data.Odb c;

namespace TableFieldsInfo
{
class Program
{
static void Main(string[] args)
{
string cnString =
"DSN=MyDsn;SERV ER=SERVER1;UID= ME;PWD=;DATABAS E=TESTDB";

OdbcConnection cn = new OdbcConnection( );
cn.ConnectionSt ring = cnString;
cn.Open();

OdbcCommand cmd = new OdbcCommand();
cmd.Connection = cn;
cmd.CommandText = "SELECT * FROM ARTICLES";

OdbcDataReader dr =
cmd.ExecuteRead er(CommandBehav ior.CloseConnec tion);

DataTable dt = dr.GetSchemaTab le();

DisplayFields(d t);
}

private static void DisplayFields(S ystem.Data.Data Table table)
{
foreach (System.Data.Da taRow row in table.Rows)
{
foreach (System.Data.Da taColumn col in table.Columns)
{
Console.WriteLi ne("{0} = {1}", col.ColumnName,
row[col]);
}
Console.WriteLi ne("=========== =============== =");
}
}
}
}

I have tried a lot, but I can only make an OdbcConnection.
With this code, I became a list of the fieldnames, but the field who is

the

primary key, the output is: IsKey = false.

Do you have an idea how I can get the primary key of my table?

Thank you very much.
--

www.gsnel.nl

[Gerrit]

I have seen this, but I tried a lot, but I can not make an OleDbConnection
to my Database. That 's the problem I think. Is is possible with an
OdbcConnection do you think?

--

www.gsnel.nl

"sloan" <sl***@ipass.ne tschreef in bericht
news:%2******** ********@TK2MSF TNGP03.phx.gbl. ..

See this KB

http://support.microsoft.com/kb/309488


"Gerrit" <gs************ *@hotmail.comwr ote in message
news:d0******** *************** ****@news.chell o.nl...

>Hello,

I try to display the fieldnames and the primary key of a table, with this
code:

using System;
using System.Collecti ons.Generic;
using System.Text;
using System.Data;
using System.Data.Odb c;

namespace TableFieldsInfo
{
class Program
{
static void Main(string[] args)
{
string cnString =
"DSN=MyDsn;SER VER=SERVER1;UID =ME;PWD=;DATABA SE=TESTDB";

OdbcConnection cn = new OdbcConnection( );
cn.ConnectionSt ring = cnString;
cn.Open();

OdbcCommand cmd = new OdbcCommand();
cmd.Connection = cn;
cmd.CommandText = "SELECT * FROM ARTICLES";

OdbcDataReader dr =
cmd.ExecuteRea der(CommandBeha vior.CloseConne ction);

DataTable dt = dr.GetSchemaTab le();

DisplayFields(d t);
}

private static void DisplayFields(S ystem.Data.Data Table table)
{
foreach (System.Data.Da taRow row in table.Rows)
{
foreach (System.Data.Da taColumn col in table.Columns)
{
Console.WriteLi ne("{0} = {1}", col.ColumnName,
row[col]);
}
Console.WriteLi ne("=========== =============== =");
}
}
}
}

I have tried a lot, but I can only make an OdbcConnection.
With this code, I became a list of the fieldnames, but the field who is

the

>primary key, the output is: IsKey = false.

Do you have an idea how I can get the primary key of my table?

Thank you very much.
--

www.gsnel.nl

[Truong Hong Thi]

Try including CommanBehavior. KeyInfo in the call of ExecuteReader.
If no help, maybe the underlying ODBC driver does not support this
function.

Gerrit wrote:

Hello,

I try to display the fieldnames and the primary key of a table, with this
code:

using System;
using System.Collecti ons.Generic;
using System.Text;
using System.Data;
using System.Data.Odb c;

namespace TableFieldsInfo
{
class Program
{
static void Main(string[] args)
{
string cnString =
"DSN=MyDsn;SERV ER=SERVER1;UID= ME;PWD=;DATABAS E=TESTDB";

OdbcConnection cn = new OdbcConnection( );
cn.ConnectionSt ring = cnString;
cn.Open();

OdbcCommand cmd = new OdbcCommand();
cmd.Connection = cn;
cmd.CommandText = "SELECT * FROM ARTICLES";

OdbcDataReader dr =
cmd.ExecuteRead er(CommandBehav ior.CloseConnec tion);

DataTable dt = dr.GetSchemaTab le();

DisplayFields(d t);
}

private static void DisplayFields(S ystem.Data.Data Table table)
{
foreach (System.Data.Da taRow row in table.Rows)
{
foreach (System.Data.Da taColumn col in table.Columns)
{
Console.WriteLi ne("{0} = {1}", col.ColumnName,
row[col]);
}
Console.WriteLi ne("=========== =============== =");
}
}
}
}

I have tried a lot, but I can only make an OdbcConnection.
With this code, I became a list of the fieldnames, but the field who is the
primary key, the output is: IsKey = false.

Do you have an idea how I can get the primary key of my table?

Thank you very much.
--

www.gsnel.nl

[Gerrit]

This is not working, but thanks for your answer. I searched today and I
found a connectionstrin g for oledb connection, so I look further in that
direction.

--

www.gsnel.nl
"Truong Hong Thi" <th*****@gmail. comschreef in bericht
news:11******** **************@ m73g2000cwd.goo glegroups.com.. .

>
Try including CommanBehavior. KeyInfo in the call of ExecuteReader.
If no help, maybe the underlying ODBC driver does not support this
function.

Gerrit wrote:

>Hello,

I try to display the fieldnames and the primary key of a table, with this
code:

using System;
using System.Collecti ons.Generic;
using System.Text;
using System.Data;
using System.Data.Odb c;

namespace TableFieldsInfo
{
class Program
{
static void Main(string[] args)
{
string cnString =
"DSN=MyDsn;SER VER=SERVER1;UID =ME;PWD=;DATABA SE=TESTDB";

OdbcConnection cn = new OdbcConnection( );
cn.ConnectionSt ring = cnString;
cn.Open();

OdbcCommand cmd = new OdbcCommand();
cmd.Connection = cn;
cmd.CommandText = "SELECT * FROM ARTICLES";

OdbcDataReader dr =
cmd.ExecuteRea der(CommandBeha vior.CloseConne ction);

DataTable dt = dr.GetSchemaTab le();

DisplayFields(d t);
}

private static void DisplayFields(S ystem.Data.Data Table table)
{
foreach (System.Data.Da taRow row in table.Rows)
{
foreach (System.Data.Da taColumn col in table.Columns)
{
Console.WriteLi ne("{0} = {1}", col.ColumnName,
row[col]);
}
Console.WriteLi ne("=========== =============== =");
}
}
}
}

I have tried a lot, but I can only make an OdbcConnection.
With this code, I became a list of the fieldnames, but the field who is
the
primary key, the output is: IsKey = false.

Do you have an idea how I can get the primary key of my table?

Thank you very much.
--

www.gsnel.nl

[Chris Dunaway]

Gerrit wrote:

I have seen this, but I tried a lot, but I can not make an OleDbConnection
to my Database. That 's the problem I think. Is is possible with an
OdbcConnection do you think?

Why can you not make an OleDbConnection to your db? Are you getting an
error? What database server are you using and what does your code look
like to create the OleDbConnection ? What does the connection string
look like? Perhaps you can try this site to get the correct connection
string: www.connectionstrings.com

Chris

[Gerrit]

"Chris Dunaway" <du******@gmail .comschreef in bericht
news:11******** **************@ i42g2000cwa.goo glegroups.com.. .

Gerrit wrote:

>I have seen this, but I tried a lot, but I can not make an
OleDbConnectio n
to my Database. That 's the problem I think. Is is possible with an
OdbcConnecti on do you think?

Why can you not make an OleDbConnection to your db? Are you getting an
error? What database server are you using and what does your code look
like to create the OleDbConnection ? What does the connection string
look like? Perhaps you can try this site to get the correct connection
string: www.connectionstrings.com

Chris

Hi Chris,

It is a Progress 9.1D database, with OpenLink ODBC driver. There is an OleDb
driver, but we have no licence for that driver. I became a message that the
..lic file could not be found. We have only licence for ODBC. Maybe there are
free other drivers, but I don 't know them.

Gerrit

--

www.gsnel.nl