public void InsertinDB() { MSSQLConnector connector = new MSSQLConnector(); connector.OpenConnect(); string rqst = "INSERT INTO Регионы (Название) VALUES ('" + this.Name + "')"; SqlCommand command2 = new SqlCommand(rqst, connector.conn); command2.ExecuteNonQuery(); connector.CloseConnect(); }
public void InsertinDB() { MSSQLConnector connector = new MSSQLConnector(); connector.OpenConnect(); string rqst = @"INSERT INTO Страны (Название, [Код страны], Площадь, Население, Регион, Столица) VALUES " + "('" + this.Name + "','" + this.Code + "'," + this.Area + "," + this.Population + "," + this.Reg.Id + "," + this.Cap.Id + ")"; this.Show(); SqlCommand command2 = new SqlCommand(rqst, connector.conn); command2.ExecuteNonQuery(); connector.CloseConnect(); }
//ISQLUPDATE Interface Implementation public void UpdateRecord() { MSSQLConnector connector = new MSSQLConnector(); connector.OpenConnect(); string rqst = @"UPDATE Страны SET Название = '" + this.Name + "', [Код страны]= '" + this.Code + "', Площадь=" + this.Area + ",Население=" + this.Population + ", Регион =" + this.Reg.Id + ", Столица = " + this.Cap.Id + " WHERE id=" + this.Id;; SqlCommand command = new SqlCommand(rqst, connector.conn); command.ExecuteNonQuery(); System.Windows.Forms.MessageBox.Show(this.Name + " data was updated"); connector.CloseConnect(); }
public ArrayList FindIfExist() { MSSQLConnector connector = new MSSQLConnector(); connector.OpenConnect(); string rqst = "Select * from Города Where Название = '" + this.Name + "'"; SqlCommand command1 = new SqlCommand(rqst, connector.conn); SqlDataReader dr = command1.ExecuteReader(); ArrayList tempArr = TransformResult(dr); connector.CloseConnect(); if (tempArr.Count == 0) { tempArr.Add(new Models.Capital()); } return(tempArr); }