Ok I am back, as your reference to the last question. How is the price binded at the first place?

Let say you have several restaurant link to that main table, I guess there will be multiple row there for different rid. Was that the price you binded took the first row value as the first time you bind the grid ?

Last time I did something like this it was quite tricky, so you might take awhile to figure out. I dont know which one is the best option, because normally they will have a dropdownList in the edittemplate, show it when edit and save it.

You want to have a dropdown on view, select, raise event and change gridView data. This:
protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e) will be called after the GridView is bind.

This is what my idea was (look at the code)

You might wanna try around first to get to the right cell, but this should be your direction

If you see prices in that query, then the binding is wrong. I gotta know how is the table look like, I guess there will be several rows with different price but the same fid, or fname. In that case, you would still see thing like:

price fid fname
5 4 pizza
6 4 pizza

In that's case you have to exclude the price from the query and populate it up on the restaurant. (like we did in the last question), it's will be tough, but it can do.

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

Trust me in this. Convince your boss, tell him, the idea you are dealing with now is not very user friendly and hard to maintain .

Let say you have way too much dropdown list with the same data (restaurant names) in 1 gridView. Let say if you have 20 foods, then the desired GridView will have 20 rows. And 20 dropdownlists contain exactly the same data. And let say you have 10 restaurant, then you would have: 20 ddl with 10 exact items.

Beside, the task to populate such layout also take huge brains >.<. when you have more records, page will slow because of the dynamic populate...

User will also confuse when they have made several selection, cause they see prices from several restaurant and not so sure if they mean for same food (especially for those have bad eyes)

It's up to you ^^. I am glad you work it out or at least have a better design and understanding. ^^

You can accept my answer and post a new one. ^^ of course I would like it. Because the new one might come with new issue and can be expanded. And I think the mod would like to see that. When future reference needed, it will be easier to specify

A long time ago (May 2011), I have written an article showing you how to create a DLL using Visual Studio 2005 to be hosted in SQL Server 2005. That was valid at that time and it is still valid if you are still using these versions. You can still re…

Real-time is more about the business, not the technology. In day-to-day life, to make real-time decisions like buying or investing, business needs the latest information(e.g. Gold Rate/Stock Rate). Unlike traditional days, you need not wait for a fe…

Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail. The methods are covered in more detail in o…