Writing directly to Sharepoints SQL Database

[Lurkio1983]

Not sure if this is the right area but I'm developing a piece of software that will launch applications amongst other things, If a certain piece of software is not installed there will be an option to submit a request into our sharepoint helpdesk.

I was wondering what the best way to execute this would be. The software is written in vb.net. I was wondering if i could get vb.net to take all of the required info and write it directly into Sharepoints database... however, if i do this, will the new item display when the helpdesk is opened and will the workflows be processed as normal?

I've searched google but i can't seem to find what i'm looking for...

Thanks in advance.

 

[chrisbarba]

You don't want to write directly to sharepoint database. Microsoft recommends against it.

SharePoint does have some web services you can call.
I have used the one that lets you read data from a sharepoint list. I don't know if one is provided to write data to a list. You will need to google that.

If there isn't one than you can write your own web service (which will live on the sharepoint server) and you use the object model to write to the list.

Here is a link with a sample of creating your own web service to write against a sharepoint list.

http://devlicio.us/blogs/derik_whit...formation-in-sharepoint-via-web-services.aspx

Chris

http://chrisbarba.wordpress.com