public static SysChar GetSysCharDataByID(string id) { SqlConnection sqlConnection = new SqlConnection(ConnectionAdres); SysChar sysChar = null; SqlCommand nameComand = new SqlCommand($"SELECT * FROM systemCharacteristic WHERE PCID = '{id}';", sqlConnection); sqlConnection.Open(); SqlDataReader reader = nameComand.ExecuteReader(); reader.Read(); if (reader.HasRows) { var processorName = reader.GetString(1); var processorModel = reader.GetString(2); var RAM = reader.GetString(3); var capacity = reader.GetString(4); var operationgSystem = reader.GetString(5); sysChar = new SysChar { processorName = processorName, processorModel = processorModel, RAM = RAM, capacity = capacity, operatingSystem = operationgSystem }; } reader.Close(); sqlConnection.Close(); return(sysChar); }
private void Button_Click_1(object sender, RoutedEventArgs e) { if (pcIDBOX.Text != "") { SysChar sysChar = Querys.GetSysCharDataByID(pcIDBOX.Text); if (sysChar != null) { prcessorFirm.Text = sysChar.processorName; prcessorModel.Text = sysChar.processorModel; RAM.Text = sysChar.RAM; opacty.Text = sysChar.capacity; OS.Text = sysChar.operatingSystem; } } else { errorLabel.Content = "Поле должно быть заполненно"; } }