private void sarchButton_Click(object sender, EventArgs e) { string partsNumbe; partsNumbe = sarchPartsNumberTextBox.Text; PartsInformationClass parts=null; List<PartsInformationClass> partses = new List<PartsInformationClass>(); string connectionString = @"server=DUET-559FE4FA51\SQLEXPRESS;integrated security = SSPI; database = VehicleInformationDB;"; SqlConnection connection = new SqlConnection(connectionString); connection.Open(); string queryString = "SELECT * FROM partsInformationTable WHERE partsNumber='"+partsNumbe+"'"; SqlCommand command = new SqlCommand(queryString, connection); SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { parts = new PartsInformationClass(); parts.PartsName = (reader["partsName"]).ToString(); partsNameTextBox.Text = (reader["partsName"]).ToString(); parts.PartsNumber = (reader["partsNumber"]).ToString(); partsNumberTextBox.Text = (reader["partsNumber"]).ToString(); parts.PartsPrice = (reader["partsPrice"]).ToString(); partsPriceTextBox.Text = (reader["partsPrice"]).ToString(); parts.PartsQuentity = (reader["partsQuentity"]).ToString(); partsQuentityTextBox.Text = (reader["partsQuentity"]).ToString(); } MessageBox.Show("PrtsName=" + parts.PartsName + "\npartsNumber" + parts.PartsNumber + "\npartsPrice" + parts.PartsPrice + "\npartsQuentity" + parts.PartsQuentity); connection.Close(); }
private void saveButton_Click(object sender, EventArgs e) { PartsInformationClass partsObj = new PartsInformationClass(); partsObj.PartsName = partsNameTextBox.Text; partsObj.PartsNumber = partsNumberTextBox.Text; partsObj.PartsPrice = partsPriceTextBox.Text; partsObj.PartsQuentity = partsQuentityTextBox.Text; PartsInformationGetway partObg = new PartsInformationGetway(); partObg.storePartsInformation(partsObj); MessageBox.Show("Information Save"); }