出现上图错误,我的源代码
protected void Button1_Click(object sender, EventArgs e)
{
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);//创建连接对象
SqlCommand insertCmd = new SqlCommand("insert into Course(CId,TName,CName,CType,CCredit,CMax,CTime,RoomName) values(@CId,@TName,@CName,@CType,@CCredit,@CMax,@CTime,@RoomName)", conn);
insertCmd.Parameters.Add("@CId", SqlDbType.Int, 4);//设置参数
insertCmd.Parameters.Add("@TName", SqlDbType.VarChar, 20);
insertCmd.Parameters.Add("@CName", SqlDbType.VarChar, 20);
insertCmd.Parameters.Add("@CType", SqlDbType.VarChar, 20);
insertCmd.Parameters.Add("@CCredit", SqlDbType.Int, 4);
insertCmd.Parameters.Add("@CMax", SqlDbType.Int, 4);
insertCmd.Parameters.Add("@CTime", SqlDbType.VarChar, 50);
insertCmd.Parameters.Add("@RoomName", SqlDbType.VarChar, 50);
insertCmd.Parameters["@CId"].Value = TextBox1.Text; //为每个参数赋值
insertCmd.Parameters["@TName"].Value = DropDownList1.SelectedItem.Text;
insertCmd.Parameters["@CName"].Value = TextBox2.Text;
insertCmd.Parameters["@CType"].Value = TextBox3.Text;
insertCmd.Parameters["@CCredit"].Value = TextBox4.Text;
insertCmd.Parameters["@CMax"].Value = TextBox5.Text;
insertCmd.Parameters["@CTime"].Value = TextBox6.Text;
insertCmd.Parameters["@RoomName"].Value = DropDownList2.SelectedItem.Text;
try
{
conn.Open();
int flag = insertCmd.ExecuteNonQuery(); //执行添加
}
catch (System.Exception ee)
{
Response.Write("<script language=javascript>alert('" + ee.Message.ToString() + "')</script>");
}
finally
{
conn.Close();
}