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();