請教：VB.NET表單向access資料庫寫入1條資料后，對應日期欄位內容如何在 上一條記錄時間自動加5分鐘，謝謝，如下代碼要怎么修改，感謝。
Imports System.Data.OleDb
Public Class Form1
Dim cn As OleDbConnection
Dim da As OleDbDataAdapter
Dim ds As DataSet
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim str As String = "Provider=Microsoft.ace.OLEDB.12.0;Data Source=C:\Users\Administrator\Desktop\vb.net\aceess資料庫\資訊表2020.accdb;Persist Security Info=False"
Dim conn As OleDbConnection
conn = New OleDbConnection(str)
conn.Open()
Dim strInsert As String
strInsert = "insert into 資訊表 ( 條形碼,錄入時間) values ('" & TextBox1.Text & "', '" & DateTimePicker1.Text & "')"
Dim cmdInsert As OleDbCommand = New OleDbCommand(strInsert, conn)
cmdInsert.ExecuteNonQuery()
MsgBox("添加成功")
strInsert = "select * from 資訊表"
Dim cmdView As New OleDbCommand(strInsert, conn)
cmdView.ExecuteNonQuery()
Dim da As New OleDbDataAdapter
da = New OleDbDataAdapter(strInsert, conn)
Dim ds As New DataSet
da.Fill(ds)
DataGridView1.DataSource = ds.Tables(0)
End Sub
End Class
uj5u.com熱心網友回復：
為何要加上時間？那樣就要多出讀取的處理，直接寫入寫的時間就好了。uj5u.com熱心網友回復：
1.dateadd函式，VS.Net和SQL都支持，語法略微有點區別2.datetime型變數.addMinutes(5)
轉載請註明出處，本文鏈接：https://www.uj5u.com/net/32846.html
標籤：VB.NET