SqlCommand cmd = new SqlCommand("Update policrec set policname,location,cortno,datac,dater,namem,crim4,fi5,nfi6,in7,tc8,tcn9,nca10,nc11,iv12,nc13,nca14,wr15,crp16,psm17,ops18,se19,ha20,frp21,mc22,src23,rlc24,icra25,mp26,pst27,ma28,mab28,mabi28,wrs29,mb30,fsm31,mtr32,r2g32,rnp32,mrt32,r2p32,rpn32,whr33,sci34,frm35,bsr36,acr37,bd38,phd40,dna41,ascr42,rign42,roz42,rgn42,rng42,wsp43,wrb44,mfo45,pstm46,zam47,mrds48,knm49,mch50,r1co51,r2pr51,rozn51,rigp51,ri12sr51,r19sr51,rig21r51,crtm52,adt53,quas54,supr55,pdsp56,cnid57,cirdt57,matc58,mat58,vitr59,sdtj59,dism60,apireg61,pnsh62,parpen63,cortmof64,corwnt65,zamt66,ciadd67,regstai68,inofic69,offista70 set values = N'" + polnam.Text + "',N'" + loct.Text + "',N'" + cort.Text + "',N'" + datc.Text + "',N'" + datr.Text + "',N'" + namm.Text + "',N'" + crm.Text + "',N'" + crmfir.Text + "',N'" + nafir.Text + "',N'" + invesn.Text + "',N'" + nocrm.Text + "',N'" + nocrd.Text + "',N'" + noadd.Text + "',N'" + textBox13.Text + "',N'" + textBox14.Text + "',N'" + textBox15.Text + "',N'" + textBox16.Text + "',N'" + textBox17.Text + "',N'" + comboBox2.Text + "',N'" + comboBox3.Text + "',N'" + comboBox4.Text + "',N'" + comboBox5.Text + "',N'" + comboBox6.Text + "',N'" + comboBox7.Text + "',N'" + textBox18.Text + "',N'" + comboBox8.Text + "',N'" + comboBox9.Text + "',N'" + comboBox10.Text + "',N'" + comboBox11.Text + "',N'" + comboBox12.Text + "',N'" + textBox19.Text + "',N'" + textBox20.Text + "',N'" + textBox21.Text + "',N'" + comboBox13.Text + "',N'" + comboBox14.Text + "',N'" + comboBox1.Text + "',N'" + comboBox15.Text + "',N'" + textBox1.Text + "',N'" + textBox2.Text + "',N'" + comboBox16.Text + "',N'" + textBox3.Text + "',N'" + textBox4.Text + "',N'" + comboBox17.Text + "',N'" + comboBox18.Text + "',N'" + comboBox19.Text + "',N'" + comboBox20.Text + "',N'" + comboBox21.Text + "',N'" + comboBox22.Text + "',N'" + comboBox23.Text + "',N'" + comboBox24.Text + "',N'" + comboBox25.Text + "',N'" + comboBox26.Text + "',N'" + textBox5.Text + "',N'" + textBox6.Text + "',N'" + textBox7.Text + "',N'" + textBox8.Text + "',N'" + comboBox27.Text + "',N'" + comboBox28.Text + "',N'" + comboBox29.Text + "',N'" + comboBox30.Text + "',N'" + comboBox31.Text + "',N'" + comboBox32.Text + "',N'" + comboBox33.Text + "',N'" + comboBox34.Text + "',N'" + textBox9.Text + "',N'" + textBox10.Text + "',N'" + textBox11.Text + "',N'" + textBox12.Text + "',N'" + textBox22.Text + "',N'" + textBox23.Text + "',N'" + textBox24.Text + "',N'" + comboBox35.Text + "',N'" + comboBox36.Text + "',N'" + comboBox37.Text + "',N'" + comboBox38.Text + "',N'" + comboBox39.Text + "',N'" + textBox25.Text + "',N'" + textBox26.Text + "',N'" + comboBox40.Text + "',N'" + textBox27.Text + "',N'" + textBox28.Text + "',N'" + textBox29.Text + "',N'" + comboBox41.Text + "',N'" + comboBox42.Text + "',N'" + comboBox43.Text + "',N'" + comboBox44.Text + "',N'" + comboBox45.Text + "',N'" + comboBox46.Text + "',N'" + comboBox47.Text + "',N'" + comboBox48.Text + "',N'" + comboBox49.Text + "',N'" + textBox30.Text + "' N'" + textBox31.Text + "')", abc);
the above update query not work correctly plz help any body