在vb.net中使用存储过程将datagridview数据插入数据库

CREATE PROCEDURE InsertData
    @Param1 VARCHAR(50),
    @Param2 VARCHAR(50),
    -- 添加其他参数，以适应你的需求
AS
BEGIN
    INSERT INTO YourTable (Column1, Column2)
    VALUES (@Param1, @Param2)
END

Dim connectionString As String = "Data Source=YourServer;Initial Catalog=YourDatabase;User ID=YourUsername;Password=YourPassword"
Dim connection As New SqlConnection(connectionString)

Dim command As New SqlCommand("InsertData", connection)
command.CommandType = CommandType.StoredProcedure

' 添加存储过程的参数
command.Parameters.AddWithValue("@Param1", dataGridView1.Rows(0).Cells(0).Value.ToString())
command.Parameters.AddWithValue("@Param2", dataGridView1.Rows(0).Cells(1).Value.ToString())
' 添加其他参数，以适应你的需求

' 打开数据库连接并执行存储过程
connection.Open()
command.ExecuteNonQuery()
connection.Close()