default.aspx.cs

均价表计算

using System;
using System.Data;
using System.Configuration;
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.IO;
using System.Data.OleDb;

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

    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        OleDbConnection conn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath("CZZ.mdb"));
        string sqlCom = "insert into lp(lp_name,lp_price,lp_time)values('"+TextBox1.Text.Trim()+"','"+TextBox2.Text.Trim()+"','" +TextBox3.Text.Trim()+"')";
        OleDbCommand cmd = new OleDbCommand(sqlCom,conn); 
			try
			{   
                conn.Open();
				cmd.ExecuteNonQuery();
			}
			catch
			{
			}
			finally{
			conn.Close();
            //Response.Write(sqlCom);
		    Response.Redirect("tongji.aspx");
			
			}

			
		}
    }