erjicanshu.aspx.cs

ASP.net+Access数据库源码数据库源码

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;

public partial class erjicanshu : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            OleDbConnection con = DB.mycon();
            con.Open();
            OleDbCommand cmm = new OleDbCommand("select distinct bmID,bmName from bmTable", con);
            OleDbDataReader ddr = cmm.ExecuteReader();
            this.DropDownList1.DataSource = ddr;
            this.DropDownList1.DataTextField = "bmName";
            this.DropDownList1.DataValueField = "bmID";
            this.DropDownList1.DataBind();
            ddr.Close();
            con.Close();
            this.Label1.Text = DropDownList1.SelectedValue.ToString();
            
            DataTable tab = DB.createConnection("select max(bsID) as mmx from bmTable where bmID = '" + this.DropDownList1.Text + "'").Tables[0];
            for (int i = 0; i < tab.Rows.Count; i++)
            {
                for (int j = 0; j < tab.Columns.Count; j++)
                {
                    double ss = DB.val(tab.Rows[i]["mmx"].ToString().Trim()) + 1;
                    Label2.Text = ss.ToString("00");
                }
            }
        }  
    }

    protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
    {
        this.Label1.Text = DropDownList1.Text;
        DataTable tabb = DB.createConnection("select max(bsID) as mmx from bmTable where bmID = '"+this.DropDownList1.Text+"'").Tables[0];
        for (int i = 0; i < tabb.Rows.Count; i++)
        {
            for (int j = 0; j < tabb.Columns.Count; j++)
            {
                double ss = DB.val(tabb.Rows[i]["mmx"].ToString().Trim()) + 1;
                Label2.Text = ss.ToString("00");
            }
        }
    }

    protected void Button1_Click(object sender, EventArgs e)
    {
        string ss = "";
        DataTable taab = DB.createConnection("select distinct bmName from bmTable where bmID='" + Label1.Text.ToString().Trim() + "'").Tables[0];
        for (int i = 0; i < taab.Rows.Count; i++)
        {
            for (int j = 0; j < taab.Columns.Count; j++)
            {
                ss = taab.Rows[i]["bmName"].ToString().Trim();
            }
        }
        if (DropDownList1.Text.Trim() != "" || TextBox1.Text.Trim() != "")
        {
            DB.SqlDo("insert into bmTable(bmID,bmName,bsID,bsName) values('" + Label1.Text.ToString().Trim() + "','" + ss + "','" + Label2.Text.ToString().Trim() + "','" + TextBox1.Text.ToString().Trim() + "')");
            TextBox1.Text = "";
        }

        //string sl;
        DataTable tbl = DB.createConnection("select max(bsID) as mmx from bmTable where bmID = '" + this.DropDownList1.Text + "'").Tables[0];
        for (int i = 0; i < tbl.Rows.Count; i++)
        {
            for (int j = 0; j < tbl.Columns.Count; j++)
            {
                double sl = DB.val(tbl.Rows[i]["mmx"].ToString().Trim()) + 1;
                Label2.Text = sl.ToString("00");
            }
        }
    }
}