public void printPreview() { MySqlDataReader _reader = csm.sqlCommand("Select file_name from attachment where attachCode = '" + lblGenRecNo.Text + "'").ExecuteReader(); while (_reader.Read()) { attachment += _reader.GetString("file_name") + ", "; } for (int i = 0; i < tblPenalty.Rows.Count; i++) { section += "<b>" + tblPenalty.Rows[i].Cells[1].Value.ToString() + ": </b> "" + tblPenalty.Rows[i].Cells[2].Value.ToString() + ""<br>"; paragraph += tblPenalty.Rows[i].Cells[2].Value.ToString() + "\n"; } fillRecipients(lblGenRecNo.Text); using (printPreview pp = new printPreview(bsRecepients.DataSource as List <recepients>)) { pp.retrieveNarrativeData(fillNarrativeValue()); pp.ShowDialog(); } attachment = ""; section = ""; paragraph = ""; }
public void printPreview() { MySqlDataReader _reader = csm.sqlCommand("Select file_name from attachment where attachCode = '" + txtMemoNo.Text + "'").ExecuteReader(); while (_reader.Read()) { attachment += _reader.GetString("file_name") + ", "; } for (int i = 0; i < tblPenalty.Rows.Count; i++) { thisviolation += tblPenalty.Rows[i].Cells[1].Value.ToString() + "\n"; } using (printPreview pp = new printPreview(bsReceipients.DataSource as List <recepients>)) { pp.retrieveNarrativeData(fillManagementDecisionValue()); pp.ShowDialog(); } }