After joining two or more tables i am getting repeatative column name. GetOrdinal("Column Name") in c# always returns the ordinal of 1st column name encountered. suggest me a way of doing this.

Usually GetOridinal("TableName.ColumnName") is the way to go. If your column or table names contain spaces then don't forget to enclose them in delimiters. In SQL Server this is "[Table Name].[Column Name]" but I think in Oracle its "'Table Name'.'Column Name'".

/- Sam Judson : Wrox Technical Editor -/

no, in oracle also its GetOrdinal("Column Name"). its not GetOrdinal["TableName.ColumnName"). even the "'Table Name'.'Column Name'" is throwing same error.

System.IndexOutOfRangeException:

Use aliases for your duplicate column names

Woody Z
http://www.learntoprogramnow.com
How to use a forum to help solve problems

Another alternative is of course to run the sql in toad (or whatever oracle editor you might be using) and see what column names it gives you, or run it in .net and loop through each column outputting the column name.

/- Sam Judson : Wrox Technical Editor -/