string sql = "update IrrBIncome set 农业水费收入 ="
+ arraySingle[0] + ",工业水费收入 = " + arraySingle[1] + ",小水电电费收入=" + arraySingle[2]
+ ", 综合经营收入 ="+ arraySingle[3] +",其它收入 ="+ arraySingle[4]
+",总收入 = "+ arraySingle[5]+",农业水费支出 ="+ arraySingle[10]+",工业水费支出 ="
+ arraySingle[9]+", 小水电电费支出 ="+ arraySingle[8]+",综合经营支出="+ arraySingle[7]
+",其它支出 ="+ arraySingle[6]+",总支出 ="+ arraySingle[11]+",农业水费结余 ="
+ arraySingle[12]+",工业水费结余 ="+ arraySingle[13]+",小水电电费结余 ="+ arraySingle[14]
+",综合经营结余 ="+ arraySingle[15]+",其它结余 ="+ arraySingle[16] + " ,总结余 ="
+ arraySingle[17] + "where 年份 ='"+ this.comboYearBox.Text.ToString()+ "'";
1、确定的语句要用双引号,也就是字符串都要用双引号;
2、数值要带前加号,后加号;
3、传入的字符要另外带单引号,如红色三;