need new_customer form to pass new list item id to another form

Question

i need my new_customer_form.aspx to capture the new item id after a new customer is entered
i then need to pass that id to another form that will make an entry in a "calls task" list that will store the the corresponding customer id

Answer 1

if you're willing to consider 3rd party, The following tool will do it for you:

http://nobhillsoft.com/Columbo.aspx

Answer 2

This not a simple task, so no ready made codes to share. You can also try this with LINQ to EXCEL.

Answer 3

Please post code..

Answer 4

Use the Excel object model (also known as Excel Interop) to read each spreadsheet.

Create a DataSet which is an in-memory copy of data; you do not need to write the data to a database. Create two tables in the DataSet, one for the data for each spreadsheet. Use a SQL query to create a union. Use the result of that to create the new spreadsheet.

Alternatively you can read the data of each of the two spreadsheets into collections and then use LINQ to create the union.