将多个记录从datagridview插入到使用VB.NET的数据库表中 [英] Insert multiple record from datagridview into my database table useing VB.NET

问题描述

我想从 datagridview 到插入到 mysql数据库表
但是我不知道如何将 datagridview 插入数据库表。
怎么办？ ：（

i want to insert records from datagridview to mysql database table , but i dont know how to insert datagridview to database table. How to do it? :(

推荐答案

这是jus我的建议，如果你有你的代码，然后可以更好地工作

This is jus my suggestion if you have you code then can work out more better

   Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
        ''create connection 
        Dim conn As SqlConnection = New SqlConnection()
        conn.Open()

        Dim comm As SqlCommand = New SqlCommand()
        comm.Connection = conn

        ''insert data to sql database row by row
        Dim name, ageAs String
        For i As Integer = 0 To Me.DataGridView1.Rows.Count
            name = Me.DataGridView1.Rows(i).Cells(0).ToString()
            age= Me.DataGridView1.Rows(i).Cells(1).ToString()

            comm.CommandText = "insert into mytable(name,age) values('" & name & "','" & age& "')"
            comm.ExecuteNonQuery()
        Next

        conn.Close()

    End Sub

这只是一种方法插入它最好是使用存储过程插入值，因为如果使用SQL，可能会发生SQL注入。所以存储过程是最好的方法并保存使用。

This is just a way to insert it is best it you use stored procedure to insert the value because if you use SQL it might happen SQL Injection. So stored procedure is the best way and save to use.

这篇关于将多个记录从datagridview插入到使用VB.NET的数据库表中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！