System.Data.Dat aRowView problem

[kscdavefl]

I am trying to fill a datalist with table names from an Oracle database. The
program works fine using the following code:
private void GetTables()
{
// open a database connection
string con = connectLabel.Te xt;
cn = new System.Data.Ole Db.OleDbConnect ion(con);
cn.Open();

//Declare a DataTable Object
System.Data.Dat aTable dt ;

//Query for getting the list of all tables from the schema , no restriction
dt = cn.GetOleDbSche maTable(OleDbSc hemaGuid.Tables , null);
//Display the tables in the tablesList
tablesList.Data Source = dt;
tablesList.Data Bind();
}

However, the datalist displays System.data.Dat aRowView in the datalist when
I run the program. What do I need to change in the above code to fix this
problem.

Thanks,

Dave

[Ryan Riddell]

Try
tablesList.Data Source = dt.Rows();

"kscdavefl" wrote:

I am trying to fill a datalist with table names from an Oracle database. The
program works fine using the following code:
private void GetTables()
{
// open a database connection
string con = connectLabel.Te xt;
cn = new System.Data.Ole Db.OleDbConnect ion(con);
cn.Open();

//Declare a DataTable Object
System.Data.Dat aTable dt ;

//Query for getting the list of all tables from the schema , no restriction
dt = cn.GetOleDbSche maTable(OleDbSc hemaGuid.Tables , null);
//Display the tables in the tablesList
tablesList.Data Source = dt;
tablesList.Data Bind();
}

However, the datalist displays System.data.Dat aRowView in the datalist when
I run the program. What do I need to change in the above code to fix this
problem.

Thanks,

Dave

[Mike Newton]

Are you setting the DataList.ValueM ember and DataList.Displa yMember
properties? If you don't do that, I think it defaults to the Type name
of whatever object is assigned to the list.

kscdavefl wrote:

I am trying to fill a datalist with table names from an Oracle database. The
program works fine using the following code:
private void GetTables()
{
// open a database connection
string con = connectLabel.Te xt;
cn = new System.Data.Ole Db.OleDbConnect ion(con);
cn.Open();

//Declare a DataTable Object
System.Data.Dat aTable dt ;

//Query for getting the list of all tables from the schema , no restriction
dt = cn.GetOleDbSche maTable(OleDbSc hemaGuid.Tables , null);
//Display the tables in the tablesList
tablesList.Data Source = dt;
tablesList.Data Bind();
}

However, the datalist displays System.data.Dat aRowView in the datalist when
I run the program. What do I need to change in the above code to fix this
problem.

Thanks,

Dave