using System;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
public partial class Teacher_ThesisAdd : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
Sec.Authentication(false, false, true, false);
}
protected void btnNext_Click(object sender, EventArgs e)
{
if (true == AddRecord())
{
tbxCaption.Text = "";
tbxField.Text = "";
tbxContent.Text = "";
tbxRequirement.Text = "";
// ddlconstudy.SelectedValue="N";
// ddlconfact.SelectedValue = "N";
tbxMemo.Text = "";
tbxCaption.Focus();
}
}
protected void btnAdd_Click(object sender, EventArgs e)
{
if (true == AddRecord())
Response.Redirect("ThesisList.aspx");
}
protected bool AddRecord()
{
SqlConnection cn = Com.GetConnection();
// SqlCommand cmd = new SqlCommand(
// "insert into Thesis values(@caption,@content,@requirement,@field,@date,@memo,@teacherID,@specialtyID,null)", cn);
SqlCommand cmd = new SqlCommand(
"insert into Thesis values(@caption,@content,@requirement,@field,@constudy,@confact,@date,@memo,@teacherID,@specialtyID,null)", cn);
cmd.Parameters.AddWithValue("@caption", tbxCaption.Text);
cmd.Parameters.AddWithValue("@content", tbxContent.Text);
cmd.Parameters.AddWithValue("@requirement", tbxRequirement.Text);
cmd.Parameters.AddWithValue("@field", tbxField.Text);
cmd.Parameters.AddWithValue("@constudy", ddlconstudy.SelectedValue);
cmd.Parameters.AddWithValue("@confact", ddlconfact.SelectedValue);
cmd.Parameters.AddWithValue("@date", DateTime.Now);
cmd.Parameters.AddWithValue("@memo", tbxMemo.Text);
cmd.Parameters.AddWithValue("@teacherID", Session["LoginID"].ToString());
cmd.Parameters.AddWithValue("@specialtyID", ddlSpecialty.SelectedValue);
cn.Open();
cmd.ExecuteNonQuery();
// cmdresults = cmd.ExecuteNonQuery()
cn.Close();
return true;
}
}
问题补充：cmd.ExecuteNonQuery();//(在这里提示有错)
将字符串转换为 smalldatetime 数据类型时失败。
