VB.Net app send information via HTTP to SQL server

[Jonathan]

Hi

A want to write a new local VB.Net application. One of the features I want
it to have is to be able to send a few small pieces of information to my
website's backend SQL Server database hosted at GoDaddy.com. E.g.

Client Code: 456418
Amount: $455.98
Stock Number: 945482

I expect I'll just want to run an INSERT query statement to append this data
to the financial transactions table.

How could I do this? I have programmed quite a bit in MSAccess, used
FrontPage to write ASP.NET but never with VB.Net Studio. I can download VS
Express VB.Net from MS.

[Mr. Arnold]

Re: VB.Net app send information via HTTP to SQL server


"Jonathan" <none@none.comw rote in message
news:uV%23j80Sj IHA.4080@TK2MSF TNGP03.phx.gbl. ..

Hi
>
A want to write a new local VB.Net application. One of the features I want
it to have is to be able to send a few small pieces of information to my
website's backend SQL Server database hosted at GoDaddy.com. E.g.
>
Client Code: 456418
Amount: $455.98
Stock Number: 945482
>
I expect I'll just want to run an INSERT query statement to append this
data
to the financial transactions table.
>
How could I do this? I have programmed quite a bit in MSAccess, used
FrontPage to write ASP.NET but never with VB.Net Studio. I can download VS
Express VB.Net from MS.
>

What you need is a good ADO.NET book.

http://www.google.com/search?hl=en&q=ado.net+and+SQL+sever+book&btnG=Google+Search

[Michel Posseth [MCP]]

Re: VB.Net app send information via HTTP to SQL server

Hello Jonathan

The most obvious aproach would be in my opinion to create a webservice that
accepts the parameters from your winform app
so do some googling on webservices and see if this suits your needs in my
opinion it is the easyest way to acomplish what you want
although there are other ways ofcourse,, with the httpwebrequest object for
instance you could post the data to a webpage but this requires a lot more
coding on the client ( winform ) side while the webservices would generate
all the code automaticly ( you wouldn`t be aware of the low level
comunication )


regards

Michel



"Jonathan" <none@none.coms chreef in bericht
news:uV%23j80Sj IHA.4080@TK2MSF TNGP03.phx.gbl. ..

Hi
>
A want to write a new local VB.Net application. One of the features I want
it to have is to be able to send a few small pieces of information to my
website's backend SQL Server database hosted at GoDaddy.com. E.g.
>
Client Code: 456418
Amount: $455.98
Stock Number: 945482
>
I expect I'll just want to run an INSERT query statement to append this
data
to the financial transactions table.
>
How could I do this? I have programmed quite a bit in MSAccess, used
FrontPage to write ASP.NET but never with VB.Net Studio. I can download VS
Express VB.Net from MS.
>
>
>

[Jonathan]

Re: VB.Net app send information via HTTP to SQL server

Thanks. That's good because I don't want the user to see what's going on --
they don't need and I don't want them to see the communication. My plan is
to have it come from a Microsoft Office Add-in (Vb.Net, Office 2007, VSTO)
which I am hoping to write soon.

I trust the communication will in all situations get through any corporate
firewalls at any of the client sites?

I have scoured around the internet to see any Vb.Net examples of code of how
this could be done but haven't found a simple, comprehensive example as yet.

If anyone knows the code needed to say run an INSERT query to push the data
into the www.mywebsite.com SQL Server that would be appreciated.

Client Code: 456418
Amount: $455.98
Stock Number: 945482

tblTransactions

Also, in general terms, what really is meant by the phrase 'Webservice'?




"Michel Posseth [MCP]" <MSDN@posseth.c omwrote in message
news:%23cstGQZj IHA.4712@TK2MSF TNGP04.phx.gbl. ..

Hello Jonathan
>
The most obvious aproach would be in my opinion to create a webservice

that

accepts the parameters from your winform app
so do some googling on webservices and see if this suits your needs in my
opinion it is the easyest way to acomplish what you want
although there are other ways ofcourse,, with the httpwebrequest object

for

instance you could post the data to a webpage but this requires a lot more
coding on the client ( winform ) side while the webservices would generate
all the code automaticly ( you wouldn`t be aware of the low level
comunication )
>
>
regards
>
Michel
>
>
>
"Jonathan" <none@none.coms chreef in bericht
news:uV%23j80Sj IHA.4080@TK2MSF TNGP03.phx.gbl. ..

Hi

A want to write a new local VB.Net application. One of the features I

want

it to have is to be able to send a few small pieces of information to my
website's backend SQL Server database hosted at GoDaddy.com. E.g.

Client Code: 456418
Amount: $455.98
Stock Number: 945482

I expect I'll just want to run an INSERT query statement to append this
data
to the financial transactions table.

How could I do this? I have programmed quite a bit in MSAccess, used
FrontPage to write ASP.NET but never with VB.Net Studio. I can download

VS

Express VB.Net from MS.

>
>

[rowe_newsgroups]

Re: VB.Net app send information via HTTP to SQL server

Also, in general terms, what really is meant by the phrase 'Webservice'?

I meant to tell you, a WebService is a UI-less object that can be
interacted with through code. The webservice sends and receives
information through SOAP formatted Xml (see wikipedia for a rundown on
SOAP and Xml). Just imaging have a code library that floats around
hyperspace waiting for it to be used, that, in it's simplest form, is
a web service. One great feature is that a web service can be called
by almost any language, be it .NET or PHP or just plain html.

Be warned, that if you don't authenticate and authorize people to use
your service, anyone who discovers it will be able to call it whenever
and however they want. So besides using just SSL to protect the
transmissions, you might want to figure out a way to lock down your
service to prevent people from abusing it. I would highly recommend
you do some heavy reading (or outside contracting) on ASP.NETs ways of
authorizing users.

Thanks,

Seth Rowe [MVP]

[Jonathan]

Re: VB.Net app send information via HTTP to SQL server

Thanks again.


"rowe_newsgroup s" <rowe_email@yah oo.comwrote in message
news:57a5c18b-1be7-43b0-baa0-8ada49ff7812@n5 8g2000hsf.googl egroups.com...

Also, in general terms, what really is meant by the phrase 'Webservice'?

>
I meant to tell you, a WebService is a UI-less object that can be
interacted with through code. The webservice sends and receives
information through SOAP formatted Xml (see wikipedia for a rundown on
SOAP and Xml). Just imaging have a code library that floats around
hyperspace waiting for it to be used, that, in it's simplest form, is
a web service. One great feature is that a web service can be called
by almost any language, be it .NET or PHP or just plain html.
>
Be warned, that if you don't authenticate and authorize people to use
your service, anyone who discovers it will be able to call it whenever
and however they want. So besides using just SSL to protect the
transmissions, you might want to figure out a way to lock down your
service to prevent people from abusing it. I would highly recommend
you do some heavy reading (or outside contracting) on ASP.NETs ways of
authorizing users.
>
Thanks,
>
Seth Rowe [MVP]