Hello,

i'm wondering if this is possible...

Ok, right

Well i want to create an admin page which will insert new entries into a database, sounds easy right? all i need to do is use form view or details view and set insert to true.

however each record defination is spread over many tables. say i am doing a cook book and i have one table for the recipes and one table for the ingredients recipe_ingredients and then a third table which lists the ingredients available. I wish to allow the admin to insert a new recipe and on that page bring back the list of ingredients (with the option to add a new one if necessary) which will be associated with the recipe_id into the recipe_ingredients table as well. I am not sure which out of detailsview and formview it is best to use.

any help would be appreciated

A detailsview or formview shows records from a single table. You will need to use a gridview to do wha you want. You will then need to specify your own select, insert, update and delete statments for the sqldatasoruce.

Jim

Hi i've been working on this problem a bit and decided not to use formview or details view but rather use sqldatasources to retrieve the data from textboxes and create insert statements manually,

then on the buttonclick i just called sqldatasource1.insert and this works fine for one of the tables creating a new recipe_ID. However on this button click i also want to insert the recipe_ID i've just created into another table so it can be used to insert the rest of the data. The queryparameter doesn't work as i'm not passing the variable from another page. would i need to create it as a session variable and then pass it into the insert statement? is so are there any examples i would be able to use?

many thanks,

michelle

Insert the first row.. reurun the id just created.. then use that in your second insert...

Sorry to bother you again, but i've been trying to return the id i've just created but it doesn't work and i haven't been able to insert it into my second sqldatasource. i tried creating a max select statement and putting it in a label which i then tried to put into the db but that too was unsuccessful.

I've just done something similar that seems to work.

Presuming cmd = new SqlCommand()


Try this as your Insert statement for table one

add your Parameters and set their values etc then

InvoiceID will now hold the Primary Key for the table just written to. You can now change your focus to other tables and utilise this variable for their relationships. I used

 for these.

Hope this helps

Hi Jim!

Could you explain a bit how you would use a GridView to insert/update data in multiple tables?


Cheers!

JF