use of SqlDataAdapter with a table without Primary Key

[DraguVaso]

Hi,

I thought it isn't possible to use a SqlDataAdapter and a Databound grid
when there isn't a 'real' primary key on the table.
Although, is there a way to use it, and define somewhere in the
SqlDataAdapter my own primary key on the table?

I can't add a primary key to the table, so I guess that's the only way to
find a solution?

Any help would be really appreciated!

Thans a lot in advance,

Pieter

[Miha Markic [MVP C#]]

Hi,

Yes, dataadapter doesn't require a primary key. It is required just by the
wizards to generate insert/update/delete statements.
Also, dataadapter has nothing to do with binding to table.

--
Miha Markic [MVP C#] - RightHand .NET consulting & development
www.rthand.com
SLODUG - Slovene Developer Users Group www.codezone-si.info

"DraguVaso" <pi**********@hotmail.com> wrote in message
news:%2******************@TK2MSFTNGP09.phx.gbl...

Hi,

I thought it isn't possible to use a SqlDataAdapter and a Databound grid
when there isn't a 'real' primary key on the table.
Although, is there a way to use it, and define somewhere in the
SqlDataAdapter my own primary key on the table?

I can't add a primary key to the table, so I guess that's the only way to
find a solution?

Any help would be really appreciated!

Thans a lot in advance,

Pieter

[Cor Ligthert]

Pieter,

From where do you have that idea?

Cor

[Cowboy \(Gregory A. Beamer\)]

You can create your own CRUD statements and avoid creating a magic key.
Simply write the INSERT, UPDATE and DELETE statement rather than relying on
the DataAdapter to automagically create one for you. As long as the SQL for
all four statements is correct, you are up and running.

--
Gregory A. Beamer
MVP; MCP: +I, SD, SE, DBA

*************************************************
Think outside the box!
*************************************************
"DraguVaso" <pi**********@hotmail.com> wrote in message
news:#Z**************@TK2MSFTNGP09.phx.gbl...

Hi,

I thought it isn't possible to use a SqlDataAdapter and a Databound grid
when there isn't a 'real' primary key on the table.
Although, is there a way to use it, and define somewhere in the
SqlDataAdapter my own primary key on the table?

I can't add a primary key to the table, so I guess that's the only way to
find a solution?

Any help would be really appreciated!

Thans a lot in advance,

Pieter

[DraguVaso]

Hehe I don't know anymore.
But it's great that it seems I'm able do do use it, although with writing
the upate statements myself, but that's no problem.

thanks a lot!

"Cor Ligthert" <no************@planet.nl> wrote in message
news:uJ**************@TK2MSFTNGP15.phx.gbl...

Pieter,

From where do you have that idea?

Cor

[Cor Ligthert]

Pieter,

You was not telling that you wanted to update (and therefore my question).

Despite all others answers won't I not know what to update or to delete when
I don't have that key. (Inserting will go when there is an autoincrementkey
or a Guid used for the uniqueidentifier).

Just my thought,

Cor