recordset VB.net

[ooshy]

I have an inner join between 2 tables that have the same fields.
I need the syntax to read the values from the recordset specifying from which table to get the value.
In VB 6 it could be written for example as follows:

rs!Table.column

In VB.NET when I write

rs(“Table.column”)

It gives me the following error:

“An unhandled exception of type 'System.Runtime.InteropServices.COMException' occurred in adodb.dll

Additional information: Item cannot be found in the collection corresponding to the requested name or ordinal.”

[hariharanmca]

I have an inner join between 2 tables that have the same fields.
I need the syntax to read the values from the recordset specifying from which table to get the value.
In VB 6 it could be written for example as follows:

rs!Table.column

In VB.NET when I write

rs(“Table.column”)

It gives me the following error:

“An unhandled exception of type 'System.Runtime.InteropServices.COMException' occurred in adodb.dll

Additional information: Item cannot be found in the collection corresponding to the requested name or ordinal.”

You cannot give like this rs(“Table.column”)

if its same name then you can give alies name for one field then use that fieldname

rs(“AliesName”)

[ooshy]

actually i have two tables:
this is the line that is giving the error im not using

Desc = rs ( "[GLOBAL].Description " ).Value

[hariharanmca]

actually i have two tables:
this is the line that is giving the error im not using

Desc = rs ( "[GLOBAL].Description " ).Value

Use like this
====================QRY=========================

SELECT table1.field1 as fieldof1, table2.field1 as fieldof2
FROM Table1 INNER JOIN table2 ON Table1.Field2 = table2.Field2


then you can get two different field names

then use
rst.field("fieldof1") 'for table1.field1
and
rst.field("fieldof2") 'for table2.field1