prochotap

In this case I display values into datagridview from Projects table which it has only 2 columns: PROJECT_NAME VARCHAR ID INT // Which is hidden in datagridview, and as AUTOINCREMENT I have already done with editing values in this table and it works fine: `private void dataGridView4_CellEndEdit(object sender, DataGridViewCellEventArgs e) …

In mysql database i created "leave" table: CREATE TABLE `leave` ( `ID_LEAVE` int(11) NOT NULL, `ID_WORKER` int(11) NOT NULL, `BEGIN_DATE` datetime DEFAULT NULL, `END_DATE` datetime DEFAULT NULL ); INSERT INTO `leave` (`ID_LEAVE`, `ID_WORKER`, `BEGIN_DATE`, `END_DATE`) VALUES (1, 26, '2019-03-19 07:00:00', '2019-03-19 15:00:00'), (6, 26, '2019-03-22 07:00:00', '2019-03-25 15:00:00'); "Sickness" table: …

In desktop application used in technologies like C#, .Net and MySQL I import data from large file (which is about 37 MB) to datagridview. The table from Excel file is in below:  After loading data from Excel to datagridview I'm inserting that data to MySQL database. Later when I …

In MySQL Database i have a worker who has 1 year of leave days (about 360 days): +--------+---------+---------+-------------+---------+-----------+ |ID_LEAVE|ID_WORKER| BEGIN_DATE | END_DATE | +--------+---------+---------+---------+------------+------------+ | 4 | 26 |2019-03-19 07:00:00 |2020-03-19 15:00:00 | +--------+---------+---------+----------------------+------------+ When i I'm going to run below Mysql Command which calculates leave time without weekends and …

In mysql database i created "leave" table: CREATE TABLE `leave` ( `ID_LEAVE` int(11) NOT NULL, `ID_WORKER` int(11) NOT NULL, `BEGIN_DATE` datetime DEFAULT NULL, `END_DATE` datetime DEFAULT NULL ) INSERT INTO `leave` (`ID_LEAVE`, `ID_WORKER`, `BEGIN_DATE`, `END_DATE`) VALUES (3, 26, '2019-03-20 07:00:00', '2019-03-21 15:00:00'), (4, 22, '2019-03-20 07:00:00', '2019-03-20 15:00:00'); "Workers" table: …