WebSite1/addSample2.aspx.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Data;
using System.Configuration;
using System.Collections;
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 WebSite1_addSample2 : System.Web.UI.Page
{
   
    protected void Page_Load(object sender, EventArgs e)
    {
        msn .Text =Session ["NiName"].ToString ();
     
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        string STconnection = ConfigurationSettings.AppSettings["strconnection"];
        string StrSql = "insert into Study_History (User_Name,SH_Start,SH_End,SH_School,SH_Monster,SH_Grade,SH_Zhiwu) values('" + Session["trueName"].ToString() + "',@ScTime,@ScEnTime,@ScName,@ScMonstor,@ScGrade,@ScDuty)";
        SqlConnection Strconn = new SqlConnection(STconnection);
        try
        {
            Strconn.Open();
            SqlCommand StrCmdIn = new SqlCommand(StrSql, Strconn);
            StrCmdIn.Parameters.Add(new SqlParameter("@ScTime", SqlDbType .DateTime,8));
            StrCmdIn.Parameters.Add(new SqlParameter("@ScEnTime", SqlDbType.DateTime,8));
            StrCmdIn.Parameters.Add(new SqlParameter("@ScName", SqlDbType.VarChar,50));
            StrCmdIn.Parameters.Add(new SqlParameter("@ScMonstor", SqlDbType.Char,10));
            StrCmdIn.Parameters.Add(new SqlParameter("@ScGrade", SqlDbType.Char, 10));
            StrCmdIn.Parameters.Add(new SqlParameter("@ScDuty", SqlDbType.Char,10));

            StrCmdIn.Parameters["@ScTime"].Value = ScSTime.Text;
            StrCmdIn.Parameters["@ScEnTime"].Value = ScEnTime.Text;
            StrCmdIn.Parameters["@ScName"].Value = ScName.Text;
            StrCmdIn.Parameters["@ScMonstor"].Value = ScMoName.Text;
            StrCmdIn.Parameters["@ScGrade"].Value = ScGrade.Text;
            StrCmdIn.Parameters["@ScDuty"].Value = ScDuty.Text;
            StrCmdIn.ExecuteNonQuery();
            messageshow.Text = "添加成功！！";
            messageshow.Visible = true;
            messageshow .Style ["color"]="green";
           
        }
        catch (Exception e1)
        {          
           messageshow.Text = "添加失败！！";
           messageshow.Visible = true;
           messageshow.Style["color"] = "red"; 
          // Response.Write("<javascript>alert('添加失败!!');</javascript>");
        }
        finally
        {
            Strconn.Close();
        }            
    }