Question

VS2005中数据老是提交失败，各位高手帮帮忙啊

string sql;
string kygl = System.Configuration.ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;

SqlConnection conn = new SqlConnection(kygl);
mingcheng = TextBox1.Text.ToString()；
fuzheren = TextBox2.Text.ToString();
chengyuan = TextBox3.Text.ToString();
kssj = TextBox4.Text.ToString();
jzsj = TextBox5.Text.ToString();
jingfei = TextBox6.Text.ToString();
leibie = TextBox7.Text.ToString();
laiyuan = TextBox8.Text.ToString();
int guikou = Convert.ToInt32(DropDownList1.SelectedItem.Value);
jinzhan =DropDownList2.SelectedItem.Value;
int dengji =Convert.ToInt32(DropDownList3.SelectedItem.Value);
jiangli = TextBox11.Text.ToString();
SqlDataReader mydr;
conn.Open();
SqlCommand comm = new SqlCommand();
comm.Connection = conn;
sql = "Select * from kyxmb Where kyxm_mc='" + mingcheng + "'";
comm.CommandText = sql;
mydr = comm.ExecuteReader();
if (mydr.Read())
{

Response.Write("<script>alert('" + "此项目已存在！" + "')</script>");

}
else
{

sql = "Insert into kyxmb(kyxm_mc,kyxm_fzr，kyxm_cy,kyxm_qssj,kyxm_jzrq,kyxm_jf,kyxm_lb,kyxm_ly,gkdw_id,kyxm_yjjz，jldj_id,kyxm_kyjl) Values('" +

mingcheng + "','" + fuzheren + "','" + chengyuan + "','" + kssj + "','" + jzsj + "','" + jingfei + "','" + leibie + "','" + laiyuan + "','" + guikou + "','" + jinzhan + "','" + jiangli + "','" + dengji + "')";
SqlCommand comm2 = new SqlCommand(sql, conn);

try
{
comm2.ExecuteNonQuery();
Response.Write("<script>alert('提交成功！')</script>");
}
catch (SqlException)
{
Response.Write("<script>alert('提交失败！')</script>");
}
finally
{
conn.Close();
}
//Response.Write("<script>alert('" + "提交成功" + "')</script>");
//Response.Write("<script>window.location.href='SubmitDraft.aspx'</script>");
}
mydr.Close();

}
}

Answer 1

sql = "Insert into kyxmb(kyxm_mc,kyxm_fzr，kyxm_cy,kyxm_qssj,kyxm_jzrq,kyxm_jf,kyxm_lb,kyxm_ly,gkdw_id,kyxm_yjjz，jldj_id,kyxm_kyjl) Values('" +

mingcheng + "','" + fuzheren + "','" + chengyuan + "','" + kssj + "','" + jzsj + "','" + jingfei + "','" + leibie + "','" + laiyuan + "','" + guikou + "','" + jinzhan + "','" + jiangli + "','" + dengji + "')";
你这里面有几个逗号是全角的，改成半角的就好