当前位置: 网站首页 > 开发语言 > VB

一对多关联的数据库在VB.NET中如何新增记录

时间:1970-1-1 08:33:31来源: VB作者:admin 点击:1次 字体 [ С]

    Dim drOrders As DataRow
    Dim drOrderDetails As DataRow
    Dim iSubTotal As Integer
    Try
    If OrderDetailsHasChange Then
    OrderDetailsHasChange = False
    drOrders = dsTestOrders.Tables("Orders").Rows(BmOrders.Position)
    iSubTotal = 0
    For Each drOrderDetails In drOrders.GetChildRows("OrdersOrderDetails")


    iSubTotal = iSubTotal + drOrderDetails("price")
    Next
    drOrders.BeginEdit()
    drOrders("SubTotal") = iSubTotal
    drOrders.EndEdit()
    End If
    Finally
    OrderDetailsHasChange = True
    End Try
    End Sub







    Private Sub bndelete_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles bndelete.Click
    If BmOrders.Count > 0 Then
    BmOrders.RemoveAt(BmOrders.Position)
    End If


    End Sub

    Private Sub bncancel_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles bncancel.Click
    BmOrders.CancelCurrentEdit()

    End Sub
    End C

发表评论
验证码:
最新评论
相关文章
最热文章