16,553
社区成员
发帖
与我相关
我的任务
分享
dim strFilePath As String = AppDomain.CurrentDomain.SetupInformation.ApplicationBase 'strFilePath
dim myCon As New OleDbConnection("Provider=Microsoft.Jet.Oledb.4.0; Jet OLEDB:Database Password=sa123 ;Data Source=" & strFilePath & "DataBase\Common.mdb")
Dim mySQL As String
mySQL = "SELECT BarCodeItem AS Item条码,BarCodeCTN AS CTN条码, Destination AS 发往地 ,DistributeLine AS 分发线,Curdate as 分发日期 FROM ProductStock" & _
" WHERE CurDate>= '" & Format(DateTimePicker1.Value, "yyyy-MM-dd") & " 00:00:00' AND CurDate <= '" & Format(DateTimePicker2.Value, "yyyy-MM-dd") & "23:59:59'"
'DataAdapter执行SQL语句
Dim adapter As New OleDbDataAdapter(mySQL, myCon)
Dim dt As New DataTable("ProductStock")
adapter.Fill(dt)
dgv_DataQuery.DataSource = dt
'For i As Integer = 0 To dgv_DataQuery.ColumnCount - 1
' 'DGV1.Columns(6).Width = 300
'Next
Dim cmd As New OleDbCommand(mySQL, myCon)
myCon.Open()
Dim myreader As OleDbDataReader = cmd.ExecuteReader
myreader.Read()
myCon.Close()
If dgv_DataQuery.RowCount < 2 Then
MessageBox.Show("无查询记录", "提示")
End If
Dim mySQL As String
mySQL = "SELECT SN AS 型号,StartTime AS 开始时间,EndTime as 结束时间,IsOK AS 状态" & _
" FROM tb_Data_ChaXiaoU" & _
" WHERE StartTime>= '" & Format(DateTimePicker1.Value, "yyyy-MM-dd") & " 00:00:00.000' AND EndTime <= '" & Format(DateTimePicker2.Value, "yyyy-MM-dd") & " 23:59:59.000 '"
'DataAdapter执行SQL语句
Dim adapter As New SqlClient.SqlDataAdapter(mySQL, myCon)
Dim dt As New DataTable("myQuery")
adapter.Fill(dt)
dgv_DataQuery.DataSource = dt
修改
'往 数据库里写入数据
Dim mySQLstr As String
mySQLstr = "UPDATE tb_Data_ChaXiaoU_Model SET SAP= @_SAP, UCount=@_UCount WHERE Model=@_Model"
Dim cmd1 As New SqlClient.SqlCommand(mySQLstr, myCon)
cmd1.Parameters.Add(New SqlClient.SqlParameter("@_Model", txt_Model.Text))
cmd1.Parameters.Add(New SqlClient.SqlParameter("@_SAP", txt_SAP.Text))
cmd1.Parameters.Add(New SqlClient.SqlParameter("@_UCount", Val(txt_UCount.Text)))
Try
myCon.Open()
cmd1.ExecuteNonQuery()
myCon.Close()
Catch ex As Exception
myCon.Close()
End Try