C# e SQL....
Boa Tarde....
Eu tenho um código em SQL e c#, eu ja fiz varais modificações, converti para string , decimal mnas o erro que esta dando é de:[
Syntaxe incorreta próximo a '30'.
Segue o código...
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;
using System.IO;
namespace SistemaFolhaPGTOI
{
public partial class recibo_Ferias : Form
{
public recibo_Ferias()
{
InitializeComponent();
}
private void recibo_Ferias_Load(object sender, EventArgs e)
{
}
private void btnadd_Click(object sender, EventArgs e)
{
SqlConnection conn = new SqlConnection();
conn.ConnectionString = "Data Source=CASA-EC2BFA02C9\\SQLEXPRESS;Initial Catalog=Folha; Integrated Security = true;";
SqlCommand cmd = new SqlCommand("INSERT INTO tblRecfer VALUES (@Nom_Empregado, @No_CTPS, @No_Serie, @Ficha_no, @Livro_No, @Folha_No, @Funcao, @Des, @Dess, @Ass, @Desss, @Dessss, @Asss, @Desssss, @Dessssss, @Asssss, @Desssssss, @DEww, @Dewww, @Faltas_Nao_Justificadas, @Salario_Base, @Data_Admissao, @Renumeracao_Base_Ferias, @Dia_Mes, @Dia_Gozo, @Ferias_RS, @um_terco_ferias, @um_terco_ferias_RS, @Ferias_RS_2, @Dias_Mes_2, @Dias_Gozo_2, @Abono_Ferias_RS, @um_terco, @um_terco_sem_Abono, @Base_Calculo_RS, @Aliquota_INSS, @Vr_Descont_RS, @Qtd_Dep, @Qtd_Dep_RS, @Dep_RS, @Dependentes_RS, @Aiquota_IRRF, @Parc_Deduzir, @Imposto_Deduzir, @Liquido_Receber, @Liquido_Receber_RS, @Liquido_Estenso, @Firma, @CNPJ_CEI_CPF, @Estabelecida, @Em, @Importancia_RS, @Importancia_Estenso) ", conn);
cmd.CommandText = (cmd.CommandText + "'" + this.txtnemp.Text + "',");
cmd.CommandText = (cmd.CommandText + this.mknctps.Text + ',');
cmd.CommandText = (cmd.CommandText + "'" + this.mknserie.Text + ",");
cmd.CommandText = (cmd.CommandText + "'" + this.txtfhn.Text + "',");
cmd.CommandText = (cmd.CommandText + "'" + this.txtlvn.Text + ",");
cmd.CommandText = (cmd.CommandText + "'" + this.txtfuncao.Text + ",");
cmd.CommandText = (cmd.CommandText + "'" + this.textBox1.Text + "',");
cmd.CommandText = (cmd.CommandText + "'" + this.textBox2.Text + ",");
cmd.CommandText = (cmd.CommandText + "'" + this.textBox3.Text + ",");
cmd.CommandText = (cmd.CommandText + "'" + this.textBox4.Text + "',");
cmd.CommandText = (cmd.CommandText + "'" + this.textBox5.Text + ",");
cmd.CommandText = (cmd.CommandText + "'" + this.textBox6.Text + ",");
cmd.CommandText = (cmd.CommandText + "'" + this.textBox7.Text + ",");
cmd.CommandText = (cmd.CommandText + "'" + this.textBox8.Text + "',");
cmd.CommandText = (cmd.CommandText + "'" + this.textBox9.Text + "',");
cmd.CommandText = (cmd.CommandText + "'" + this.textBox10.Text + "',");
cmd.CommandText = (cmd.CommandText + "'" + this.textBox11.Text + "',");
cmd.CommandText = (cmd.CommandText + "'" + this.textBox12.Text + "',");
cmd.CommandText = (cmd.CommandText + "'" + this.txtflnjsut.Text + "',");
cmd.CommandText = (cmd.CommandText + "'" + this.txtfuncao.Text + "',");
cmd.CommandText = (cmd.CommandText + this.nbsalbs.Text + ',');
cmd.CommandText = ("#\'" + this.dateTimePicker1.Value.Date + "#)");
cmd.CommandText = (cmd.CommandText + this.nbrenbsfr.Text + ',');
cmd.CommandText = (cmd.CommandText + "'" + this.txtDiaMes.Text + "',");
cmd.CommandText = (cmd.CommandText + "'" + this.txtDiasGozo.Text + "',");
cmd.CommandText = (cmd.CommandText + this.nbferiasRS.Text + ',');
cmd.CommandText = (cmd.CommandText + "'" + this.txtferiasRS.Text + "',");
cmd.CommandText = (cmd.CommandText + this.nbferiasTotal.Text + ',');
cmd.CommandText = (cmd.CommandText + this.nbferRS.Text + ',');
cmd.CommandText = (cmd.CommandText + "'" + this.txtDiasMes2.Text + "',");
cmd.CommandText = (cmd.CommandText + "'" + this.txtDiasGozo2.Text + "',");
cmd.CommandText = (cmd.CommandText + this.nbabferiasRS.Text + ',');
cmd.CommandText = (cmd.CommandText + this.nbbasecalcRS.Text + ',');
cmd.CommandText = (cmd.CommandText + "'" + this.txtAliqINSS.Text + "',");
cmd.CommandText = (cmd.CommandText + this.nbinss.Text + ',');
cmd.CommandText = (cmd.CommandText + "'" + this.txtdep.Text + "',");
cmd.CommandText = (cmd.CommandText + this.nbdepRS.Text + ',');
cmd.CommandText = (cmd.CommandText + "'" + this.nbdep.Text + ',');
cmd.CommandText = (cmd.CommandText + "'" + this.txtaliquotairrf.Text + "',");
cmd.CommandText = (cmd.CommandText + this.nbparcded.Text + ',');
cmd.CommandText = (cmd.CommandText + this.nbimpostoRS.Text + ',');
cmd.CommandText = (cmd.CommandText + this.nbliquidrec.Text + ',');
cmd.CommandText = (cmd.CommandText + this.nbliquida.Text + ',');
cmd.CommandText = (cmd.CommandText + "'" + this.txtestenso.Text + "',");
cmd.CommandText = (cmd.CommandText + "'" + this.txtfirma.Text + "',");
cmd.CommandText = (cmd.CommandText + "'" + this.txtdivrs.Text + "',");
cmd.CommandText = (cmd.CommandText + "'" + this.txtestabe.Text + "',");
cmd.CommandText = (cmd.CommandText + "'" + this.txtem.Text + "'");
cmd.CommandText = (cmd.CommandText + this.nbimp.Text + ',');
cmd.CommandText = (cmd.CommandText + "'" + this.txtimpo.Text + "')");
try
{
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
MessageBox.Show("Inserido com Sucesso!");
}
catch (SqlException erro)
{
MessageBox.Show("Erro em seu SQL " + erro);
}
}
private void btnclean_Click(object sender, EventArgs e)
{
}
private void btnCalc_Click_1(object sender, EventArgs e)
{
Decimal Div1;//nbsalbs
Decimal Mult1;//txtDiasMes
Decimal Mult2;//txtDiasGozo
Decimal result;//nbferiasRS
Decimal.TryParse(nbsalbs.Text, out Div1);
Decimal.TryParse(txtDiaMes.Text, out Mult1);
Decimal.TryParse(txtDiasGozo.Text, out Mult2);
result = Div1 / Mult1 * Mult2;
nbferiasRS.Text = Decimal.Round(result, 2).ToString();
}
private void button1_Click(object sender, EventArgs e)
{
Decimal Div2;//nbferiasRS
Decimal Div3;//txtferiasTotal
Decimal result;//nbfetiasTotal
Decimal.TryParse(nbferiasRS.Text, out Div2);
Decimal.TryParse(txtferiasRS.Text, out Div3);
result = Div2 / Div3;
nbferiasTotal.Text = Decimal.Round(result, 2).ToString();
}
private void groupBox3_Enter(object sender, EventArgs e)
{
}
private void btnCalc3_Click(object sender, EventArgs e)
{
Decimal Div4;//nbsalbs
Decimal Mult3;//txtDiasMes2
Decimal Mult4;//txtDiasGozo2
Decimal result;//nbabferiasRS
Decimal.TryParse(nbsalbs.Text, out Div4);
Decimal.TryParse(txtDiasMes2.Text, out Mult3);
Decimal.TryParse(txtDiasGozo2.Text, out Mult4);
result = Div4 / Mult3 * Mult4;
nbabferiasRS.Text = Decimal.Round(result, 2).ToString();
}
private void btnCacl4_Click(object sender, EventArgs e)
{
Decimal Div5;//nbabferiasRS
Decimal Div6;//txtumterco
Decimal result;//nbferiasTotalRS
Decimal.TryParse(nbabferiasRS.Text, out Div5);
Decimal.TryParse(txtumterco.Text, out Div6);
result = Div5 / Div6;
nbferiasTotalRS.Text = Decimal.Round(result, 2).ToString();
}
private void button2_Click(object sender, EventArgs e)
{
Decimal sum1;//nbferiasRS
Decimal sum2;//nbferiasTotal
Decimal sum3;//nbferiasTotal
Decimal sum4;//nbferRS
Decimal result;//nbbasecalcRS
Decimal.TryParse(nbferiasRS.Text, out sum1);
Decimal.TryParse(nbferiasTotal.Text, out sum2);
Decimal.TryParse(nbabferiasRS.Text, out sum3);
Decimal.TryParse(nbferiasTotalRS.Text, out sum4);
result = sum1 + sum2 + sum3 + sum4;
nbbasecalcRS.Text = Decimal.Round(result, 2).ToString();
}
private void btnaCalc5_Click(object sender, EventArgs e)
{
Decimal Mult5;//nbbasecalcRS
Decimal Mult6;//txtAliqINSS
Decimal Porcento = 100;
Decimal result;//nbVrDesc
Decimal.TryParse(nbsalbs.Text, out Mult5);
Decimal.TryParse(txtAliqINSS.Text, out Mult6);
result = Mult5 * Mult6 / Porcento;
nbinss.Text = Decimal.Round(result, 2).ToString();
}
private void numericBox1_Load(object sender, EventArgs e)
{
}
private void button8_Click(object sender, EventArgs e)
{
}
private void nbferRS_Load(object sender, EventArgs e)
{
}
private void txtDiasMes2_TextChanged(object sender, EventArgs e)
{
Decimal a = Convert.ToDecimal(txtDiasMes2.Text);
}
private void txtDiasGozo2_TextChanged(object sender, EventArgs e)
{
Decimal a = Convert.ToDecimal(txtDiasGozo2.Text);
}
private void nbabferiasRS_Load(object sender, EventArgs e)
{
}
private void radioButton2_CheckedChanged(object sender, EventArgs e)
{
s.Visible = false;
}
private void radioButton1_CheckedChanged(object sender, EventArgs e)
{
s.Visible = true;
}
private void label54_Click(object sender, EventArgs e)
{
}
private void radioButton4_CheckedChanged(object sender, EventArgs e)
{
groupBox5.Visible = true;
}
private void radioButton3_CheckedChanged(object sender, EventArgs e)
{
groupBox5.Visible = false;
}
private void button8_Click_1(object sender, EventArgs e)
{
Decimal sub3;
Decimal sub4;
Decimal sub5;
Decimal result;
Decimal.TryParse(nbsalbs.Text, out sub3);
Decimal.TryParse(nbinss.Text, out sub4);
Decimal.TryParse(nbdepRS2.Text, out sub5);
result = sub3 - sub4 - sub5;
nbdep.Text = Decimal.Round(result, 2).ToString();
}
private void button4_Click(object sender, EventArgs e)
{
Decimal Mult8;
Decimal Mult9;
Decimal result;
Decimal.TryParse(txtdep.Text, out Mult8);
Decimal.TryParse(nbdepRS.Text, out Mult9);
result = Mult8 * Mult9;
nbdepRS2.Text = Decimal.Round(result, 2).ToString();
}
private void button7_Click(object sender, EventArgs e)
{
Decimal Mult10;
Decimal Mult11;
Decimal sub6;
decimal Porcento = 100;
Decimal result;
Decimal.TryParse(nbdep.Text, out Mult10);
Decimal.TryParse(txtaliquotairrf.Text, out Mult11);
Decimal.TryParse(nbparcded.Text, out sub6);
result = (Mult10 * Mult11 / Porcento) - sub6;
nbimpostoRS.Text = Decimal.Round(result, 2).ToString();
}
private void button9_Click(object sender, EventArgs e)
{
Decimal sub7;
Decimal sub8;
Decimal sub9;
Decimal result;
Decimal.TryParse(nbsalbs.Text, out sub7);
Decimal.TryParse(nbinss.Text, out sub8);
Decimal.TryParse(nbimpostoRS.Text, out sub9);
result = sub7 - sub8 - sub9;
nbliquidrec.Text = Decimal.Round(result, 2).ToString();
}
private void radioButton6_CheckedChanged(object sender, EventArgs e)
{
label29.Visible = true;
txtdep.Visible = true;
label30.Visible = true;
nbdepRS.Visible = true;
label26.Visible = true;
nbdepRS2.Visible = true;
button4.Visible = true;
}
private void radioButton5_CheckedChanged(object sender, EventArgs e)
{
label29.Visible = false;
txtdep.Visible = false;
label30.Visible = false;
nbdepRS.Visible = false;
label26.Visible = false;
nbdepRS2.Visible = false;
button4.Visible = false;
}
private void textBox6_TextChanged(object sender, EventArgs e)
{
}
private void txtDiaMes_TextChanged(object sender, EventArgs e)
{
Decimal a = Convert.ToDecimal(txtDiaMes.Text);
}
private void txtDiasGozo_TextChanged(object sender, EventArgs e)
{
Decimal a = Convert.ToDecimal(txtDiasGozo.Text);
}
private void txtferiasRS_TextChanged(object sender, EventArgs e)
{
Decimal a = Convert.ToDecimal(txtferiasRS.Text);
}
private void txtumterco_TextChanged(object sender, EventArgs e)
{
Decimal a = Convert.ToDecimal(txtumterco.Text);
}
}
}Tudo iesto é o código....
Mas este erro esta dando por causa, quando insiro os registros, em minha opinião, deve ser o campo testbox que esta conflitando quando eu digito ex: 30, dza este erro de syntaxe.
Obrigado pela atenção.
Discussão (10)
Carregando comentários...