HiPlease sorry to post this again. Am still finding problem inserting a label displayed time into the database.Am having this error with “ChkBoxLate = “LblTimeNow.Text””, that “cannot explicitly convert time string.
protected void BtnSubmit_Click(object sender, EventArgs e) { foreach (GridViewRow row in GridView1.Rows) { DateTime LblTimeNow = Convert.ToDateTime(LblTimeNow.ToString().Trim()); CheckBox ChkBoxLate = (CheckBox)row.FindControl("ChkBoxLate"); if (ChkBoxLate.Checked) { ChkBoxLate = "LblTimeNow.Text"; } else { ChkBoxLate = string.Empty; } }InsertAttendance(Late);
private void InsertAttendance(int regNo, string firstName, string lastName, string boxDay, DateTime boxDate, string hours, string status, string authorized) { SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["MyConnectionString"].ConnectionString); { using (SqlCommand cmd = new SqlCommand()) { cmd.CommandText = "INSERT INTO AttendanceTable VALUES (@Late)"; cmd.CommandType = CommandType.Text; cmd.Parameters.AddWithValue("@Late", late); conn.Open(); cmd.ExecuteNonQuery(); conn.Close(); } }