fbjob.aspx.cs

大家一起研究研究,全部都是开源的CSHARP代码.带数据库的

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.OleDb;
using WAEMZ.DBUtility;

public partial class admin_FbJob : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {

    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        string JobTitle = this.TextBox1.Text;
        string address = this.TextBox2.Text;
        string numbers = this.TextBox3.Text;
        string xueLi = this.TextBox4.Text;
        string zhuanYe = this.TextBox5.Text;
        string nianLing = this.TextBox6.Text;
        string xingBie = this.TextBox7.Text;
        string huKou = this.TextBox8.Text;
        string dianNao = this.TextBox9.Text;
        string jingYan = this.TextBox10.Text;
        string miaoShu = this.TextBox11.Text;
        string yaoQiu = this.TextBox12.Text;
        string youXian = this.TextBox13.Text;
        string gz = this.TextBox14.Text;

        string sql = "insert into [NcZp] ([ZpTitle],[address],[numbers],[xueLi],[zhuanYe],[nianlIng],[xingBIe],[huKou],[DianNao],[JingYan],[MiaoShu],[YaoQiu],[YOuXian],[Gz]) Values (@jobTitle,@address,@numbers,@xueLi,@zhuanYe,@nianLing,@xingBie,@huKou,@dianNao,@jingYan,@miaoShu,@yaoQiu,@youXian,@gz)";
        OleDbParameter[] paras = new OleDbParameter[14];
        paras[0] = new OleDbParameter("@jobTitle", JobTitle);
        paras[1] = new OleDbParameter("@address", address);
        paras[2] = new OleDbParameter("@numbers", numbers);
        paras[3] = new OleDbParameter("@xueLi", xueLi);
        paras[4] = new OleDbParameter("@zhuanYe", zhuanYe);
        paras[5] = new OleDbParameter("@nianLing", nianLing);
        paras[6] = new OleDbParameter("@xingBie", xingBie);
        paras[7] = new OleDbParameter("@huKou", huKou);
        paras[8] = new OleDbParameter("@dianNao", dianNao);
        paras[9] = new OleDbParameter("@jingYan", jingYan);
        paras[10] = new OleDbParameter("@miaoShu", miaoShu);
        paras[11] = new OleDbParameter("@yaoQiu", yaoQiu);
        paras[12] = new OleDbParameter("@youXian", youXian);
        paras[13] = new OleDbParameter("@gz", gz);
        DbHelperACE.ExecuteSql(sql, paras);
        Response.Write("<script>alert('操作成功!');location.href='ManageJob.aspx';</script>");

    }
}