Re: Best way to communicate from Desktop to SQL DB

Thanx, looks like a lot of reading and experimenting ahead. :-)

--
Anil Gupte
www.keeninc.net
www.icinema.com

"rowe_newsgroups" <rowe_email@xxxxxxxxx> wrote in message
news:1164905143.913846.238460@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Here's two sites that may help:

Connecting via ADO and ADO.Net with VB.Net and C#
http://support.sas.com/ctx/samples/index.jsp?sid=817

And for the connection strings:
http://www.connectionstrings.com/

Thanks,

Seth Rowe


Anil Gupte wrote:
Thanx, but the critical step that I do not know how to do is to connect
to
the remote SQL Server, in other words, how do I create a connection
string
to a remote server (I know the URL and IP address). Do I need to make
any
changes to the remote SQL server?

Thanx,
--
Anil Gupte
www.keeninc.net
www.icinema.com

"RobinS" <RobinS@xxxxxxxxxxxxxxx> wrote in message
news:kNKdnV9vhrb_E_PYnZ2dnUVZ_hmdnZ2d@xxxxxxxxxxxxxx
You should communicate with the database directly, not through
ASP pages.

Here's an example I have posted before. You can probably find
gazillions others by searching these newsgroups from google groups.
This one opens the database, reads the Product table, then
iterates through it and shows the results.

Dim ds As DataSet
'open the connection
'DBConnectionString is in the Project Settings
Using cnn As New SqlConnection(My.Settings.DBConnectionString)
cnn.Open()

'define the command
Dim cmd As New SqlCommand
cmd.Connection = cnn
cmd.CommandText = "SELECT * FROM Product"
'define the data adapter and fill the data table
Dim da As New SqlDataAdapter(cmd)
ds = New DataSet
da.Fill(ds, "Product")
End Using

For Each dr As DataRow In ds.Tables("Product").Rows
Dim ProductID As Integer = CType(dr.Item("ProductID"), Integer)
Dim ProductName As String = dr.Item("ProductName").ToString
Dim ProductNumber As String = dr.Item("ProductNumber").ToString
'Dim Price As Nullable(Of Decimal)
'If .Item("Price") IsNot DBNull.Value Then
' Price = CType(.Item("Price"), Decimal)
'End If
Dim Description As String = dr.Item("Description").ToString
'Dim ProductType As Integer = CType(.Item("ProductType"), Integer)
'Dim StockType As String = .Item("StockType").ToString
Console.WriteLine(String.Format("ProductID {0}, " & _
"ProductName {1}, {2}ProductNumber {3}, " & _
"Description {4}", ProductID, ProductName, _
ControlChars.CrLf, ProductNumber, Description))
Next

Robin S.
-------------------------------------

"Anil Gupte" <anil-list@xxxxxxxxxxx> wrote in message
news:%23utT3IFFHHA.4080@xxxxxxxxxxxxxxxxxxxxxxx
Hi All:

I am looking for general directions on "the right way" to do
something,
which is very critical to my application.

I want to communicate with a SQL server database on a Windows Server
(in
the future it could be a Linux MYSQL server, but I don't know for
sure).
My application is a desktop application and at various times it may
need
to communicate with the server to select, update records etc.

Now the question is, should I build ASP pages which perform the
queries
on the server and have the desktop application read the pages and
parse
them? If so how? Are there any samples (I have done something similar
before in VB 6.0 where I embedded IE in the app and "Screen-scraped").

Or should I communicate with SQL queries directly with the server? If
so
how? Again, any tutorials etc online would help.

Thanx,
--
Anil Gupte
www.keeninc.net
www.icinema.com







.

Relevant Pages

  • Re: import 100+ tables from ACCESS to SQL Server w/ same structure
    ... Linked server needs to be pre-created and it is inflexible to change. ... DTS package is more flexible. ... Dim oTask ... The DTS should make the connection configuration flexible so ...
    (microsoft.public.sqlserver.dts)
  • Re: fill dataset/grid with multiple queries from multiple servers
    ... > Dim dsXMLData As New DataSet ... When the app first opens I get a + sign on the datagrid,> clicking that I get the word table and clicking that I get to the data, any> ideas how to get straight to the data? ... >> or just use the same connection itself but the data source portion of the>> connection string would be referencing the server name as a variable that> is ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Best way to communicate from Desktop to SQL DB
    ... the remote SQL Server, in other words, how do I create a connection string ... to a remote server. ... Dim cmd As New SqlCommand ... Dim ProductID As Integer = CType, ...
    (microsoft.public.dotnet.languages.vb)
  • Vb.Net Oracle Connection through Server Explorer
    ... I have established a connection to the oracle database using Server ... Dim myConnection As OleDbConnection ...
    (microsoft.public.vb.enterprise)
  • Re: Sql Ole not connecting
    ... security hole you've dug for yourself by using the sa login with no ... >Both the local and Allosaurus remote server are running Sql 7.0. ... >> connection scripts on my ASP pages and it works fine. ... >> Dim ConnectString, SelectStatement As String ...
    (microsoft.public.dotnet.framework.aspnet)