Connecting to SQL Server 2005?

[rperreta]

Hi everyone,



I have been google'n looking for answers and I can't seem to find them.. Basically I want to take my t-mobile Wing Application and connect it to SQL Server 2005. I also tried to use a web service and that failed as well. Any help or sample code showing how to do this would be awesome....



thanks

rich





Here's what I have right now...

Imports System.Data.SqlServerCe

Imports System.Data

Public Class Form1

Private Sub Form1_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles MyBase.Load

Dim conn As New SqlCeConnection("SERVER=xxx.com;UID=sa;PWD=xxx;Database=xxxxx")

conn.Open()

Dim da As New SqlCeDataAdapter("SELECT * From Players", conn)

Dim ds As New DataSet

da.Fill(ds, "Players")

ListBox1.DisplayMember = "Playerlogin"

ListBox1.DataSource = ds.Tables("Players")

conn.Close()

End Sub

End Class

 

[rperreta]

I thin I figured it out - I was connected to the PC so it was not accessing the internet - it seems to pull back a datarowview - If this is true how can I get it to access the internet while connected?

-rich