所有海，

这是我写的数据访问表数据不匹配错误已在运行中发生的代码。

任何一个plzzzzzzzzz帮助我..........................

cmdInsert.CommandText = "INSERT INTO SMSDATA1DB (Start_Of_Packet, Packet_Identifier,Soft_Version,Site_ID,Date_Time,Alarm_String,Solar_Voltage,Solar_Current,Solar_Avg_PF,Solar_Inst_Energy,Solar_Cum_Energy,Load_Voltage,Load_Current,Load_Avg_PF,Load_Inst_Energy,Load_Cumm_Energy,Grid_Voltage,Grid_Current,Grid_Inst_Energy,Grid_Cum_Energy,Batt_Voltage,Batt_Charg_Current,Batt_Charg_Energy,Batt_Disch_Current,Batt_Disch_Energy,Status_String,End_Of_String) VALUES ('" & STX1 & "', '" & STX2 & "', '" & STX3 & "', '" & STX4 & "', '" & STX5 & "' , '" & result1 & "', '" & STX7 & "', '" & STX8 & "', '" & STX9 & "', '" & STX25 & "', '" & STX10 & "', '" & STX11 & "', '" & STX12 & "', '" & STX13 & "', '" & STX26 & "', '" & STX14 & "', '" & STX15 & "', '" & STX16 & "', '" & STX27 & "', '" & STX17 & "', '" & STX18 & "', '" & STX19 & "', '" & STX20 & "', '" & STX21 & "', '" & STX22 & "', '" & result2 & "', '" & STX24 & "')"

            MsgBox(cmdInsert.CommandText)

            cmdInsert.CommandType = CommandType.Text

            cmdInsert.Connection = cnnOLEDB

            cmdInsert.ExecuteNonQuery()

            cmdInsert.Dispose()

DATE_TIME DateTime函数被该值存储在STX5字符串| Himachandra | OriginalGriff