当前文件路径：XuanKeLunWen/student/Evaluation.aspx.cs

		            
 1using System;
 2using System.Data;
 3using System.Configuration;
 4using System.Collections;
 5using System.Web;
 6using System.Web.Security;
 7using System.Web.UI;
 8using System.Web.UI.WebControls;
 9using System.Web.UI.WebControls.WebParts;
10using System.Web.UI.HtmlControls;
11using System.Data.OleDb;
12
13public partial class studnet_Evaluation : System.Web.UI.Page
14...{
15    protected void Page_Load(object sender, EventArgs e)
16    ...{
17
18    }
19    protected void LinkButton1_Click(object sender, EventArgs e)
20    ...{
21        Insertpinglun();//该老师打分
22    }
23    private void Insertpinglun()
24    ...{//该老师打分
25        string student = Session["sname"].ToString();
26       
27        OleDbConnection con = db.con();
28        con.Open();
29        OleDbCommand cmd = new OleDbCommand("insert into  Tpinglun (pinglun,jianyi,student,pteacher)values(@pinglun,@jianyi,@Tstudent,@pteacher) ", con);
30        cmd.Parameters.Add("@pinglun", OleDbType.VarChar);
31        cmd.Parameters.Add("@jianyi", OleDbType.VarChar);
32        cmd.Parameters.Add("@student", OleDbType.VarChar);
33        cmd.Parameters.Add("@pteacher", OleDbType.VarChar);
34        cmd.Parameters["@pinglun"].Value = this.TextBox1.Text;
35        cmd.Parameters["@jianyi"].Value = this.RadioButtonList1.SelectedItem.Text;
36        cmd.Parameters["@student"].Value = student;
37        cmd.Parameters["@pteacher"].Value = this.DropDownList1.SelectedItem.Text;
38      
39        cmd.ExecuteNonQuery();
40
41        con.Close();
42        Response.Write("<script language='javascript'>alert('评论成功！')</script>");
43    }
44}