将所有datagridview行保存到表中 [英] Save all datagridview rows to table

问题描述

此代码有什么问题.我试图遍历所有datagridview行并将所有行保存到表中.

What is wrong with this code. I am trying to loop through all datagridview rows and save all rows to table.

Dim con As New SqlConnection
        Dim cmd As New SqlCommand
        Dim val1 = TextBox1.Text
        Dim val2 = TextBox2.Text
        con.ConnectionString = "Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Database1.mdf;Integrated Security=True;User Instance=True"
        con.Open()
        cmd.Connection = con

        For i As Integer = 0 To Me.DataGridView1.Rows.Count - 1
            cmd.CommandText = "Insert into table2(aa,bb) Values(@firstname,@lastname)"
            cmd.Parameters.AddWithValue("@firstname", DataGridView1.Rows(i).Cells(0).Value)
            cmd.Parameters.AddWithValue("@lastname", DataGridView1.Rows(i).Cells(1).Value)
            cmd.ExecuteNonQuery()
        Next

推荐答案

尝试此代码，它将对您有用

try this code it will work for you I guess

Dim con As New SqlConnection
        
        Dim val1 = TextBox1.Text
        Dim val2 = TextBox2.Text
        con.ConnectionString = "Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Database1.mdf;Integrated Security=True;User Instance=True"
        con.Open()
        

        For i As Integer = 0 To Me.DataGridView1.Rows.Count - 1
          Dim cmd As New SqlCommand()
cmd.Connection = con
            cmd.CommandText = "Insert into table2(aa,bb) Values(@firstname,@lastname)"
            cmd.Parameters.AddWithValue("@firstname", DataGridView1.Rows(i).Cells(0).Value)
            cmd.Parameters.AddWithValue("@lastname", DataGridView1.Rows(i).Cells(1).Value)
            cmd.ExecuteNonQuery()
        Next

希望这会有所帮助....

祝你好运..........

Hope this helps....

Best of Luck.............

这篇关于将所有datagridview行保存到表中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！