jichicanshu.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 jichicanshu : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        DataTable tab = DB.createConnection("select max(bmID) as mmx from bmTable").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;
                Label3.Text = ss.ToString("00");
            } 
        }
        Label4.Text = "01";

    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        if (TextBox1.Text.Trim() != "" && TextBox2.Text.Trim() != "")
        {
            DB.SqlDo("insert into bmTable(bmID,bmName,bsID,bsName) values('" + Label3.Text.ToString().Trim() + "','" + TextBox1.Text.ToString().Trim() + "','" + Label4.Text.ToString().Trim() + "','" + TextBox2.Text.ToString().Trim() + "')");
        }
        this.TextBox1.Text = "";
        this.TextBox2.Text = "";

        DataTable tab = DB.createConnection("select max(bmID) as mmx from bmTable").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;
                Label3.Text = ss.ToString("00");
            }
        }
        Label4.Text = "01";

    }
    protected void Button2_Click(object sender, EventArgs e)
    {
        TextBox1.Text = "";
        TextBox2.Text = "";
    }
}