change your sp as:
CREATE PROCEDURE [dbo].[client_billing_address_sp_update]
(
@in_type tinyint,
@vc_firstname_on_credit_card nvarchar(50) = ''
)
AS
declare @sql1 nvarchar(max)
IF(@in_type = 1)
BEGIN
set @sql1='insert into FCM_Claims(vc_firstname_on_credit_card) values(N'''+ @vc_firstname_on_credit_card + ''')';
END
exec(@sql1);
Try this function from your cs file
public Void InsertNonEnglish(string in_type,string vc_firstname_on_credit_card){
string ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["ConnectionString"].ToString();
SqlConnection con = null;
try
{
con = new SqlConnection(ConnectionString);
SqlCommand cmd = new SqlCommand("client_billing_address_sp_update", con);
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter[] prm=new SqlParameter[2];
cmd.Parameters.Add("@in_type ", SqlDbType.TinyInt).Value = in_type;
cmd.Parameters.Add("@vc_firstname_on_credit_card ", SqlDbType.NVarChar, 1024).Value = vc_firstname_on_credit_card;
con.Open();
cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (con != null)
{
con.Close();
con.Dispose();
}
}
}