Dear All,
I got error
Failed to convert parameter value from a String to a Int32.
this code is export Excel data to SqlServer. How to resolve the error.
Thank in advance.
public void insertdataintosql(string ye_cm_id, string ye_fy_id, string ye_month, string ye_year, string ye_basic, string ye_hra, string ye_cea, string ye_pa, string ye_spl_allow, string ye_other_allow, string ye_pda, string ye_cadre, string ye_medical, string ye_os_allow, string ye_attire_allow)
{
SqlConnection conn = new SqlConnection("Data Source=SUBRAMANYAM\\SQLEXPRESS;Initial Catalog=Incometax;Integrated Security=true;");
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandText = "insert into yearly_earnings(ye_cm_id,ye_fy_id,ye_month,ye_year,ye_basic,ye_hra,ye_cea,ye_pa, ye_spl_allow,ye_other_allow,ye_pda,ye_cadre,ye_medical,ye_os_allow,ye_attire_allow) values (@ye_cm_id,@ye_fy_id,@ye_month,@ye_year,@ye_basic,@ye_hra,@ye_cea,@ye_pa, @ye_spl_allow,@ye_other_allow,@ye_pda,@ye_cadre,@ye_medical,@ye_os_allow,@ye_attire_allow)";
cmd.Parameters.Add("@ye_cm_id", SqlDbType.Int).Value = ye_cm_id;
cmd.Parameters.Add("@ye_fy_id", SqlDbType.Int).Value = ye_fy_id;
cmd.Parameters.Add("@ye_month", SqlDbType.Int).Value = ye_month;
cmd.Parameters.Add("@ye_basic", SqlDbType.Int).Value = ye_basic;
cmd.Parameters.Add("@ye_year", SqlDbType.Int).Value = ye_year;
cmd.Parameters.Add("@ye_hra", SqlDbType.Int).Value = ye_hra;
cmd.Parameters.Add("@ye_cea", SqlDbType.Int).Value = ye_cea;
cmd.Parameters.Add("@ye_pa", SqlDbType.Int).Value = ye_pa;
cmd.Parameters.Add("@ye_spl_allow", SqlDbType.Int).Value = ye_spl_allow;
cmd.Parameters.Add("@ye_other_allow", SqlDbType.Int).Value = ye_other_allow;
cmd.Parameters.Add("@ye_pda", SqlDbType.Int).Value = ye_pda;
cmd.Parameters.Add("@ye_cadre", SqlDbType.Int).Value = ye_cadre;
cmd.Parameters.Add("@ye_medical", SqlDbType.Int).Value = ye_medical;
cmd.Parameters.Add("@ye_os_allow", SqlDbType.Int).Value = ye_os_allow;
cmd.Parameters.Add("@ye_attire_allow", SqlDbType.Int).Value = ye_attire_allow;
cmd.CommandType = CommandType.Text;
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
}