Windows CE application + MySQL

mya_myra Publish time 3-12-2008 08:39 AM

Hye forumers sekalian....

Haritu dah settle pasal Windows Application VB.Net + MySQL....

Skang ni plak, aku ada masalah connection VB.Net + MySQL dalam Windows CE application......kira handheld device, pocket pc, etc...

Anyone??? :$

naikAntena Publish time 3-12-2008 01:57 PM

wowww.. myamira otai rupanya.... tumpang tanya sket lagi... untuk Handheld.. kita nk connection bloototh dari handheld ke printer (like o'neil printer).. mcm mana plakk arrr.... use dev c++

-cup... cuupp- atas tuh bukan saya taip... member saya.. siot!!!:@

[ Last edited bynaikAntena at 3-12-2008 02:01 PM ]

mya_myra Publish time 4-12-2008 12:16 PM

well....sebab tak tau la sy tanya ni...hehehe...

so, ada idea tak?

stingbeh Publish time 5-12-2008 01:37 AM

dah ader ke driver mysql untuk compact framework?

mya_myra Publish time 5-12-2008 08:16 AM

dah ada.....pakai Connector .Net 5.1.7 punya...

tapi dia kluar error....Unable to connect to any of the specified MySQL hosts

kenapa ek?

mya_myra Publish time 5-12-2008 08:18 AM

nicoding saya......for ur reference......

Imports System.Data
Imports MySql.Data.MySqlClient

Public Class Form1
Dim mycon As New MySqlConnection
Dim mycmd As New MySqlCommand
Dim myreader As MySqlDataReader

Private Sub btnEnter_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnEnter.Click
   'Dim myconstr As String

   If txtUsername.Text = "" Then
         MsgBox("Please enter the Username", MsgBoxStyle.OkOnly, "No Username")
         txtUsername.Focus()
         Exit Sub
   End If

   If txtPassword.Text = "" Then
         MsgBox("Please enter the Password", MsgBoxStyle.OkOnly, "No Password")
         txtPassword.Focus()
         Exit Sub
   End If

   'myconstr = "Server=localhost;" & _
   '                      "Database=testing;" & _
   '                      "Uid=root;" & _
   '                      "Pwd=;"
   'myconstr = "database=testing;Data source=localhost;User Id=root;Password="
   'myconstr = "datasource=localhost;username=root;password=;database=testing"
   'mycon = New MySqlConnection(myconstr)
   mycon.ConnectionString = "server=localhost;user id=root;database=testing"
   'mycon.ConnectionString = "user id = root;database=testing;host=localhost;password="
   'mycon.ConnectionString = "Server=localhost:3306;Database=testing;User ID=root;Password=xxxx;CharSet=utf8"
   mycon.Open()

   mycmd.Connection = mycon
   mycmd.CommandText = "SELECT username, password, message FROM login"

   myreader = mycmd.ExecuteReader

   While (myreader.Read())
         If myreader.GetValue(myreader.GetOrdinal("username")) = txtUsername.Text Then
            If myreader.GetValue(myreader.GetOrdinal("password")) = txtPassword.Text Then
               Form2.lblUsername.Text = txtUsername.Text
               txtUsername.Text = ""
               txtPassword.Text = ""
               Hide()
               Form2.Show()
               Form2.lblMessage.Text = myreader.GetValue(myreader.GetOrdinal("message"))
               myreader.Close()
               mycon.Close()
               Exit Sub
            Else
               MsgBox("Wrong Password", MsgBoxStyle.Exclamation, "Password Error")
               txtPassword.Text = ""
               txtPassword.Focus()
               myreader.Close()
               mycon.Close()
               Exit Sub
            End If
         End If
   End While

   MsgBox("User does not exist", MsgBoxStyle.OkOnly, "Username Error")
   txtUsername.Text = ""
   txtPassword.Text = ""
   txtUsername.Focus()

   myreader.Close()
   mycon.Close()

End Sub

End Class

[ Last edited bymya_myra at 5-12-2008 08:21 AM ]

mya_myra Publish time 5-12-2008 08:20 AM

macam2 connection string saya pakai....

'myconstr = "Server=localhost;" & _
   '                      "Database=testing;" & _
   '                      "Uid=root;" & _
   '                      "wd=;"
   'myconstr = "database=testing;Data source=localhost;User Id=rootassword="
   'myconstr = "datasource=localhost;username=root;password=;database=testing"
   'mycon = New MySqlConnection(myconstr)
   mycon.ConnectionString = "server=localhost;user id=root;database=testing"
   'mycon.ConnectionString = "user id = root;database=testing;host=localhost;password="
   'mycon.ConnectionString = "Server=localhost:3306;Database=testing;User ID=rootassword=xxxx;CharSet=utf8"

tapi semua kluar error yg sama.....takleh connect.... :'(

stingbeh Publish time 5-12-2008 04:02 PM

Reply #7 mya_myra's post

pocket pc mya tue boleh connect through network ke?

mya_myra Publish time 5-12-2008 04:57 PM

taktau lak leh connect ke tak....

actually, bleh ker install mysql dalam pocket pc ni?

stingbeh Publish time 5-12-2008 09:40 PM

Reply #9 mya_myra's post

baru nak tanya...;P ;P

cube check mysql ader tak buat untuk mysql mobile..

sting biasa pakai sqlce.. SQL server compact edition..

mya_myra Publish time 7-12-2008 08:47 PM

Originally posted by stingbeh at 5-12-2008 09:40 PM http://forum.cari.com.my/images/common/back.gif
baru nak tanya...;P ;P

cube check mysql ader tak buat untuk mysql mobile..

sting biasa pakai sqlce.. SQL server compact edition..

sqlce ni under microsoft gak ke? izit freeware, atau kena beli license punya? hmmm.....

check kat mysql website, dia cakap support windows ce.....cuma test emulator tak dapat, blum test kat device lagi....

hmm, cuba story skit pasal sqlce ni....:$

stingbeh Publish time 8-12-2008 12:58 AM

Reply #11 mya_myra's post

sqlce dia under microsoft..
rasanye free ... dia adalah sqlserver tapi dibuat untuk mobile/pocket pc.

kalau nak baca kene donwload jugak RAPI ...
rapi nie dll untuk baca sqlce punye database.

mya_myra Publish time 9-12-2008 12:42 PM

saya ada cuba sqlce ni....through this website http://msdn.microsoft.com/en-us/library/aa454892.aspx

tapi dia dah customized khas untuk add and edit...dan dia tak bagi contoh untuk delete dan retrieve.....

saya nak contoh untuk login guna username & password.....stingbeh ada example tak... :$

Pages: [1]

CARI Infonet's Archiver