Editing/Deleting/Inserting Records using ASPxGridView

W

WebGuy

I'm using Visual Studio 2005 and SQL Server 2005, and I've created an
AJAXenabled ASPx.Net Website. In one of my SQL Server tables, I have Social
Security Number as my PrimaryKey, and I'm using this field as a Seach
parameter in my WebForm. My question is this ... Is it necessary to display
the PrimaryKey in the ASPxGridView in order for you to be able to
Edit/Update a record? When I include the PrimaryKey field in the
ASPxGridView, I can Edit/Delete records, but if I don't include the
PrimaryKey (or set it to Visible=False) then I can't Edit/Delete records.

Thanks in advance for any advice/assistance offered.

Shane
 
G

Guest

Hi,

You can delete the records from the GridView even if you do not specify any
Primary key in your Table but in that case your delete query would not be
automatically generated by the sqldatasource.

You will have to write your query yourself in the deleteQuery in the
SQLDataSource and specify the DataKeyName property of the GridView to be one
of the column of the table on the basis of which the row would be deleted
from the table.

Regards,
Manish
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

Forum statistics

Threads
473,744
Messages
2,569,482
Members
44,901
Latest member
Noble71S45

Latest Threads

Top