C# Acess数据库的 新增查询删除

最新推荐文章于 2024-11-01 17:40:27 发布
最新推荐文章于 2024-11-01 17:40:27 发布
阅读量148 收藏
点赞数
文章标签： c#
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/fancheeryup/article/details/119059797
版权

 

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using System.Data.OleDb;
using System.Data.SqlClient;
using System.Collections;

using System.Windows.Forms.DataVisualization.Charting;

namespace 立体仓库管理系统
{
    public partial class kuchenzangtai : Form
    {



        OleDbConnection conn = null;
        OleDbDataAdapter da = null;
        OleDbCommand ocomd = null;
        DataSet ds = null;
        DataTable dt = null;
        public static int hj1ifon = 0;
        public static int hj2ifon = 0;
        public static int hj3ifon = 0;
        public static int hj4ifon = 0;
        int hj1row = 0;
        int hj2row = 0;
        int hj3row = 0;
        int hj4row = 0;

       string conn1="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\\users\\lenovo\\documents\\visual studio 2013\\Projects\\立体仓库管理系统\\立体仓库管理系统\\huojia1.mdb";
       string conn2="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\\users\\lenovo\\documents\\visual studio 2013\\Projects\\立体仓库管理系统\\立体仓库管理系统\\huojia2.mdb";
       string conn3="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\\users\\lenovo\\documents\\visual studio 2013\\Projects\\立体仓库管理系统\\立体仓库管理系统\\huojia3.mdb";
       string conn4="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\\users\\lenovo\\documents\\visual studio 2013\\Projects\\立体仓库管理系统\\立体仓库管理系统\\huojia4.mdb";
        
        public kuchenzangtai()
        {
            InitializeComponent();

            



        }
        private void DataDisplay1()
        {
            conn = new OleDbConnection(conn1);
            string sql = "select * from hjia1";
            da = new OleDbDataAdapter(sql, conn);
            ds = new DataSet();
            da.Fill(ds, "hjia1");
            dt = ds.Tables["hjia1"];
            dataGridView4.DataSource = dt;
            conn.Close();

        }
        private void DataWrite1()
        {
          
            string txt2 =
            "Insert Into hjia1(ID,条码1,条码2) Values('";
            txt2 += textBox1.Text + "' , '";
            txt2 += textBox2.Text + "' , '";
            txt2 += textBox3.Text + "')";
            conn = new OleDbConnection(conn1);
            conn.Open();
            ocomd = new OleDbCommand();
            ocomd.CommandText = txt2;
            ocomd.Connection = conn;
            ocomd.ExecuteNonQuery();
            textBox1.Text = "";
            textBox2.Text = "";
            textBox3.Text = "";
            conn.Close();
            DataDisplay1();


        }
        private void DataDisplay2()
        {
            conn = new OleDbConnection(conn2);
            string sql = "select * from hjia2";
            da = new OleDbDataAdapter(sql, conn);
            ds = new DataSet();
            da.Fill(ds, "hjia2");
            dt = ds.Tables["hjia2"];
            dataGridView3.DataSource = dt;
            conn.Close();

        }
        private void DataWrite2()
        {

            string txt2 =
            "Insert Into hjia2(ID,条码1,条码2) Values('";
            txt2 += textBox1.Text + "' , '";
            txt2 += textBox2.Text + "' , '";
            txt2 += textBox3.Text + "')";
            conn = new OleDbConnection(conn2);
            conn.Open();
            ocomd = new OleDbCommand();
            ocomd.CommandText = txt2;
            ocomd.Connection = conn;
            ocomd.ExecuteNonQuery();
            textBox1.Text = "";
            textBox2.Text = "";
            textBox3.Text = "";
            conn.Close();
            DataDisplay2();


        }
   
        private void DataDisplay3()
        {
            conn = new OleDbConnection(conn3);
            string sql = "select * from hjia3";
            da = new OleDbDataAdapter(sql, conn);
            ds = new DataSet();
            da.Fill(ds, "hjia3");
            dt = ds.Tables["hjia3"];
            dataGridView2.DataSource = dt;
            conn.Close();


        }
        private void DataWrite3()
        {

            string txt2 =
            "Insert Into hjia3(ID,条码1,条码2) Values('";
            txt2 += textBox1.Text + "' , '";
            txt2 += textBox2.Text + "' , '";
            txt2 += textBox3.Text + "')";
            conn = new OleDbConnection(conn3);
            conn.Open();
            ocomd = new OleDbCommand();
            ocomd.CommandText = txt2;
            ocomd.Connection = conn;
            ocomd.ExecuteNonQuery();
            textBox1.Text = "";
            textBox2.Text = "";
            textBox3.Text = "";
            conn.Close();
            DataDisplay3();


        }
        private void DataDisplay4()
        {
            conn = new OleDbConnection(conn4);
            string sql = "select * from hjia4";
            da = new OleDbDataAdapter(sql, conn);
            ds = new DataSet();
            da.Fill(ds, "hjia4");
            dt = ds.Tables["hjia4"];
            dataGridView1.DataSource = dt;
            conn.Close();

        }

        private void DataWrite4()
        {

            string txt2 =
            "Insert Into hjia4(ID,条码1,条码2) Values('";
            txt2 += textBox1.Text + "' , '";
            txt2 += textBox2.Text + "' , '";
            txt2 += textBox3.Text + "')";
            conn = new OleDbConnection(conn4);
            conn.Open();
            ocomd = new OleDbCommand();
            ocomd.CommandText = txt2;
            ocomd.Connection = conn;
            ocomd.ExecuteNonQuery();
            textBox1.Text = "";
            textBox2.Text = "";
            textBox3.Text = "";
            conn.Close();
            DataDisplay4();


        }


        private void kuchenzangtai_Load(object sender, EventArgs e)
        {
            //Provider=Microsoft.Jet.OLEDB.4.0;Data Source="E:\users\lenovo\documents\visual studio 2013\Projects\立体仓库管理系统\立体仓库管理系统\huojia1.mdb"
            //Provider=Microsoft.Jet.OLEDB.4.0;Data Source="E:\users\lenovo\documents\visual studio 2013\Projects\立体仓库管理系统\立体仓库管理系统\huojia2.mdb"
            //Provider=Microsoft.Jet.OLEDB.4.0;Data Source="E:\users\lenovo\documents\visual studio 2013\Projects\立体仓库管理系统\立体仓库管理系统\huojia3.mdb"
            //Provider=Microsoft.Jet.OLEDB.4.0;Data Source="E:\users\lenovo\documents\visual studio 2013\Projects\立体仓库管理系统\立体仓库管理系统\huojia4.mdb"
            // TODO:  这行代码将数据加载到表“huojia3DataSet1.hjia3”中。您可以根据需要移动或删除它。
            DataDisplay1();
            DataDisplay2();
            DataDisplay3();
            DataDisplay4();

            HJ1();
         
        }

        private void groupBox1_Paint(object sender, PaintEventArgs e)
        {
        
            e.Graphics.Clear(groupBox1.BackColor);
            e.Graphics.DrawString(groupBox1.Text, groupBox1.Font, Brushes.Blue, 10, 1);
            e.Graphics.DrawLine(Pens.Blue, 1, 7, 8, 7);
            e.Graphics.DrawLine(Pens.Blue, e.Graphics.MeasureString(groupBox1.Text, groupBox1.Font).Width + 8, 7, groupBox1.Width - 2, 7);
            e.Graphics.DrawLine(Pens.Blue, 1, 7, 1, groupBox1.Height - 2);
            e.Graphics.DrawLine(Pens.Blue, 1, groupBox1.Height - 2, groupBox1.Width - 2, groupBox1.Height - 2);
            e.Graphics.DrawLine(Pens.Blue, groupBox1.Width - 2, 7, groupBox1.Width - 2, groupBox1.Height - 2); 
        
        }

        private void groupBox2_Paint(object sender, PaintEventArgs e)
        {
            e.Graphics.Clear(groupBox2.BackColor);
            e.Graphics.DrawString(groupBox2.Text, groupBox2.Font, Brushes.Black, 10, 1);
            e.Graphics.DrawLine(Pens.Black, 1, 7, 8, 7);
            e.Graphics.DrawLine(Pens.Black, e.Graphics.MeasureString(groupBox2.Text, groupBox2.Font).Width + 8, 7, groupBox2.Width - 2, 7);
            e.Graphics.DrawLine(Pens.Black, 1, 7, 1, groupBox2.Height - 2);
            e.Graphics.DrawLine(Pens.Black, 1, groupBox2.Height - 2, groupBox2.Width - 2, groupBox2.Height - 2);
            e.Graphics.DrawLine(Pens.Black, groupBox2.Width - 2, 7, groupBox2.Width - 2, groupBox2.Height - 2); 
        }

        private void groupBox3_Paint(object sender, PaintEventArgs e)
        {
            e.Graphics.Clear(groupBox3.BackColor);
            e.Graphics.DrawString(groupBox3.Text, groupBox3.Font, Brushes.Black, 10, 1);
            e.Graphics.DrawLine(Pens.Black, 1, 7, 8, 7);
            e.Graphics.DrawLine(Pens.Black, e.Graphics.MeasureString(groupBox3.Text, groupBox3.Font).Width + 8, 7, groupBox3.Width - 2, 7);
            e.Graphics.DrawLine(Pens.Black, 1, 7, 1, groupBox1.Height - 2);
            e.Graphics.DrawLine(Pens.Black, 1, groupBox3.Height - 2, groupBox3.Width - 2, groupBox3.Height - 2);
            e.Graphics.DrawLine(Pens.Black, groupBox3.Width - 2, 7, groupBox3.Width - 2, groupBox3.Height - 2); 
        }

   
        

     


        private void button1_Click(object sender, EventArgs e)
        {
            if (radioButton1.Checked)
            {
                DataWrite1();
            }
            else if (radioButton2.Checked)
            {
                 DataWrite2();
            }
            else if (radioButton3.Checked)
            {
                DataWrite3();
            }
            else if (radioButton4.Checked)
            {
                DataWrite4();
            }
            
        }

     

        private void timer1_Tick(object sender, EventArgs e)
        {
            label2.Text = Form1.Revdate;
            label4.Text = Form1.senddate;

            HJ1();
            HJ2();
            HJ3();
            HJ4();

          
        }


        private void HJ1()
        {

            OleDbDataAdapter oleDapAdapter; //检索与填充数据，一般填充SQL语句  
            ds = new DataSet();
            oleDapAdapter = new OleDbDataAdapter("select * from hjia1", conn1);
            oleDapAdapter.Fill(ds);
            int a1 = ds.Tables[0].Rows.Count;
            hj1ifon = a1;
            hj1row = 60 - a1;
            double[] yValues = { hj1ifon,hj1row};
            string[] xValues = { "已用", "剩余" };
            chart1.Series[0].Points.DataBindXY(xValues, yValues);
          
        }
        private void HJ2()
        {

            OleDbDataAdapter oleDapAdapter; //检索与填充数据，一般填充SQL语句  
            ds = new DataSet();
            oleDapAdapter = new OleDbDataAdapter("select * from hjia2", conn2);
            oleDapAdapter.Fill(ds);
            int a1 = ds.Tables[0].Rows.Count;
            hj1ifon = a1;
            hj1row = 60 - a1;
            double[] yValues = { hj1ifon, hj1row };
            string[] xValues = { "已用", "剩余" };
            chart2.Series[0].Points.DataBindXY(xValues, yValues);
        }
        private void HJ3()
        {

            OleDbDataAdapter oleDapAdapter; //检索与填充数据，一般填充SQL语句  
            ds = new DataSet();
            oleDapAdapter = new OleDbDataAdapter("select * from hjia3", conn3);
            oleDapAdapter.Fill(ds);
            int a1 = ds.Tables[0].Rows.Count;
            hj1ifon = a1;
            hj1row = 60 - a1;
            double[] yValues = { hj1ifon, hj1row };
            string[] xValues = { "已用", "剩余" };
            chart3.Series[0].Points.DataBindXY(xValues, yValues);

        }
        private void HJ4()
        {

            OleDbDataAdapter oleDapAdapter; //检索与填充数据，一般填充SQL语句  
            ds = new DataSet();
            oleDapAdapter = new OleDbDataAdapter("select * from hjia4", conn4);
            oleDapAdapter.Fill(ds);
            int a1 = ds.Tables[0].Rows.Count;
            hj1ifon = a1;
            hj1row = 60 - a1;
            double[] yValues = { hj1ifon, hj1row };
            string[] xValues = { "已用", "剩余" };
            chart4.Series[0].Points.DataBindXY(xValues, yValues);
        }



        
       
        /// <summary>
        /// 接收到PLC发来的数据 
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void label2_TextChanged(object sender, EventArgs e)
        {
            inputorc();
        }
        /// <summary>
        /// 解析数据 第1位货架号 第2位入库及出库 第3-11编码1 第12-21编码2
        /// </summary>
        private void inputorc()
        {
            string str = label2.Text;
            try
            {
                if (str != "")
                {
                    string str3 = str.Substring(0, 1);
                    string str1 = str.Substring(1, 9);
                    string str2 = str.Substring(10, 9);
                    textBox2.Text = str1;
                    textBox3.Text = str2;
                   // Console.WriteLine(str3);
                    if (str3 == "1")
                    {

                        FindID1();
                        sendPLCdate();
                        DataWrite1();
                    }
                    if (str3 == "2")
                    {
                        FindID2();
                        sendPLCdate();
                        DataWrite2();
                    }
                    if (str3 == "3")
                    {
                        FindID3();
                        sendPLCdate();
                        DataWrite3();
                    }
                    if (str3 == "4")
                    {
                        FindID4();
                        sendPLCdate();
                        DataWrite4();
                    }
                }
 

            }
            catch {}
            
         
          
           


        } 
        private void button3_Click(object sender, EventArgs e)
        {
            if (radioButton1.Checked)
            {
                deledatID1();
            }
            if (radioButton2.Checked)
            {
                deledatID2();
            }
            if (radioButton3.Checked)
            {
                deledatID3();
            }
            if (radioButton4.Checked)
            {
                deledatID4();
            }

          
            
            
        }

       
        private void button2_Click(object sender, EventArgs e)
        {
            if (radioButton1.Checked)
            {
                FindID1();
            }
            if (radioButton2.Checked)
            {
                FindID2();
            }
            if (radioButton3.Checked)
            {
                FindID3();
            }
            if (radioButton4.Checked)
            {
                FindID4();
            }

           
        }
        /// <summary>
        /// 入库找空位
        /// </summary>
        private void FindID1()
        {
            ArrayList a1 = new ArrayList();


            OleDbDataAdapter oleDapAdapter; //检索与填充数据，一般填充SQL语句  
            ds = new DataSet();
            oleDapAdapter = new OleDbDataAdapter("select * from hjia1", conn1);
            oleDapAdapter.Fill(ds);
            int a2 = ds.Tables[0].Rows.Count;
            hj1row = a2;
            int inserta3 = 0;
            int[] arry1 = new int[a2];
            for (int j = 0; j < ds.Tables[0].Rows.Count; j++)
            {
                string ids = (ds.Tables[0].Rows[j]["ID"].ToString());//需要转成String类型  
                int idi = Convert.ToInt32(ids);
                arry1[j] = idi;
               
                // Console.Write(idi);

                // (i != Convert.ToInt32(ids))                  
                //   Console.WriteLine(ids); 
            }
            ds.Reset();
            Console.WriteLine();
            //for (int i = 0; i < arry1.Length; i++)
            //{
            //    Console.Write(arry1[i]); 
            //}
            //Console.WriteLine();
            Array.Sort(arry1);
            //for (int i = 0; i < arry1.Length; i++)
            //{
            //    Console.Write(arry1[i]);
            //}
            Console.WriteLine();

            //12345789101112131520

            int x = 1;//标识初值
            for (int i = 0; i < arry1.Length; i++)
            {

                if (arry1[i] != x)
                {
                    // Console.WriteLine(arry1[i]);
                    //inserta3 = arry1[i]-1 ;
                    //if (i >= 1)
                    //{
                    //    textBox1.Text = Convert.ToString(arry1[i - 1] + 1);
                    //    break;
                    //}
                    //else
                    //{
                    //    textBox1.Text = Convert.ToString(arry1[i] - 1);
                    //    break;
                    //}

                    textBox1.Text = Convert.ToString(arry1[i] - 1);
                    break;
                }
                else if (x == a2)
                {
                    textBox1.Text = Convert.ToString(a2 +1);
                    break; 
                }
                x++;//增量
            }
            Console.WriteLine(inserta3);
        }
        /// <summary>
        /// 清空已出库库位信息
        /// </summary>
        private void deledatID1()
        {
            if (textBox1.Text == "")
            {
                MessageBox.Show("ID号项必须填写！ ", "提示");
                return;
            }


            string txt2 = "Delete From hjia1 Where ID = " + textBox1.Text;

            conn = new OleDbConnection(conn1);
            conn.Open();
            ocomd = new OleDbCommand();
            ocomd.CommandText = txt2;
            ocomd.Connection = conn;
          // ocomd.ExecuteNonQuery();
            int a3 = ocomd.ExecuteNonQuery();
            if (a3==1)
            {
                MessageBox.Show("删除成功", "提示");
            }
            else
            {
                MessageBox.Show("删除成功,未找到删除的ID", "提示");
            }


         //   Console.WriteLine(a3);
            textBox1.Text = "";
            textBox2.Text = "";
            textBox3.Text = "";
            conn.Close();
            DataDisplay1(); 


        }
        /// <summary>
        /// 2号库
        /// </summary>
        private void FindID2()
        {
            ArrayList a1 = new ArrayList();


            OleDbDataAdapter oleDapAdapter; //检索与填充数据，一般填充SQL语句  
            ds = new DataSet();
            oleDapAdapter = new OleDbDataAdapter("select * from hjia2", conn2);
            oleDapAdapter.Fill(ds);
            int a2 = ds.Tables[0].Rows.Count;
            hj2row = a2;
            int inserta3 = 0;
            int[] arry1 = new int[a2];
            for (int j = 0; j < ds.Tables[0].Rows.Count; j++)
            {
                string ids = (ds.Tables[0].Rows[j]["ID"].ToString());//需要转成String类型  
                int idi = Convert.ToInt32(ids);
                arry1[j] = idi;
                // Console.Write(idi);

                // (i != Convert.ToInt32(ids))                  
                //   Console.WriteLine(ids); 
            }
            ds.Reset();
            Console.WriteLine();
            //for (int i = 0; i < arry1.Length; i++)
            //{
            //    Console.Write(arry1[i]); 
            //}
            //Console.WriteLine();
            Array.Sort(arry1);
            //for (int i = 0; i < arry1.Length; i++)
            //{
            //    Console.Write(arry1[i]);
            //}
            Console.WriteLine();

            //12345789101112131520

            int x = 1;//标识初值
            for (int i = 0; i < arry1.Length; i++)
            {

                if (arry1[i] != x)
                {
                    // Console.WriteLine(arry1[i]);
                    //inserta3 = arry1[i]-1 ;
                    //if (i >= 1)
                    //{
                    //    textBox1.Text = Convert.ToString(arry1[i - 1] + 1);
                    //    break;
                    //}
                    //else
                    //{
                    //    textBox1.Text = Convert.ToString(arry1[i] - 1);
                    //    break;
                    //}

                    textBox1.Text = Convert.ToString(arry1[i] - 1);
                    break;
                }
                else if (x == a2)
                {
                    textBox1.Text = Convert.ToString(a2 + 1);
                    break;
                }
                x++;//增量
            }
            Console.WriteLine(inserta3);
        }
        private void deledatID2()
        {
            if (textBox1.Text == "")
            {
                MessageBox.Show("ID号项必须填写！ ", "提示");
                return;
            }


            string txt2 = "Delete From hjia2 Where ID = " + textBox1.Text;

            conn = new OleDbConnection(conn2);
            conn.Open();
            ocomd = new OleDbCommand();
            ocomd.CommandText = txt2;
            ocomd.Connection = conn;
           // ocomd.ExecuteNonQuery();
            int a3 = ocomd.ExecuteNonQuery();
            if (a3 == 1)
            {
                MessageBox.Show("删除成功", "提示");
            }
            else
            {
                MessageBox.Show("删除成功,未找到删除的ID", "提示");
            }

            textBox1.Text = "";
            textBox2.Text = "";
            textBox3.Text = "";
            conn.Close();
            DataDisplay2();


        }
        private void FindID3()
        {
            ArrayList a1 = new ArrayList();


            OleDbDataAdapter oleDapAdapter; //检索与填充数据，一般填充SQL语句  
            ds = new DataSet();
            oleDapAdapter = new OleDbDataAdapter("select * from hjia3", conn3);
            oleDapAdapter.Fill(ds);
            int a2 = ds.Tables[0].Rows.Count;
            hj3row = a2;
            int inserta3 = 0;
            int[] arry1 = new int[a2];
            for (int j = 0; j < ds.Tables[0].Rows.Count; j++)
            {
                string ids = (ds.Tables[0].Rows[j]["ID"].ToString());//需要转成String类型  
                int idi = Convert.ToInt32(ids);
                arry1[j] = idi;
                // Console.Write(idi);

                // (i != Convert.ToInt32(ids))                  
                //   Console.WriteLine(ids); 
            }
            ds.Reset();
            Console.WriteLine();
            //for (int i = 0; i < arry1.Length; i++)
            //{
            //    Console.Write(arry1[i]); 
            //}
            //Console.WriteLine();
            Array.Sort(arry1);
            //for (int i = 0; i < arry1.Length; i++)
            //{
            //    Console.Write(arry1[i]);
            //}
            Console.WriteLine();

            //12345789101112131520

            int x = 1;//标识初值
            for (int i = 0; i < arry1.Length; i++)
            {

                if (arry1[i] != x)
                {
                    // Console.WriteLine(arry1[i]);
                    //inserta3 = arry1[i]-1 ;
                    //if (i >= 1)
                    //{
                    //    textBox1.Text = Convert.ToString(arry1[i - 1] + 1);
                    //    break;
                    //}
                    //else
                    //{
                    //    textBox1.Text = Convert.ToString(arry1[i] - 1);
                    //    break;
                    //}

                    textBox1.Text = Convert.ToString(arry1[i] - 1);
                    break;
                }
                else if (x == a2)
                {
                    textBox1.Text = Convert.ToString(a2 + 1);
                    break;
                }
                x++;//增量
            }
            Console.WriteLine(inserta3);
        }
        private void deledatID3()
        {
            if (textBox1.Text == "")
            {
                MessageBox.Show("ID号项必须填写！ ", "提示");
                return;
            }


            string txt2 = "Delete From hjia3 Where ID = " + textBox1.Text;

            conn = new OleDbConnection(conn3);
            conn.Open();
            ocomd = new OleDbCommand();
            ocomd.CommandText = txt2;
            ocomd.Connection = conn;
            //ocomd.ExecuteNonQuery();
            int a3 = ocomd.ExecuteNonQuery();
            if (a3 == 1)
            {
                MessageBox.Show("删除成功", "提示");
            }
            else
            {
                MessageBox.Show("删除成功,未找到删除的ID", "提示");
            }

            textBox1.Text = "";
            textBox2.Text = "";
            textBox3.Text = "";
            conn.Close();
            DataDisplay3();


        }
        private void FindID4()
        {
            ArrayList a1 = new ArrayList();


            OleDbDataAdapter oleDapAdapter; //检索与填充数据，一般填充SQL语句  
            ds = new DataSet();
            oleDapAdapter = new OleDbDataAdapter("select * from hjia4", conn4);
            oleDapAdapter.Fill(ds);
            int a2 = ds.Tables[0].Rows.Count;
            hj4row = a2;
            int inserta3 = 0;
            int[] arry1 = new int[a2];
            for (int j = 0; j < ds.Tables[0].Rows.Count; j++)
            {
                string ids = (ds.Tables[0].Rows[j]["ID"].ToString());//需要转成String类型  
                int idi = Convert.ToInt32(ids);
                arry1[j] = idi;
                // Console.Write(idi);

                // (i != Convert.ToInt32(ids))                  
                //   Console.WriteLine(ids); 
            }
            ds.Reset();
            Console.WriteLine();
            //for (int i = 0; i < arry1.Length; i++)
            //{
            //    Console.Write(arry1[i]); 
            //}
            //Console.WriteLine();
            Array.Sort(arry1);
            //for (int i = 0; i < arry1.Length; i++)
            //{
            //    Console.Write(arry1[i]);
            //}
            Console.WriteLine();

            //12345789101112131520

            int x = 1;//标识初值
            for (int i = 0; i < arry1.Length; i++)
            {

                if (arry1[i] != x)
                {
                    // Console.WriteLine(arry1[i]);
                    //inserta3 = arry1[i]-1 ;
                    //if (i >= 1)
                    //{
                    //    textBox1.Text = Convert.ToString(arry1[i - 1] + 1);
                    //    break;
                    //}
                    //else
                    //{
                    //    textBox1.Text = Convert.ToString(arry1[i] - 1);
                    //    break;
                    //}

                    textBox1.Text = Convert.ToString(arry1[i] - 1);
                    break;
                }
                else if (x == a2)
                {
                    textBox1.Text = Convert.ToString(a2 + 1);
                    break;
                }
                x++;//增量
            }
            Console.WriteLine(inserta3);
        }
        private void deledatID4()
        {
            if (textBox1.Text == "")
            {
                MessageBox.Show("ID号项必须填写！ ", "提示");
                return;
            }


            string txt2 = "Delete From hjia4 Where ID = " + textBox1.Text;

            conn = new OleDbConnection(conn4);
            conn.Open();
            ocomd = new OleDbCommand();
            ocomd.CommandText = txt2;
            ocomd.Connection = conn;
            //ocomd.ExecuteNonQuery();
            int a3 = ocomd.ExecuteNonQuery();
            if (a3 == 1)
            {
                MessageBox.Show("删除成功", "提示");
            }
            else
            {
                MessageBox.Show("删除成功,未找到删除的ID", "提示");
            }

            textBox1.Text = "";
            textBox2.Text = "";
            textBox3.Text = "";
            conn.Close();
            DataDisplay4();


        }

        private void button4_Click(object sender, EventArgs e)
        {
            
                sendPLCdate();
                       
        }
        private void sendPLCdate()
        {
            Form1.Sendmsg = textBox1.Text;
            Form1.Sendbtn = "1";
        }



        private void outproduct()
        {
            int a1 = 0;
            if (a1 == 0)
            {
                try
                {
                    OleDbDataAdapter oleDapAdapter; //检索与填充数据，一般填充SQL语句  
                    ds = new DataSet();
                    oleDapAdapter = new OleDbDataAdapter("select * from hjia1", conn1);
                    oleDapAdapter.Fill(ds);

                    for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
                    {

                        //   Console.WriteLine(ds.Tables[0].Rows[i]["ID"].ToString());         
                        //  Console.WriteLine(ds.Tables[0].Rows[i]["条码1"].ToString());      
                        //  Console.WriteLine(ds.Tables[0].Rows[i]["条码2"].ToString());
                        string str1 = ds.Tables[0].Rows[i]["ID"].ToString();
                        string str2 = ds.Tables[0].Rows[i]["条码1"].ToString();
                        string str3 = ds.Tables[0].Rows[i]["条码2"].ToString();

                        if ((str2 == textBox2.Text) || (str3 == textBox3.Text))
                        {
                            textBox1.Text = str1;
                            textBox5.Text = str1;
                            textBox4.Text = "1";
                            a1 = 5;
                            textBox2.Text = "";
                            textBox3.Text = "";
                            break;
                        }
                        if (a1==0)
                        {
                            a1 = 1;
                        }

                    }
                }
                catch { }

            }

            if (a1 == 1)
            {
                try
                {
                    OleDbDataAdapter oleDapAdapter; //检索与填充数据，一般填充SQL语句  
                    ds = new DataSet();
                    oleDapAdapter = new OleDbDataAdapter("select * from hjia2", conn2);
                    oleDapAdapter.Fill(ds);

                    for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
                    {
                        //   Console.WriteLine(ds.Tables[0].Rows[i]["ID"].ToString());         
                        //  Console.WriteLine(ds.Tables[0].Rows[i]["条码1"].ToString());      
                        //  Console.WriteLine(ds.Tables[0].Rows[i]["条码2"].ToString());
                        string str1 = ds.Tables[0].Rows[i]["ID"].ToString();
                        string str2 = ds.Tables[0].Rows[i]["条码1"].ToString();
                        string str3 = ds.Tables[0].Rows[i]["条码2"].ToString();

                        if ((str2 == textBox2.Text) || (str3 == textBox3.Text))
                        {
                            textBox1.Text = str1;
                            textBox5.Text = str1;
                            textBox4.Text = "2";
                            a1 = 5;
                            textBox2.Text = "";
                            textBox3.Text = "";
                            break;
                        }
                        if (a1 == 1)
                        {
                            a1 = 2;
                        }

                    }
                }
                catch { }

            }


            if (a1 == 2)
            {
                try
                {
                    OleDbDataAdapter oleDapAdapter; //检索与填充数据，一般填充SQL语句  
                    ds = new DataSet();
                    oleDapAdapter = new OleDbDataAdapter("select * from hjia3", conn3);
                    oleDapAdapter.Fill(ds);

                    for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
                    {
                        //   Console.WriteLine(ds.Tables[0].Rows[i]["ID"].ToString());         
                        //  Console.WriteLine(ds.Tables[0].Rows[i]["条码1"].ToString());      
                        //  Console.WriteLine(ds.Tables[0].Rows[i]["条码2"].ToString());
                        string str1 = ds.Tables[0].Rows[i]["ID"].ToString();
                        string str2 = ds.Tables[0].Rows[i]["条码1"].ToString();
                        string str3 = ds.Tables[0].Rows[i]["条码2"].ToString();

                        if ((str2 == textBox2.Text) || (str3 == textBox3.Text))
                        {
                            textBox1.Text = str1;
                            textBox5.Text = str1;
                            textBox4.Text = "3";
                            a1 = 5;
                            textBox2.Text = "";
                            textBox3.Text = "";
                            break;
                        }
                        if (a1 == 2)
                        {
                            a1 = 3;
                        }

                    }
                }
                catch { }

            }

            if (a1 == 3)
            {
                try
                {
                    OleDbDataAdapter oleDapAdapter; //检索与填充数据，一般填充SQL语句  
                    ds = new DataSet();
                    oleDapAdapter = new OleDbDataAdapter("select * from hjia4", conn4);
                    oleDapAdapter.Fill(ds);

                    for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
                    {
                        //   Console.WriteLine(ds.Tables[0].Rows[i]["ID"].ToString());         
                        //  Console.WriteLine(ds.Tables[0].Rows[i]["条码1"].ToString());      
                        //  Console.WriteLine(ds.Tables[0].Rows[i]["条码2"].ToString());
                        string str1 = ds.Tables[0].Rows[i]["ID"].ToString();
                        string str2 = ds.Tables[0].Rows[i]["条码1"].ToString();
                        string str3 = ds.Tables[0].Rows[i]["条码2"].ToString();

                        if ((str2 == textBox2.Text) || (str3 == textBox3.Text))
                        {
                            textBox1.Text = str1;
                            textBox5.Text = str1;
                            textBox4.Text = "4";
                            a1 = 5;
                            textBox2.Text = "";
                            textBox3.Text = "";
                            break;
                        }
                   
                    }
                }
                catch { }

            }
            
          if (a1!=5)
          {
              MessageBox.Show("未找到所查询的条码 请重新输入", "提示");
          }

        }

        private void button5_Click(object sender, EventArgs e)
        {
            outproduct();
        }

       
    }
}

fancheeryup
关注
使用C#对数据库Access的增、删、改、查
Boooooots的博客
04-26 1286
前言： 程序的运行过程，本质上是对数据流的处理，包含数据的存储和读取，其中存储和读取是基于数据结构，而怎么存储、怎么读取则基于算法，也就是所谓的“程序 = 数据结构 + 算法”。 不论是web开发，还是桌面应用开发，都会涉及到数据的处理和数据的存储问题。对于数据的存储和管理，数据库是不二之选。 1 数据库 数据库，简而言之可视为电子化的文件柜——存储电子文件的处所，用户可以对文件中的数据进行新增、...
C# Access数据库操作类 连接,查询,插入,删除,更新
05-16
提供了一个用C#语言实现的Access数据库操作类，实现了对Access数据库(无访问密码或者设置了访问密码)的链接、查询、插入、删除、更新等功能，调用方便，操作简单，附有使用说明。如有问题，请发送邮件至gaocongly@126.com咨询讨论
C#access数据库查询操作(二)
仓鼠玉米的博客
04-21 4501
在前面介绍了access数据库的相关操作，这里介绍一下查询条件为变量的情况，比如用户从DataTimePicker控件中获取时间，传入时间，查询某一些时间段的数据 当查询条件为变量时，SQL语言其实与常量一样，关键是格式问题，说具体点就是当数据库字段为数字或者文本时引号的摆放与拼接问题, 一.输入查询变量 1.数据字段为数字类型 查一个值 int num1 = 1; oleD
C#编程学习16：清除access中某个数据表的所有数据并重置ID从1自增
m1m2m3mmm的博客
05-13 3300
删除数据库中的表格所有数据，但是保留表的原始结构；并将其ID重置为从1开始
C#:Access数据库的连接、读取，字段的增加、删除、更新、查询操作
Prince的博客
02-10 5432
c#窗体程序对Access数据库的增删改查，其他数据库可类似使用 准备工作： 窗体： 代码段 using System; using System.Data; using System.Windows.Forms; using System.Data.OleDb; //一、打开数据库： string Con = @"Provider=Microsoft.Jet.OleDb.4.0;Data Source=C:\Users\87627\Desktop\Database1.mdb";//..
C#操作Access数据库
小寒请指教
04-02 5094
首先把Access数据库文件放在项目的/bin/Debug的文件夹里面 下面是我Access文件中的两张测试表：Table1，Table2 DAL文件代码 using System; using System.Data; using System.Data.OleDb; namespace access { /// <summary> /// 操作Access数据库...
C# Access 读写数据库
热门推荐
寒博K
06-06 2万+
网上的一些教程都不太友好，对于刚入门的新手来说晦涩难懂。自己记下自己学习过程。一、关于OLEDB没有相应的数据提供者的数据库经常要通过OLEDB或ODBC来使用，例如Microsoft Access就可以通过OLEDB来访问。二、怎么使用OLEDB1.连接字符串  简单的说，连接字符串就像是一把钥匙，如果C#想和数据库进行连接，得有一把钥匙，不然门都进不去。下面介绍怎么获取Access得连接字符串...
C#连接Access数据库
晓琴儿
05-25 2872
一、新建Access数据库文件 注意：*.mdb是早期的Access数据库文件，*.accdb是后期的Access数据库文件。 二、用Visual Studio 2013测试其可连接性 执行完以上步骤，证明你新建的数据库文件可用，可连接。 三、代码演示连接Access using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; usin.
C#操作Access数据库 增删改查
u011555996的博客
11-18 2989
本文以ADOX操作Access 1、在C#中新建AccessClass.cs文件，内容如下 1 using System; 2 using System.Collections.Generic; 3 using System.Linq; 4 using System.Text; 5 using System.Collections; 6 using Syste...
c# winform datagridview联合access数据库 查询 删除 添加 生成报表
06-24
在C# WinForm应用开发中，使用DataGridView控件与Access数据库进行交互是常见的数据管理方式。这个"datagridview access 数据库 c#"的示例（"ComputerManage"项目）旨在教你如何实现查询、删除、添加数据以及生成...
基于C#的WFP的酒店管理系统(源码+access数据库).rar
01-17
开发环境 ：VS2013/VS2017 WPF C# ACCESS 采用wpf进行开发的酒店管理系统，界面相当美观，功能齐全 菜单功能 1、预订登记：可选择入住时间、离店时间、所在城市、证件类型，保存、删除、查询、返回 2、住宿结算：...
access数据库查询编辑器
11-18
Access数据库查询编辑器是一款专为Microsoft Access数据库设计的高效工具，它提供了全面的数据管理功能，包括数据编辑、修改、新增和查看等操作。这款编辑器以其简洁的界面和易用性受到用户的青睐，使得对Access...
c# mysql 表增加字段,C# Access数据库SQLSERVER数据库中添加表的列、修改主键源码
weixin_34851528的博客
03-12 443
如果ConnectionStringSettings不能用则在“引用”中添加System.Configurationusing System.Configuration;using System.Data.OleDb;public void AddCol(){ConnectionStringSettings settings = ConfigurationManager.ConnectionStr...
c# 连接Access数据库，以及增删改查操作（OleDb）
qq_41373415的博客
03-19 1635
提示：文章写完后，目录可以自动生成，如何生成可参考右边的帮助文档 文章目录前言一、简易连接数据库（未封装）二、使用步骤1.引入库2.读入数据总结 前言 学习使用的记录 一、简易连接数据库（未封装） string url = Application.StartupPath + "\\database\\DatabaseBook.mdb"; //数据库路径 string password = ""; //密码 OleDbConnection conn =
C#向ACCESS数据库插入空值
lovejesuslove的博客
03-21 400
整了半天才整出来： string sql=string.format("insert into table values({0})","null");   而取出来的时候又是这样：    //初始化更新窗体里面的内容         public string InitForm(DataTable dt,string str)         {             return dt.Row
C#编程：VSTO在Excel工作表中输出List数据
最新发布
fsyuheduo的博客
11-01 203
==标题==C#编程：VSTO在Excel工作表中输出List数据==正文==一、问题：我想把C#中的List<T>输出到Excel工作表中二、思路方法：（1）用程序创建一个List<T>（2）输出到当前工作表三、代码：Excel.Application xlsApp = Globals.ThisAddIn.Application; Excel.Workbook wbk =...
C# 中使用Topshelf 注意事项
weixin_43542114的博客
10-29 809
在决定使用还是时，您应充分考虑服务的功能需求，安全性要求以及对系统资源的访问需求。更适合需要高权限的服务，而则在需要增强安全性的情况下更加合适。当设计和部署服务时，这两种配置方式可能会显著影响服务的功能与安全性。综上所述，如果是本地自己安装服务 最好使用 RunAsLocalSystem 方法比较合适，给自己托管，安装的服务最大权限。
C#实现word和pdf格式互转
m0_74455866的博客
10-29 494
版权所有，使用请留言声明！破解的Spire.pdf。1、word转pdf。
C# WPF开发的酒店管理系统源码及ACCESS数据库教程
资源摘要信息:"本资源是关于使用C#开发的基于WPF (Windows Presentation Foundation)技术的酒店管理系统，该系统后端使用了Microsoft Access数据库。系统在Visual Studio 2013或Visual Studio 2017的开发环境中构建...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值