UC知道为什么这么简单的问题我都不会？
来源：百度知道 编辑：UC知道 时间：2024/07/10 21:42:53
string str = System.Configuration.ConfigurationManager.AppSettings["sqlConnString"];
SqlConnection sc = new SqlConnection(str);
sc.Open();
string sqls = "insert into teacher_info_north(teacher_id,teacher_num,comp_num,tea_name,tea_password,dm_num,tea_address,department_id,tel,mobile_tel,salary_num_state,salary_num,lastdate,grade_type,tea_money,tea_grade,endmonth,ip_id,equip_num,port_id,area,rline,mline,sline,fline,checked,ep_state,move_state,user_state,install_state,equip_install_state,stopnet,set_date,set_id)values('" + intArray[0] + "','" + intArray[1] + "','" + intArray[2] + "','" + intArray[3] + "','" + intArray[4] + "','" + intArray[5] + "','" + intArray[6] + "','" + intArray[7] + "','" + intArray[8] + "','" + intArray[9] + "','" + intArray[10
SqlConnection sc = new SqlConnection(str);
sc.Open();
string sqls = "insert into teacher_info_north(teacher_id,teacher_num,comp_num,tea_name,tea_password,dm_num,tea_address,department_id,tel,mobile_tel,salary_num_state,salary_num,lastdate,grade_type,tea_money,tea_grade,endmonth,ip_id,equip_num,port_id,area,rline,mline,sline,fline,checked,ep_state,move_state,user_state,install_state,equip_install_state,stopnet,set_date,set_id)values('" + intArray[0] + "','" + intArray[1] + "','" + intArray[2] + "','" + intArray[3] + "','" + intArray[4] + "','" + intArray[5] + "','" + intArray[6] + "','" + intArray[7] + "','" + intArray[8] + "','" + intArray[9] + "','" + intArray[10
intArray[15] + "',,'" + intArray[16]两个逗号
是否有自增的ID，你也插入？
服！这么长的SQL就用
string.Format("insert into Table(id,name,pwd,email)values({0},'{1}','{2}','{3}')",Id,Name,Pwd,Email);的形式写嘛，
int就用{0} string就用‘{0}’,这样容易看撒，出问题也好看些嘛。