Insert a Datatable into mysql database in asp.net

Question

Is there a way to insert a dynamically generated datatable into mysql database in asp.net?

takrl · Accepted Answer · 2011-07-04 14:52:07Z

2

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

edited Jul 4, 2011 at 14:52

takrl

6,5003 gold badges63 silver badges71 bronze badges

answered Sep 23, 2009 at 15:09

user177867

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Insert a Datatable into mysql database in asp.net

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related