static void Main(string[] args) { //string connectionString = // @" Data Source=(localdb)\MSSQLLocalDB; // Initial Catalog=DataEmployees_22_08_2019; // Integrated Security=True; // Connect Timeout=30; // Encrypt=False; // TrustServerCertificate=False; // ApplicationIntent=ReadWrite; // MultiSubnetFailover=False"; string connectionString = @" Data Source=andrey-kotelnik\sqlexpress; Initial Catalog=EmployeesDataMSSQL; Integrated Security=True"; ConnectionString.Text = connectionString; EmployeesDAL employeesDAL = new EmployeesDAL(); DepartmentsDAL departmentsDAL = new DepartmentsDAL(); try { ReadDataFromBase(employeesDAL); employeesDAL.OpenConnection(); //SqlDataAdapter dataAdapter = employeesDAL.GetDataAdapter(); ////SqlParameter[] parameters = new SqlParameter[cmdTest.Parameters.Count]; ////cmdTest.Parameters.CopyTo(parameters, 0); ////cmdTest.Parameters.Remove(parameters[0]); ////parameters[0].Value = 58; ////cmdTest.Parameters.Add(parameters[0]); ////cmdTest.ExecuteNonQuery(); ////employeesDAL.CloseConnection(); //DataTable table = new DataTable(); //dataAdapter.Fill(table); //DataRow rowUpd = table.Rows[0]; //var res = rowUpd.ItemArray.GetValue(1); //var f = rowUpd.ItemArray.IsReadOnly; //rowUpd.ItemArray[1] = "ИИИИИИИИ"; //var arr = rowUpd.ItemArray; //arr[1] = "Иваныч2"; //rowUpd.ItemArray = arr; //res = rowUpd.ItemArray.GetValue(1); //DataRow row = table.NewRow(); //row[1] = "Andr2"; //row[2] = "Andr2"; //row[3] = 35; //table.Rows.Add(row); //table.AcceptChanges(); //WriteLine($"The number of rows successfully updated: {dataAdapter.Update(table)}"); //////employeesDAL.OpenConnection(); var empList = Employee.GetEmployees(); foreach (var item in empList) { employeesDAL.Insert(item.Name, item.Surname, item.Age, item.DepID); } //WriteLine($"Номер вставленной строки: {employeesDAL.Insert("Й", "Й", 10, null)}"); WriteLine($"Количество строк в таблице: {employeesDAL.CountRows}"); //employeesDAL.Delete(25); //employeesDAL.Update(8, "8", "8", 8, 1); SqlDataReader reader; reader = employeesDAL.Select(); WriteLine("Объект чтения данных --> " + reader.GetType().Name); while (reader.Read()) { for (int i = 0; i < reader.FieldCount; i++) { Write($"|{reader[i],15}"); } WriteLine(); } } catch (SqlException ex) { WriteLine(ex.Message); } finally { employeesDAL.CloseConnection(); } //try //{ // departmentsDAL.OpenConnection(); // WriteLine($"Номер вставленной строки: {departmentsDAL.Insert("qwerty")}"); // WriteLine($"Количество строк в таблице: {departmentsDAL.CountRows}"); // departmentsDAL.Delete(3); // departmentsDAL.Update(1, "FFFFFF"); // SqlDataReader reader; // reader = departmentsDAL.Select(); // WriteLine("Объект чтения данных --> " + reader.GetType().Name); // while (reader.Read()) // { // for (int i = 0; i < reader.FieldCount; i++) // { // Write($"|{reader[i],15}"); // } // WriteLine(); // } //} //catch (SqlException ex) //{ // WriteLine(ex.Message); //} //finally //{ // departmentsDAL.CloseConnection(); //} //SqlDataAdapter dataAdapterEmp = employeesDAL.GetDataAdapter(); //DataTable dataEmp = new DataTable("Employees"); //SqlDataAdapter dataAdapterDep = departmentsDAL.GetDataAdapter(); //DataTable dataDep = new DataTable("Departments"); //try //{ // dataAdapterEmp.Fill(dataEmp); //} //catch (SqlException ex) //{ // WriteLine(ex.Message); //} //try //{ // dataAdapterDep.Fill(dataDep); //} //catch (SqlException ex) //{ // WriteLine(ex.Message); //} //WriteLine($"Столбцы в Emp: { dataEmp.Columns.Count}"); //WriteLine($"Столбцы в Dep: { dataDep.Columns.Count}"); }