Search results for query: *

  1. S

    how to send a file in client/server using socket?

    in the chatting app userA want to send a file to userB can anyone tell me how to do it in VB.NET by using socket?? thanks~~~
  2. S

    Access to mysql database from other computer(VB.net/Mysql)

    thanks ya.... the below one is work... but i quite no understand how it work.. keke... i will try to understand it~~
  3. S

    Access to mysql database from other computer(VB.net/Mysql)

    is it this is what u means?? still login fail with correct id and password woh... Dim myCommand As New OdbcCommand("SELECT COUNT(*) FROM empdetail WHERE Employee_ID = @ID AND Epass = @Password", conn) myCommand.Parameters.Add("@ID", OdbcType.Int).Value = CInt(Me.TextBox1.Text)...
  4. S

    Access to mysql database from other computer(VB.net/Mysql)

    Employee_ID int len=4 Empname varchar len=30 Epass varchar len=20 i had install connector.net but i know only use to login to mysql server (T T)
  5. S

    Access to mysql database from other computer(VB.net/Mysql)

    in database have a table name empdetail( Employee_ID, Empname, Epass) 1 user( 1001, Lee, 1111) Dim myData As New DataSet Dim SQL As String Dim myAdapter As OdbcDataAdapter Dim conn As OdbcConnection Dim acc As Data.DataRow Dim a As OdbcCommandBuilder conn = New OdbcConnection...
  6. S

    Access to mysql database from other computer(VB.net/Mysql)

    okok... next time i will remember to put the error message.. i have a new problem... when i add in the conn.open and conn close is no problem in "If CInt(myCommand.ExecuteScalar()) = 0 Then" but when i run and type correct id and password to login it still shows "Login Fail." thanks for ur help...
  7. S

    Access to mysql database from other computer(VB.net/Mysql)

    is it correct?? but when i run it it come out some error =>> "If CInt(myCommand.ExecuteScalar()) = 0 Then" Dim myData As New DataSet Dim SQL As String Dim myAdapter As OdbcDataAdapter Dim conn As OdbcConnection Dim acc As Data.DataRow Dim a As OdbcCommandBuilder conn = New...
  8. S

    Access to mysql database from other computer(VB.net/Mysql)

    hi~~ can i ask u what the <your connection here> i should put? isi it below connection?? "DRIVER={MySQL ODBC 3.51 Driver};" & _ "SERVER=localhost;" & _ "DATABASE=seas;" & _ "UID=root;" & _ "PASSWORD=;"...
  9. S

    Access to mysql database from other computer(VB.net/Mysql)

    i think i make some mistake... what i want is not login to the whole mysql server for example i have a database name:SEAS inside has a table(Empdatail) in the table has two fields(ID, password) now in client side the user want to login to sys based on ID and password when user keyin ID,password...
  10. S

    how to save selected item from checkedlistbox to mysql?

    ________________ |O Lee | |O Dee | |O santi | |O xue | |O Gan | <checklistbox -------------------- Now i choose LEE, santi, xue and i click save in database timetable3 must add in the record Employee_ID Date...
  11. S

    how to save selected item from checkedlistbox to mysql?

    i'm doing a scheduling app there all two type of user(manager and employee) now the manager want hold a group meeting which include only part of employees so i need to do like the manager can choose the ppl who are need to attend the meeting so i use a checkedlistbox that get all the employee...
  12. S

    Access to mysql database from other computer(VB.net/Mysql)

    is it i just need to install it into client site???
  13. S

    how to save selected item from checkedlistbox to mysql?

    how about if i use this code?? but it still come out some error... seems is sql problem Dim myCommand As New OdbcCommand Dim myData As New DataSet Dim SQL As String Dim myAdapter As OdbcDataAdapter Dim conn As OdbcConnection Dim acc As Data.DataRow Dim a As OdbcCommandBuilder...
  14. S

    how to save selected item from checkedlistbox to mysql?

    can u check for me pls... is it correct? wat the forma actually put? before that i put in Empname but pop out some error "ERROR[42000][MySQL][ODBC 3.51 Driver][mysql-4.1.11-nt]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right...
  15. S

    Access to mysql database from other computer(VB.net/Mysql)

    thanks~~~ i will go for take a look!!! i got one ODBC.NET data provider is it the same?
  16. S

    Access to mysql database from other computer(VB.net/Mysql)

    hi~~ can u tell me how to connect?? use the code? thanks~~~
  17. S

    how to save selected item from checkedlistbox to mysql?

    above is the code i retrieve the data into checkedlistbox... than now incheckedlistbox got 8 name aaa bbb ccc ddd eee ffff ggg hhh i select 3 names inside(aaa,ccc,ggg) when i click save will save to a table name timetable example: ID Name Event 101 aaa group...
  18. S

    how to save selected item from checkedlistbox to mysql?

    This is the code that how i add item into checkedlistbox.... Dim myCommand As New OdbcCommand Dim myData As New DataTable Dim SQL As String Dim myAdapter As New OdbcDataAdapter Dim conn As OdbcConnection CheckedListBox1.Items.Clear() conn = New OdbcConnection...
  19. S

    how to save selected item from checkedlistbox to mysql?

    i'm doing a scheduling app now i want to choose only few ppl to attend a group meeting The name inside the checkedlistbox is retrieve from database based on how many user in database. now let say in checkedlistbox got ten user name but i only choose three user and when i click save.. i need to...
  20. S

    how to save selected item from checkedlistbox to mysql?

    Kulrom... i feels sorry that i'm quite no understand abt ur code... i'm new in VB.NET can u change it by using odbc?? sorry for waste ur time..
Back
Top