WebSite1/addSample3.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_addSample3 : 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)
    {
       // if (!IsPostBack)
       // {
            string STconnection = ConfigurationSettings.AppSettings["strconnection"];
            string StrSql = "insert into Job_History (User_Name,Job_Start,Job_End,Job_City,Job_FullTime,Job_Company,Reason,Job_Role) values('" + Session["trueName"].ToString() + "',@Job_Start,@Job_End,@Job_City,@Job_FullTime,@Job_Company,@Reason,@Reason)";
            SqlConnection Strconn = new SqlConnection(STconnection);
            try
            {
                Strconn.Open();
                SqlCommand StrCmdIn = new SqlCommand(StrSql, Strconn);
                StrCmdIn.Parameters.Add(new SqlParameter("@Job_Start", SqlDbType.DateTime, 8));
                StrCmdIn.Parameters.Add(new SqlParameter("@Job_End", SqlDbType.DateTime, 8));
                StrCmdIn.Parameters.Add(new SqlParameter("@Job_City", SqlDbType.VarChar, 50));
                StrCmdIn.Parameters.Add(new SqlParameter("@Job_FullTime", SqlDbType.Char, 10));
                StrCmdIn.Parameters.Add(new SqlParameter("@Job_Company", SqlDbType.Text , 16));
                StrCmdIn.Parameters.Add(new SqlParameter("@Reason", SqlDbType.Text , 16));
                StrCmdIn.Parameters.Add(new SqlParameter("@Job_Role", SqlDbType.VarChar , 50));

                StrCmdIn.Parameters["@Job_Start"].Value = JobSTime.Text;
                StrCmdIn.Parameters["@Job_End"].Value = JobEnTime.Text;
                StrCmdIn.Parameters["@Job_City"].Value = JobMoName.Text;
                StrCmdIn.Parameters["@Job_FullTime"].Value = JobWay.Text;
                StrCmdIn.Parameters["@Job_Company"].Value = JobName.Text;
                StrCmdIn.Parameters["@Reason"].Value = TextBox1.Text;
                StrCmdIn.Parameters["@Job_Role"].Value = JobDuty .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();