hai, i worte these code for storing data into mysql database, all data stored into database except date_ad.
Public Sub Save_button_Click() Dim InsertDb As String 'Dim Dx As Date 'Format(Dx, "dd/mm/yyyy") InsertDb = "INSERT INTO name_tbl (adm, name, place, date_ad) VALUES ('" & (TextBox1.Text) & "','" & (TextBox2.Text) & "', '" & (TextBox3.Text) & "', '" & DateBox1.Value & "' )" MODMain.MyConn.Exec(InsertDb) message("Data saved") clear1 pls help -- M. Unaise. E.K 9895687604 Librarian, (BLISc, MLIS) JDT Islam Polytechnic College, Vellimadukunnu. ------------------------------------------------------------------------------ Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot _______________________________________________ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user