Hi all,

In my Web form I have DataGrid1 and want to
add 2 cols in DataGrid1.DataKeyField property.
If I had 1 col. it would be DataGrid1.DataKeyField = "ColName1",
but how can I add another more "ColName2"?

Nenad

hi
i have same problem pls help me

shailesh

shailesh kavathiya

In few occassions as I found no direct ways, I joined both the fields with a seperator(":") as new key field in my query. used the "strNewKey.split(":")" to sepeate when reading from the datakey collection.

Hi
I can get you
Please explain more


in datagrid propety

url filed = {SubCatID}:{MainCatID} this way not workign

url format string =../category.aspx?id={0}&c={1}

shailesh




shailesh kavathiya

I think what Prashant means is that you would have to join the data from the database query into a single column.

SELECT ColName1+':'+ColName2 AS MyKeyField, [more fields] FROM...

Then use that single concatenated field as your primary key because it will be unique:

DataGrid1.DataKeyField = "MyKeyField"

-Peter

Hi Petar
Thanks for replay

but i want to use more then one value so i got main category id as wall as sub category id

i try to make same site like
http://www.iservedesign.com/contact.asp

see leftmenu in this link
how can i pass 2 value in datagrid

shailesh


shailesh kavathiya

I'm not sure how to explain this any more clearly...

The DataGrid.DataKeyField property does not (to my knowledge) take anything more than a single field. If you have a table/query that uses multiple fields as a primary key then you need to work around this. One option that I explained is to concatenate your primary key fields together and thus form a *unique* single field that you can then use as the DataKeyField. If you join the values together with some known character, you can break them apart to get at the multiple parts of the unique key. What you do with those values is then up to you.

-Peter

Hi peter

Thank for try to explain
i also try other wise i use singe table filed use for link

shailesh


shailesh kavathiya

Shailesh,

another way is to create a template column containing a hyperlink and use databinding expression to make a concatenated string containing the values.



Regards
Ganesh