Table 1
___________
Id (pk)
TicketId(Fk)
.
.
Statusafter (int)
___________

The GridView gets its Values by the Foreign Key. This key delivers a set of records each with a unique id wich is the primary key.
Now i have a dropdownlist6 in the gridview that is attached to the statusafterid. I want that as i change the drowpdownlist the sqlupdatecommand is cast and the changed dataset connected to the pk is getting updated.
the problem is i cant specify a update statement because i dont know how to access the pk of that specific set. this is one possible way to update. can someone help me?


Ivan

__________________
Ivan

Ivan,

I am having essentially the same problem that you are having. I have a gridview that presents data from two tables, connected by FK's. I want to change data in a dropdown list containing data from 'table A', and take the ID of the data in the ddl and update the FK in 'table B'. I cannot figure out how to reference the ID. The ID is the PK in 'table A', and the FK in 'table B'. The ID is the uniquie identifier to the item in the ddl.

Please let me know if you have a solution.

Thanks!

Richard Lelle
Austin, Tx USA

Guys, Can you tell me what statement you are writing for updating the tables?? Also, tell me where exactly you are facing the problem.

gaurav_jain2403,

As for now, my problem is not so much as a statement, but how to get the data. I have a gridview with a dropdown list that is a template field. This field is an 'EditItem' template, and when using the DrpDownList tasks/Choose Data Source for that field, I specify 'actv_dscr' as my 'data field for display', and the 'actv_id' as my 'data field for the value'. I am displaying the 'actv_dscr' in the ddl, and it's unique identifier (a FK to a primary table that I wish to update) is the 'actv_id'. If a user uses the ddl to change the 'actv_dscr', I need it's associated 'actv_id' to be updated on a (different) primary table. How to I reference the 'actv_id'? Is this enough info to go on? If not, I'll try to come up with whatever coding I have right now.

Thanks!

Richard Lelle
Austin, Tx USA

From where do you want to reference the actv_id? In database or .Net? If .Net, in which event you are trying to access its value and from where you are accessing value??

I would want to access it in .NET, in a 'update' event/method. I'm thinking that when a user chooses a new description, then clicks the 'update' button, I would need the 'actv_id' associated to the 'actv_dscr' to update the primary table.

Richard Lelle
Austin, Tx USA

Use this code to access the value of actv_id:

string id = MyDropDownList.selectedValue;

To precise my Problem:

I have a DetailsView which represents One 'TicketId'
I have a gridview for that so called ticket which contains many other Table1.Id (pk) according to this one 'Ticketid'.
because i know that it is only possible to select one ticket from each gridview and than edit it, i want to know if it is possible to directly manipulate one value with a drop down list for example.

By the way i am asking myself if it is possible to load the gridview in edit mode?

Ivan