当前文件路径：XiaoFanWeb/admin/product_type_add.aspx.cs

		            
 1using System;
 2using System.Data;
 3using System.Configuration;
 4using System.Collections;
 5using System.Web;
 6using System.Web.Security;
 7using System.Web.UI;
 8using System.Web.UI.WebControls;
 9using System.Web.UI.WebControls.WebParts;
10using System.Web.UI.HtmlControls;
11
12using System.Data.OleDb;
13public partial class admin_product_type_add : System.Web.UI.Page
14...{
15    protected void Page_Load(object sender, EventArgs e)
16    ...{
17
18    }
19    protected void Button1_Click(object sender, EventArgs e)
20    ...{
21        OleDbConnection oledbcon = new OleDbConnection("provider=Microsoft.Jet.OLEDB.4.0;data source=" + HttpContext.Current.Server.MapPath(@"~/App_Data/dbs.mdb"));
22        string InString = "insert into FZ_Product_Type(Name,Ord,Pid)values('" + TextBox1.Text.ToString() + "','" + TextBox2.Text.ToString() + "','" + DropDownList1 .SelectedValue+ "')";
23        oledbcon.Open();
24        OleDbCommand cmd = new OleDbCommand(InString,oledbcon);
25        cmd.ExecuteNonQuery();
26        oledbcon.Close();
27        OKmessage.Text = "(" + TextBox1.Text.ToString() + ")→信息添加成功！";
28        OKmessage.Visible = true;
29
30    }
31}
32