Posts by lacaroix

hye there..i need help here..im developing a smartphone device.
i need to install a sql server ce but somehow i download it,but i cant run application.so my ques is how do i know wat the version of my sql server 2000 (version 8.0)competible wif which sql server ce?
thanks in advance.

how can i search a word from the whole database using search button?and the result appear is the page of the words?need help...

thanks for the advice and the codes =)

THANK YOU Jx_Man for the link.my problem solve =)

ok,the interface 1:combobox 2:textbox(translation).
mine is like in the combobox(dropdown menu) are list of the english words(word_id).user can chose one of the words then after clicking a translate button the meaning of the words will appear in the textbox,which here the data retrieved frm db(word_translate_.and also viewed in textbox.
databse table:table_word
choosen item=word_id
textbox=word_translate

and im also having a problem on connection string.the eror sed "connection string is not initialized."

im doing myproject in smartdevice application.isit i stil can using the same coding?because it seems still having an error on PlaySound(strFileName, IntPtr.Zero, SoundFlags.SND_FILENAME Or SoundFlags.SND_ASYNC)
which it sed "An unhandled exception of type 'System.MissingMethodException' occurred in SmartDeviceApplication2.exe"

i still cant get it.anyway any idea of coding of i just let user choose the item frm combo box then retrived the data from databse and view it.

okay..thank you for the program.i donwload it again..so,as u done it in windows application.isit the coding for windows app n smartdevice app is the same?because when i try it in smartdevice application,there an error in line afta i run
PlaySound(strFileName, IntPtr.Zero, SoundFlags.SND_FILENAME Or SoundFlags.SND_ASYNC)

the error sed "An unhandled exception of type 'System.MissingMethodException' occurred in SmartDeviceApplication2.exe"

cant open the attachment file.

i cant open the file.wat extension isit?

why afta i run the file there an errors in line "PlaySound(strFileName, IntPtr.Zero, SoundFlags.SND_FILENAME Or SoundFlags.SND_ASYNC) End Sub"

An unhandled exception of type 'System.MissingMethodException' occurred in LearnJapaneseTutorialSystem.exe
any mistakes dat i did?

in my application, i need to add a sound.how can i add a sound button?
after click a button it will play the sound.no need a stop button..
thanks in advance..

the code will dispay on the combo box rite?
nway mine is select frm the combo box(a japanese word)and displaying in text box which the textbox(english word) will retrieved the data form the database...its sumthing like a dictionary but its simpler than dictionry..
sorry for the trouble but im a bit blurr in tis coding...thanks in advance..

sorry..here my coding...the error stil the same..there an arrow shoe at the

conn.Open()

thanks you in advanced..

Dim connectionString As String = "Driver={MySQL};SERVER=MUBINZ;DATABASE=japanese;"
        Dim conManager As String = ""
        Dim com As New SqlCommand
        Dim conn As New SqlConnection'open connection
        Dim text As String = TextBox1.Text
        Dim temp As String = ComboBox1.SelectedItem
        Dim da As SqlDataAdapter
        Dim ds As DataSet
        Dim dr As SqlDataReader
        Dim sql As String


        conn.Open()

        temp = ComboBox1.SelectedItem
        sql = "select translation_japan from table_greeting where greet_id = '" & temp & "'"
        com.CommandText = sql
        conn.ConnectionString = connectionString
        com.Connection = conn
        dr = com.ExecuteReader()

        While dr.Read
            text = dr.GetValue(0)
        End While

        TextBox1.Text = text
        conn.Close()

    End Sub

im using sqlserver..act im not sure wat my prob is..here my coding for click button..afta i run the application there the error sed

An unhandled exception of type 'System.InvalidOperationException' occurred in System.Data.SqlClient.dll

Additional information: The ConnectionString property has not been initialized.

here my coding...

    Dim connectionString As String = "Driver={MySQL};SERVER=MUBINZ;DATABASE=japanese;"
    Dim conManager As String = ""
    Dim com As New SqlCommand
    Dim conn As New SqlConnection'open connection
    Dim text As String = TextBox1.Text
    Dim list As String = ComboBox1.SelectedValue
    Dim da As SqlDataAdapter
    Dim ds As DataSet
    Dim dr As SqlDataReader
    Dim sql As String


    conn.Open()

    list = Me.ComboBox1.Items("Good morning") = 0
    sql = "select translation_japan from table_greeting where greet_id = & Good morning.selectedvalue"
    com.CommandText = sql
    conn.ConnectionString = connectionString
    com.Connection = conn
    dr = com.ExecuteReader()

    While dr.Read
        text = dr.GetValue(0)
    End While

    TextBox1.Text = text
    conn.Close()

End Sub

oh thanks..sorry for the late reply..neway i tried.i think there might haf some problems wif my connection string..its stil error..so mybe i need to figure it out wat happen act..

okay.i try to run..there's an erorr about connection string..
"An unhandled exception of type 'System.ArgumentException' occurred in System.Data.SqlClient.dll

Additional information: Unknown connection option in connection string: driver."

im not veru sure about the coding to connection of database..any advice?tq~

im a beginner in vb.net.im developing for myproject in windows application.my ques:how can i display data in textbox from choosen dropdown menu?user choose a item in combobox,then after click a button the meaning of data appear in textbox..i need some help..tq in advance