作者:隔壁小王 | 来源:互联网 | 2018-07-11 07:03
VB.NET中使用LinqTOSQL添加数据后获得自增长列IDVB.NET中使用LinqTOSQL添加数据后获得自增长列ID:DimtempOrdreAsNewOrderWith{.CustomerIDcmbCustomerName.SelectedValue.ToString,.ProductIDcmbProductSpec.SelectedValue.ToString,.Pro
VB.NET中使用Linq TO SQL添加数据后获得自增长列ID VB.NET中使用Linq TO SQL添加数据后获得自增长列ID: Dim tempOrdre As New Order With {.CustomerID = cmbCustomerName.SelectedValue.ToString,.ProductID = cmbProductSpec.SelectedValue.ToString,.Pro
VB.NET中使用Linq TO SQL添加数据后获得自增长列ID
VB.NET中使用Linq TO SQL添加数据后获得自增长列ID:
Dim tempOrdre As New Order With {
.CustomerID = cmbCustomerName.SelectedValue.ToString,
.ProductID = cmbProductSpec.SelectedValue.ToString,
.ProductNumber = txtProductNumber.Text.Trim,
.BatchNO = txtBatchNO.Text.Trim,
.OrderDate = dtpOrderDate.Value.ToShortDateString
}
db.Order.InsertOnSubmit(tempOrdre)
Try
db.SubmitChanges() ’提交数据库操作
Dim intid As Integer = tempOrdre.OrderID ‘获得自增长列ID
MessageBox.Show(intid) ’显示ID
Catch ex As Exception
Throw New System.Exception(ex.Message, ex.InnerException)
End Try
posted on
,美国服务器,香港服务器,香港虚拟主机