c# - multiple attendance by face detection -
I have to add more than one presence to the database using face recognition.
I tried a lot but was still not able to do this because my single presence is added to a single cell, but I have to add every presence to each cell.
Can anyone help me by using the loop?
{conn.open (); SqlCommand cmd = New SqlCommand ("InsertAttendance", conn); Cmd.CommandType = CommandType.StoredProcedure; Cmd.Parameters.Add ("@AddressId", SqlDbType.BigInt). Valu = textAttendanceID.Text; Cmd.Parameters.Add ("Student Roll", SqlDbType.VarChar) .Value = textname.Text; Cmd.Parameters.Add ("Date", SqlDbType.DateTime). Value = DateTime Picture 1 value; Cmd.Parameters.Add ("Status", SqlDbType.VarChar) .Value = textStatus.Text; Cmd.ExecuteNonQuery (); Cmd.Dispose (); Conn.Close (); MessageBox.Show ("The presence was successfully inserted ..."); }
You need to review. This article is shown in easy mode to pass data tables to SQL Server and insert data in bulk.
Comments
Post a Comment