在asp.net中插入数据表到mysql数据库中

Question

有没有办法在asp.net中将动态生成的数据表插入到mysql数据库中？

Answer 1

Sub OutputQty(ByVal dt As DataTable, ByVal AdID As Integer)
    Dim sql As String = ""
    Dim con As New SqlConnection(Utilities.DELcon)
    Dim cmd As New SqlCommand(sql, con)
    con.Open()
    For Each row In dt.Rows
        sql = "INSERT INTO DMQtyOutput (AdID, CompanyID, StoreNumber, DemandQty) VALUES ('" & row("AdID") & "','" & row("CompanyID") & "','" & row("StoreNumber") & "','" & row("DemandQty") & "')"
        cmd.CommandText = sql
        cmd.ExecuteNonQuery()
    Next
    con.Close()
End Sub