Quote:
|
and added a WHERE to the query
|
Yes, that's what you need, and what I had in my example as well.
Quote:
So I want to turn all these Insert buttons into one. Is this possible? If yes, how do I do it?
|
There might be a way to do it (you could probably create a custom button and trigger custom command on the FormView contols). but you have to ask yourself the question: do I want to go this route. FormViews are great for many data scenarios where there's a one to one mapping between the FormView and a database table. However, as soon as you're getting in more advanced scenarios as yours, maybe handing coding your pages using controls directly in the page and LINQ to SQL in the Code Behind may be a much better alternative.
Cheers,
Imar