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?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

ardukCommented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
IntercareSupportAuthor Commented:
I'll look at this.  I haven't forgotten this post, I just have been occupied.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Web Development Software

From novice to tech pro — start learning today.