帮忙看看我的insert语句为何写不进SQL Server?
private void Calendar1_SelectionChanged(object sender, System.EventArgs e)
{
txtYear.Text = Calendar1.SelectedDate.Year.ToString();
txtMonth.Text = Calendar1.SelectedDate.Month.ToString();
txtDay.Text = Calendar1.SelectedDate.Date.Day.ToString();
Calendar1.Visible = false;
}
private void btnUpimg_Click(object sender, System.EventArgs e)
{
string fullFileName,saveName;
int typePosition;
fullFileName = this.File1.Value.ToString();
typePosition = fullFileName.LastIndexOf(".");
saveName = fullFileName.Substring(typePosition);
this.File1.PostedFile.SaveAs(Server.MapPath("upfile")+"\\"+txtName.Text+saveName);
imgUp.ImageUrl = "upfile\\"+txtName.Text+saveName;
}
private void btnNext_3_Click(object sender, System.EventArgs e)
{
SqlConnection con = new SqlConnection("server=.;database=login;uid=sa;pwd=sa");
con.Open();
SqlCommand cmd = new SqlCommand("select count(*) from u_Login",con);
int count = Convert.ToInt32(cmd.ExecuteScalar())+1;
string birthDay = txtYear.Text+"-"+txtMonth.Text+"-"+txtDay.Text;//这句是获取生日日期
SqlCommand newCmd = new SqlCommand("insert into u_Login values("+count.ToString()+",'"+txtName.Text+"','"+txtPassword.Text+"','"+txtMail.Text+"','"+birthDay+"','"+imgUp.ImageUrl+"')",con);//这句写入
Response.Write(cmd.ExecuteNonQuery());//每次返回-1
}