Ejemplo n.º 1
0
        private void button2_Click(object sender, EventArgs e)
        {
            OracleDALLib dal = new OracleDALLib("StrConn");
            DataTable tab = dal.Query("SELECT * FROM dept");

            //DataTable tab = dal.Query("SELECT COPRODUCTION.*,to_char(time,'yyyy-mm-dd hh24:mi:ss') AS TIMES FROM COPRODUCTION");

            dataGridView1.DataSource = tab;
            //dataGridView1.Columns["TIMES"].DefaultCellStyle.Format = "yyyy-MM-dd HH:mm:ss";
        }
Ejemplo n.º 2
0
        private void btnImport_Click(object sender, EventArgs e)
        {
            if (ImportData != null && ImportData.Rows.Count > 0)
            {
                string SqlInsert = "";
                int EffectRows = 0;
                OracleDALLib DALLib = new OracleDALLib("StrConn");
                foreach (DataRow row in ImportData.Rows)
                {
                    SqlInsert = @"INSERT INTO AUSWDATEN VALUES
                        ('" + row["THMID"] + "'," + row["LINIENNR"] + ",'" + row["LINIENNAME"] + "'," + row["STATIONNR"] + ",'" + row["STATIONNAME"] + "','" + row["NAME"] + "','" + row["WERT"] + "',to_date('" + row["TIME"] + "','yyyy-mm-dd hh24:mi:ss'))  ";

                    EffectRows+= DALLib.ExcuteIDU(SqlInsert);
                }
                MessageBox.Show("新增" + EffectRows + "行!");
            }
            else
                MessageBox.Show("数据不能为空!");
        }