SqlConnection con = new SqlConnection(connectionstring);
SqlCommand cmd = new SqlCommand("proAdd", con);
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter sqlparam = null;
sqlparam = cmd.Parameters.Add("@EmpName", SqlDbType.VarChar, 50);
sqlparam.Value = txtname.Text.ToString();
sqlparam = cmd.Parameters.Add("@Address", SqlDbType.VarChar, 50);
sqlparam.Value = txtaddress.Text.ToString();
sqlparam = cmd.Parameters.Add("@BasicPay", SqlDbType.Money);
sqlparam.Value = decimal.Parse(txtaddress.Text);
sqlparam = cmd.Parameters.Add("@PF", SqlDbType.Money);
sqlparam.Value =decimal.Parse(txtpf.Text);
sqlparam = cmd.Parameters.Add("@HRA", SqlDbType.Money);
sqlparam.Value =decimal.Parse(txthra.Text);
sqlparam = cmd.Parameters.Add("@TotalSalary", SqlDbType.Money);
sqlparam.Value =decimal.Parse(txtts.Text);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
I am having problems in input strings for Datatype Money.....can some one help me out plz..........