I am trying to select 1 column from my table, but it keeps automatically adding the ID column of the table. I donw'w want or need this column. Iam using the query builder to do this. I haven't switched any properties that are the defaults for the adapert.

Any ideas???

thanks
JIm

In your sql statement just use:

SELECT column_name FROM table_name

Yes, thank you, I know SQL very well .. that is not the issue

The issue is that it is putting the id column there no matter what the select statement is

what is the code you are writing so you got a id column instead of of needed column
what data access you are using ADO or ADO.net ?

Ahmed Ali
Software Developer

I am using ADO.NET

it is a simple select statement of 1 column...

but it keeps putting the ID column, (primary key), in the select statemtent after the fact. So, when I generate a data set the id column is in it..

It is doing this automatically and I don't know why

Jim,

When you use a dataadapter it needs the primary key of the table to be able to establish the unique rows for updates and deletes. It sounds like you are creating the data adapter from some of the wizard functionality of VS. Particularly with ASP.net, you may not need the functionality (and overhead) of a data adapter. If you use a data reader to retrieve the data it might be a little faster and easier to work with.

Can you describe in a bit more detail what your code is doing, and how you got to this point? Let's see if we can work out an alternative to this.

Peter
------------------------------------------------------
Work smarter, not harder.

it has never done this before. I can userstand if I am using it to generate update commands etc, but I am just using it for a Select.