Datakey for Datagrid

[Kimberly]

Hi - Is it impossible to define multiple datakeys for a datagrid? If
so - any ideas on how to update a record selected from a datagrid
using the Edit, Update, Cancel buttons? I can not get past trying to
define my datakeys. I can define one of the keys but what about the
other 2?? Here is my code...

//These fields make up my key

DateTime Event_start =
(DateTime)event_grid.DataKeys[e.Item.ItemIndex];
string plat = (TextBox)e.Item.Cells[1].Controls[0];
string system = (TextBox)e.Item.Cells[3].Controls[0];

//get the new values that were entered

event_text = (TextBox)e.Item.Cells[0].Controls[0];
Event_start_display = (TextBox)e.Item.Cells[2].Controls[0];
Notify_start = (TextBox)e.Item.Cells[4].Controls[0];

string Update_db = "update t_cust_appl_evt set ntfy_strt_dtm
='"+Notify_start.Text.Trim()+"'...

Any help is greatly appreciated.

 

[Teemu Keiski]

No,

you could combine all key fields into one in the SQL query and set this
combined field to be the data key field. When you need keys, just split them
up from the combined representation (for example comma-separated)

--
Teemu Keiski
MCP, Designer/Developer
Mansoft tietotekniikka Oy
http://www.mansoft.fi

AspInsiders Member, www.aspinsiders.com
ASP.NET Forums Moderator, www.asp.net
AspAlliance Columnist, www.aspalliance.com