DataGridView的增加,修改,删除命令指定SQL语句

 '保存数据
    Private Sub Save()
        Try
            If MsgBox("确定要保存所修改的数据吗？", MsgBoxStyle.Question Or MsgBoxStyle.DefaultButton2 Or MsgBoxStyle.YesNo, "系统提示") = MsgBoxResult.Yes Then
                GridView.Rows(0).Cells("spbm").Selected = True
                Dim gCummand As New SqlClient.SqlCommandBuilder(gDataAdapter)
                With gDataAdapter
                    Dim parameterU As SqlClient.SqlParameter
                    '重新指定修改的SQL命令
                    .UpdateCommand = New SqlClient.SqlCommand("P_SetSJCXinfo", eCMyData.CreateConnection())
                    .UpdateCommand.CommandType = CommandType.StoredProcedure
                    parameterU = .UpdateCommand.Parameters.Add("@v_type", SqlDbType.Char, 2)
                    parameterU.Value = "20"
                    parameterU = .UpdateCommand.Parameters.Add("@v_sjbh", SqlDbType.Char, 10)