How to convert varchar to decimal in insert statement using c#.net

See more:

C#

C#4.0

Hi frinds , i have requirement,

if (dsAttendance.Tables[0].Rows.Count > 0)
           {
               foreach (DataRow  DR in dsAttendance.Tables[0].Rows )
               {

                   string filter = string.Format("SNO=" + DR["SNO"] + " AND EMPID= '" + DR["EMPID"] + "' AND  SHIFT='" + DR["SHIFT"] + "' AND  INTIME='" + DR["INTIME"] + "'AND  OUTTIME='" + DR["OUTTIME"] + "' ");

                            DataRow[] R = dsAttendance1.Tables[0].Select(filter);

                            if (R.Length == 0)
                            {

                                con1.Open();
                                cmdAttendance = new SqlCommand("INSERT INTO ATTENDANCE(EMPID,SHIFT,INTIME,OUTTIME,PRODUCTIONTIME,EXTRATIME,NONPRODUCTIVETIME,TRAININGTIME,QUALITYTIME,PROJECTMGMTTIME,VERIFICATIONTIME,UNKNOWNTIME,REWORKTIME,PROJECTLEAD,STATUS,REMARKS,REASONS,SS_REMARKS,NEW_EMPID,SYSTEM_NAME,SYSTEM_NAME_OUT)VALUES('" + DR["EMPID"] + "', '" + DR["SHIFT"] + "','" + DR["INTIME"] + "', '" + DR["OUTTIME"] + "', '" +   DR ["PRODUCTIONTIME"]+ "', '" +DR["EXTRATIME"] + "','" + DR["NONPRODUCTIVETIME"] + "', '" + DR["TRAININGTIME"] + "',  '" + DR["QUALITYTIME"] + "', '" + DR["PROJECTMGMTTIME"] + "','" + DR["VERIFICATIONTIME"] + "', '" + DR["UNKNOWNTIME"] + "',   '" + DR["REWORKTIME"] + "', '" + DR["PROJECTLEAD"] + "','" + DR["STATUS"] + "', '" + DR["REMARKS"] + "' ,'" + DR["REASONS"] + "','" + DR["SS_REMARKS"] + "', '" + DR["NEW_EMPID"] + "' ,'" + DR["SYSTEM_NAME"] + "', '" + DR["SYSTEM_NAME_OUT"] + "')", con1);
                                cmdAttendance.ExecuteNonQuery();

                                string inserted = "inserted";

                                DateTime dt = DateTime.Now;
                                SqlCommand cmd = new SqlCommand("INSERT INTO ATTENDANCE_Rpt(EMPID,SHIFT,INTIME,OUTTIME,PRODUCTIONTIME,EXTRATIME,NONPRODUCTIVETIME,TRAININGTIME,QUALITYTIME,PROJECTMGMTTIME,VERIFICATIONTIME,UNKNOWNTIME,REWORKTIME,PROJECTLEAD,STATUS,REMARKS,REASONS,SS_REMARKS,NEW_EMPID,SYSTEM_NAME,SYSTEM_NAME_OUT,INS_UPD_STATUS,LASTUPDATEDDATE) VALUES('" + DR["EMPID"] + "', '" + DR["SHIFT"] + "','" + DR["INTIME"] + "', '" + DR["OUTTIME"] + "',   '" + DR["PRODUCTIONTIME"] + "', '" + DR["EXTRATIME"] + "','" + DR["NONPRODUCTIVETIME"] + "', '" + DR["TRAININGTIME"] + "', '" + DR["QUALITYTIME"] + "', '" + DR["PROJECTMGMTTIME"] + "','" + DR["VERIFICATIONTIME"] + "', '" + DR["UNKNOWNTIME"] + "',   '" + DR["REWORKTIME"] + "', '" + DR["PROJECTLEAD"] + "','" + DR["STATUS"] + "', '" + DR["REMARKS"] + "'    ,   '" + DR["REASONS"] + "','" + DR["SS_REMARKS"] + "', '" + DR["NEW_EMPID"] + "' ,'" + DR["SYSTEM_NAME"] + "', '" + DR["SYSTEM_NAME_OUT"] + "','" + inserted + "','" + dt + "') ", con1);
                                cmd.ExecuteNonQuery();

                                con1.Close();

                                flag = 0;

                            }

               }

           }

in that query, some fields are null or empty .

I got the error is Varchar to Decimal