数据库原理课程设计报告-教室管理信息系统

Source=.;InitialCatalog=project;IntegratedSecurity=True";SqlConnectionconn=newSqlConnection(conString);conn.Open();mandcbb=mand("updateteachersettname='"+TextBox2.Text.Trim()+"',tsex='"+TextBox3.Text.Trim()+"',tdept='"+TextBox4.Text.Trim()+"',tcourse='"+TextBox5.Text.Trim()+"',coursetime='"+TextBox6.Text.Trim()+"'wheretno="+TextBox1.Text.Trim()+"",conn);if(cbb.ExecuteNonQuery()==1){Page.RegisterStartupScript("msg1","<script>alert('修改成功!')</script>");}else{Page.RegisterStartupScript("msg1","<script>alert('输入的信息有误!')</script>");}conn.Close();添加语句:mandcdd=mand("insertintoteacher(tno,tname,tsex,tdept,tcourse,coursetime)values('"+TextBox1.Text.Trim()+"','"+TextBox2.Text.Trim()+"','"+TextBox3.Text.Trim()+"','"+TextBox4.Text.Trim()+"','"+TextBox5.Text.Trim()+"','"+TextBox6.Text.Trim()+"')",conn);