No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
I'm updating my database using this code. only id and attendance date is updated but the time(AM_TIME_IN etc...) is not updating. What could be wrong? I'm using access and time(AM_TIME_IN etc...) datatype is shorttext Dim a As String = Now.ToShortTimeString If a.Contains("AM") Then a = "AM" Else a = "PM" … |
|
Re:
i now can save a fingerprint template from database using this code.. Dim fingerprintData As MemoryStream = New MemoryStream Template.Serialize(fingerprintData) fingerprintData.Position = 0 Dim br As BinaryReader = New BinaryReader(fingerprintData) Dim bytes() As Byte = br.ReadBytes(CType(fingerprintData.Length, Int32)) Dim cmd As SqlCommand = New SqlCommand("INSERT INTO fininger_table VALUES(@FIRSTNAME, @LASTNAME, @FINGERPRINT)", conn) … |
|
No ERRORS query is executed perfectly but no data stored what could be wrong? my database is employee with id, first_name, middle_name, last_name fields id is auto number the rest is short text I'm using ms access. Imports System.Data.OleDb Public Class AccountReg Dim dbProvider As String Dim dbSource As String … |
|
Im making a simple login form for my project and I faced this annoying database connection problem. The problem is I can't connect to "MSACCESS2013" it directs me to my errorhandler but I'm pretty sure my datasource is correct. I already created a datasource and I'm using its connection string. … |