here is my code
protected void EMPLOYEERECORD_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName.Equals("ADD"))
{
DropDownList drpDepartment = (DropDownList)EMPLOYEERECORD.FooterRow.FindControl("drpDepartment");
DropDownList DropDownList1 = (DropDownList)EMPLOYEERECORD.FooterRow.FindControl("DropDownList1");
DropDownList drpCategory = (DropDownList)EMPLOYEERECORD.FooterRow.FindControl("drpCategory");
TextBox txtAddRemarks = (TextBox)EMPLOYEERECORD.FooterRow.FindControl("txtAddRemarks");
DropDownList drpStatus = (DropDownList)EMPLOYEERECORD.FooterRow.FindControl("drpStatus");
DatabaseModule.SQcon.Open();
string cmdstr = "insert into dbo.RecordEmployee (DATE_REPORTED, EMPLOYEE_NAME, DEPARTMENT, CATEGORY, REMARKS, TIME_IN, TIME_OUT, EMP_STATUS) values(@dReported, @empname,@department,@category,@remarks,@tIN, @tOUT, @status)";
SqlCommand cmd = new SqlCommand(cmdstr, DatabaseModule.SQcon);
cmd.Parameters.AddWithValue("@dReported", DateTime.Now.ToString());
cmd.Parameters.AddWithValue("@empname", DropDownList1.SelectedValue.ToString());
cmd.Parameters.AddWithValue("@department", drpDepartment.SelectedValue.ToString());
cmd.Parameters.AddWithValue("@category",drpCategory.SelectedValue.ToString());
cmd.Parameters.AddWithValue("@remarks", txtAddRemarks.Text);
cmd.Parameters.AddWithValue("@tIN", DateTime.Now.ToString());
cmd.Parameters.AddWithValue("@tOut", "");
cmd.Parameters.AddWithValue("@status", drpStatus.SelectedValue.ToString());
cmd.ExecuteNonQuery();
DatabaseModule.SQcon.Close();
BindData();
}
}
and here is my database table:
create table dbo.RecordEmployee (DATE_REPORTED datetime primary key, EMPLOYEE_NAME varchar(50) NOT NULL,
DEPARTMENT varchar(40) NOT NULL,
CATEGORY varchar(20)NOT NULL, REMARKS varchar(100), TIME_IN datetime NOT NULL,
TIME_OUT datetime, EMP_STATUS varchar (20) NOT NULL)
how ever I keep on getting an exception, help please