C# (CSharp) DBOperate.Query_ToleranceStandard_AllDat Examples

Example #1

        private void Form_AdvancedFunc_Load(object sender, EventArgs e)
        {
            // 在PersisData加载时就调用数据库函数, 读取最近一次保存的标准公差信息,将其赋值给 B515_Standard_Tolerance

            // 在load中查询tolerance表,获取所有信息的日期,将日期add到listbox中

            Selected_Date = "";
            string[] DataTimes = null;// new string[] { };

            // 数据库查询
            dt_TolInfo = DBOperate_Obj.Query_ToleranceStandard_AllDat();
            int nElem = dt_TolInfo.Rows.Count;

            if (nElem > 0)
            {
                DataTimes = new string[nElem];
                for (int nElemRowIdx = 0; nElemRowIdx < nElem; nElemRowIdx++)
                {
                    DataTimes[nElemRowIdx] = dt_TolInfo.Rows[nElemRowIdx][1].ToString(); // 获取的是时间的值
                }
            }
            this.listBox1.DataSource = DataTimes;
        }