jmhz.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 JmHz : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {

        }
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        string JmCompany = this.TextBox1.Text;
        string ZiBen = this.TextBox2.Text;
        string FaRen = this.TextBox3.Text;
        string YeWu = this.TextBox4.Text;
        string Address = this.TextBox5.Text;
        string YouBian = this.TextBox6.Text;
        string Tel = this.TextBox7.Text;
        string ShouJi = this.TextBox8.Text;
        string ChuanZhen = this.TextBox9.Text;
        string Email = this.TextBox10.Text;
        string WebUrl = this.TextBox11.Text;
        string XingTai = this.DropDownList1.SelectedItem.Value;

        string sql = "insert into [NcJm] ([JmCompany],[ZiBen],[FaRen],[YeWu],[Address],[YouBian],[Tel],[ShouJi],[ChuanZhen],[Email],[WebUrl],[XingTai]) Values (@JmCompany,@ZiBen,@FaRen,@YeWu,@Address,@YouBian,@Tel,@ShouJi,@ChuanZhen,@Email,@WebUrl,@XingTai)";
        OleDbParameter[] paras = new OleDbParameter[12];
        paras[0] = new OleDbParameter("@JmCompany", JmCompany);
        paras[1] = new OleDbParameter("@ZiBen", ZiBen);
        paras[2] = new OleDbParameter("@FaRen", FaRen);
        paras[3] = new OleDbParameter("@YeWu", YeWu);
        paras[4] = new OleDbParameter("@Address", Address);
        paras[5] = new OleDbParameter("@YouBian", YouBian);
        paras[6] = new OleDbParameter("@Tel", Tel);
        paras[7] = new OleDbParameter("@ShouJi", ShouJi);
        paras[8] = new OleDbParameter("@ChuanZhen", ChuanZhen);
        paras[9] = new OleDbParameter("@Email", Email);
        paras[10] = new OleDbParameter("@WebUrl", WebUrl);
        paras[11] = new OleDbParameter("@XingTai", XingTai);

        DbHelperACE.ExecuteSql(sql, paras);
        Response.Write("<script>alert('提交申请成功!');location.href='Default.aspx';</script>");


    }
}