Error: [System.InvalidCastException: 'Specified cast is not valid.]
code:
private void SaveImportDataToDatabase(DataTable S2P5)
{
using (SqlConnection conn = new SqlConnection(@"Data Source=BBKUL035127\SQLEXPRESS; Initial Catalog=DB; User Id=sa; Password=1234"))
{
conn.Open();
foreach (DataRow importRow in S2P5.Rows)
{
SqlCommand cmd = new SqlCommand
("INSERT INTO S2P5 (DateTime,Miliseconds,MachineAutoStartStop,Pressure,Batch,UPCurrent,LPCurrent,LinearSensor,Load,SlidePosition,Step1,Step2,Step3,Step4,Step5,Step6,Step7,Step8,Step9,Step10,UPPlatePosition,LPPlatePosition,SunGearPosition,InternalGearPosition)" + "VALUES (@DateTime,@Miliseconds,@MachineAutoStartStop,@Pressure,@Batch,@UpCurrent,@LpCurrent,@LinearSensor,@Load,@SlidePosition,@Step1,@Step2,@Step3,@Step4,@Step5,@Step6,@Step7,@Step8,@Step9,@Step10,@UPPlatePosition,@LPPlatePosition,@SunGearPosition,@InternalGearPosition)", conn);
cmd.Parameters.AddWithValue("@DateTime", (DateTime)importRow["DateTime"]);
cmd.Parameters.AddWithValue("@Miliseconds", importRow["Miliseconds"]);
cmd.Parameters.AddWithValue("@MachineAutoStartStop", importRow["MachineAutoStartStop"]);
cmd.Parameters.AddWithValue("@Pressure", importRow["Pressure"]);
cmd.Parameters.AddWithValue("@Batch", importRow["Batch"]);
cmd.Parameters.AddWithValue("@UPCurrent", importRow["UPCurrent"]);
cmd.Parameters.AddWithValue("@LPCurrent", importRow["LPCurrent"]);
cmd.Parameters.AddWithValue("@LinearSensor", importRow["LinearSensor"]);
cmd.Parameters.AddWithValue("@Load", importRow["Load"]);
cmd.Parameters.AddWithValue("@SlidePosition", importRow["SlidePosition"]);
cmd.Parameters.AddWithValue("@Step1", importRow["Step1"]);
cmd.Parameters.AddWithValue("@Step2", importRow["Step2"]);
cmd.Parameters.AddWithValue("@Step3", importRow["Step3"]);
cmd.Parameters.AddWithValue("@Step4", importRow["Step4"]);
cmd.Parameters.AddWithValue("@Step5", importRow["Step5"]);
cmd.Parameters.AddWithValue("@Step6", importRow["Step6"]);
cmd.Parameters.AddWithValue("@Step7", importRow["Step7"]);
cmd.Parameters.AddWithValue("@Step8", importRow["Step8"]);
cmd.Parameters.AddWithValue("@Step9", importRow["Step9"]);
cmd.Parameters.AddWithValue("@Step10", importRow["Step10"]);
cmd.Parameters.AddWithValue("@UPPlatePosition", importRow["UPPlatePosition"]);
cmd.Parameters.AddWithValue("@LPPlatePosition", importRow["LPPlatePosition"]);
cmd.Parameters.AddWithValue("@SunGearPosition", importRow["SunGearPosition"]);
cmd.Parameters.AddWithValue("@InternalGearPosition", importRow["InternalGearPosition"]);
cmd.ExecuteNonQuery();
}
}