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

public partial class Zxdg : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            this.head1.Title = "在线订购--" + Application["webName"].ToString();
        }
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        string ProName = TextBox2.Text;
        string ProNumber = TextBox3.Text;
        string ProCount = TextBox4.Text;
        string ProClass = TextBox1.Text;
        string PersonName = TextBox5.Text;
        string PersonTel = TextBox6.Text;
        string PersonMobileTel = TextBox7.Text;
        string Email = TextBox8.Text;
        string Address = TextBox9.Text;
        string YouBian = TextBox10.Text;

        string sql = "insert into [NcDg] ([ProClass],[ProName],[ProNumber],[ProCount],[PersonName],[PersonTel],[PersonMobileTel],[Email],[Address],[YouBian]) Values (@ProClass,@ProName,@ProNumber,@ProCount,@PersonName,@PersonTel,@PersonMobileTel,@Email,@Address,@YouBian)";
        OleDbParameter[] paras = new OleDbParameter[10];
        paras[0] = new OleDbParameter("@ProClass", ProClass);
        paras[1] = new OleDbParameter("@ProName", ProName);
        paras[2] = new OleDbParameter("@ProNumber", ProNumber);
        paras[3] = new OleDbParameter("@ProCount", ProCount);
        paras[4] = new OleDbParameter("@PersonName", PersonName);
        paras[5] = new OleDbParameter("@PersonTel", PersonTel);
        paras[6] = new OleDbParameter("@PersonMobileTel", PersonMobileTel);
        paras[7] = new OleDbParameter("@Email", Email);
        paras[8] = new OleDbParameter("@Address", Address);
        paras[9] = new OleDbParameter("@YouBian", YouBian);

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