I know this is simple, but for some reason... this isnt working for me
Im just simply trying to take my whole dataset and put it into my premade mysql tables.
Code:Dim sqlConn As New MySqlConnection("server=192.168.0.109;User Id=****;password=****;database=taxcert") Dim taxDS As New DataSet("Tax") Dim commands As MySqlCommandBuilder Private Sub btnStartInput_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnStartInput.Click Call inputorders() End Sub Public Sub inputorders() Dim ordersadapt As New MySqlDataAdapter("SELECT * FROM Orders", sqlConn) ordersadapt.InsertCommand = New MySqlCommand("INSERT INTO Orders (*) VALUES *", sqlConn) ordersadapt.Update(taxDS, "Orders") End Sub




Reply With Quote