Insert (sql) dataview record id to a Sharepoint list

I have a list of matches that return from my data view (via a SQL query).  I want to be able to click one of the items, and then have this add that item (just the record id) to a Sharepoint list.  How can I do this?

I was thinking that I could format the record id as a hyperlink and send it as a query string variable, but I don't know the best way to catch it and insert it to a Sharepoint list.  Thanks.
IntercareSupportAsked:
Who is Participating?
 
ardukConnect With a Mentor Commented:
I think you are heading along the right lines with a link that will load a page that will add it to the list.

If you create a custom web page, or an application page that will reside within Sharepoint, you could have that page use the Sharepoint object model (see sample at http://suguk.org/blogs/tomp/archive/2006/09/28/Adding_SPListItems.aspx, this page would need to run on the sharepoint server) or the sharepoint web services (http://royaline.wordpress.com/2008/01/03/how-to-add-a-new-list-item-to-sharepoint-using-the-list-item-web-service/ has a sample) to add the item to a list.
0
 
IntercareSupportAuthor Commented:
I'll look at this.  I haven't forgotten this post, I just have been occupied.
0
All Courses

From novice to tech pro — start learning today.