Hi, I switched from Access datab

[ncirkel]

Hi,

I switched from Access databases and ASP to sql-server and ASP.NET some time ago and now ran into a little difference. I am not quite sure if the difference is in ASP.NET or in sql-server.

When I open a dataset using a join-query, I am no longer able to refer to columns as in "tablename.columnname". Therefore, if I have a table Countries and a table Cities and they both have a Name column, when I join them together I don't know how to refer to one of them (Countries.Name or Cities.Name returns an error).

How can I do this?

Thanks a lot,
Nander

 

[SQLSister]

exactly what error message are you getting because that is a correct way to refer to tablename.Fieldname

 

[ncirkel]

The error message is:

System.ArgumentException: Column 'City.Name' does not belong to table Table

"Table" is the name of the table that holds the query in the dataset.

 

[ncirkel]

I did some more research. I use Microsoft's SQLHelper class to fill the dataset. It uses the following code to get the queryresults into the dataset:

                'create the DataAdapter & DataSet
                da = New SqlDataAdapter(cmd)

                'fill the DataSet using default values for DataTable names, etc.
                da.Fill(ds)

Guess that's where the table names are lost, but I can't think of a way to prevent it from doing this.