WebSite1/addSample.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_addSample : System.Web.UI.Page
{    
    string STconnection = null;       
    protected void Page_Load(object sender, EventArgs e)
    {  
       msn .Text =Session ["NiName"].ToString ();
       TextBox11.Text =Convert .ToString ( System.DateTime.Now.ToLocalTime());
       
    }
    protected void Button1_Click1(object sender, EventArgs e)
    {
        Label2.Text.Trim();
        string dateborth1;
        string dateborth2;
        string borth;
        dateborth1 = StrYear.Text;
        dateborth2 = StrMonth.Text;
        borth = dateborth1 + dateborth2;
        STconnection = ConfigurationSettings.AppSettings["strconnection"];
        string StrSqlIns = "insert into JianLi_inf (X_Name,X_Sex,X_Nation,X_Borth,X_Grade,X_School,X_Mayor,X_Position,X_Direcion,X_Time,X_HukouCity,X_TelMobile,X_Email,X_Address,X_Raward,X_CetPet,X_Computer,X_Status) values(@Name,@Sex,@Nation,@Borth,@Grade,@School,@Mayor,@Position,@Direcion,@Time,@HukouCity,@TelMobile,@Email,@Address,@Raward,@CetPet,@Computer,@Status)";
        SqlConnection Strconn = new SqlConnection(STconnection);
       try
        {   
            Strconn.Open();
            SqlCommand StrCmd = new SqlCommand(StrSqlIns, Strconn);
            StrCmd.Parameters.Add(new SqlParameter("@Name",SqlDbType .VarChar ,50));
            StrCmd.Parameters.Add(new SqlParameter("@Sex", SqlDbType.NChar ,7));
            StrCmd.Parameters.Add(new SqlParameter("@Nation", SqlDbType.Char, 10));
            StrCmd.Parameters.Add(new SqlParameter("@Borth", SqlDbType.VarChar,50));
            StrCmd.Parameters.Add(new SqlParameter("@Grade", SqlDbType.Char, 10));
            StrCmd.Parameters.Add(new SqlParameter("@School", SqlDbType.VarChar, 50));
            StrCmd.Parameters.Add(new SqlParameter("@Mayor", SqlDbType.Char, 10));
            StrCmd.Parameters.Add(new SqlParameter("@Position", SqlDbType.VarChar, 50));
            StrCmd.Parameters.Add(new SqlParameter("@Direcion", SqlDbType.VarChar, 50));
            StrCmd.Parameters.Add(new SqlParameter("@Time",SqlDbType .DateTime, 8));
            StrCmd.Parameters.Add(new SqlParameter("@HukouCity", SqlDbType.VarChar, 50));
            StrCmd.Parameters.Add(new SqlParameter("@TelMobile", SqlDbType.VarChar,50));
            StrCmd.Parameters.Add(new SqlParameter("@Email", SqlDbType.VarChar, 50));
            StrCmd.Parameters.Add(new SqlParameter("@Address", SqlDbType .Text ,16));
            StrCmd.Parameters.Add(new SqlParameter("@Raward", SqlDbType.Text ,16));
            StrCmd.Parameters.Add(new SqlParameter("@CetPet", SqlDbType.VarChar, 50));
            StrCmd.Parameters.Add(new SqlParameter("@Computer", SqlDbType.VarChar, 50));
            StrCmd.Parameters.Add(new SqlParameter("@Status", SqlDbType.VarChar, 50));
           
            StrCmd .Parameters ["@Name"].Value =TextBox1 .Text ;
            StrCmd.Parameters["@Sex"].Value = StrSex.Text;
            StrCmd.Parameters["@Nation"].Value = TextBox2.Text;
            StrCmd.Parameters["@Borth"].Value = borth;