教务系统——班级管理——全部代码-优快云博客

这个博客展示了如何使用C#实现教务系统的班级管理功能，包括连接数据库、更新班级信息、查询数据、数据绑定以及处理编辑、更新、取消和删除操作的函数。通过示例代码，解释了如何进行SQL操作并处理异常。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

using System;
using System.Data;
using System.Configuration;
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;
using System.Data.SqlClient;

public partial class _Default : System.Web.UI.Page
{
    SqlConnection conn = new SqlConnection();
    //public void lianjie()
    //{
    //    conn.ConnectionString = "Data Source=.;Initial Catalog=TeachingSystem;Integrated Security=True";
    //    conn.Open();
    //}
    public string updateclass( string classid, string classname, string departmentname, string teacherid )
    {
        //SqlConnection conn = new SqlConnection();
        conn.ConnectionString = "Data Source=.;Initial Catalog=TeachingSystem;Integrated Security=True";
        conn.Open();
            string str=null;
            string sqlstr = "update TS_class set TS_Class_name=@classname,TS_Class_department=@departmentname,TS_Class_teacherid=@teacherid where TS_Class_id=@classid";
            SqlCommand comm = new SqlCommand(sqlstr, conn);
            try
            {
                comm.Parameters.Add(new SqlParameter("@classid", SqlDbType.VarChar, 50));
                comm.Parameters.Add(new SqlParameter("@classname", SqlDbType.VarChar, 50));
                comm.Parameters.Add(new SqlParameter("@departmentname", SqlDbType.VarChar , 50));
                comm.Parameters.Add(new SqlParameter("@teacherid", SqlDbType.VarChar , 50));

                comm.Parameters["@classid"].Value = classid;
                comm.Parameters["@classname"].Value =classname ;
                comm.Parameters["@departmentname"].Value = departmentname ;
                comm.Parameters["@teacherid"].Value =teacherid ;

                //comm.Connection.Open();
                comm.ExecuteNonQuery();