private void crystalReportViewer1_Load(object sender, EventArgs e)
{
FormAO16 xform = (FormAO16)this.Owner;
SqlConnectionStringBuilder builder = new SqlConnectionStringBuilder(ConfigurationManager.ConnectionStrings["ccis"].ConnectionString);
crystalReportViewer1.LogOnInfo[0].ConnectionInfo.ServerName = builder.DataSource;
crystalReportViewer1.LogOnInfo[0].ConnectionInfo.DatabaseName = "ccis";
crystalReportViewer1.LogOnInfo[0].ConnectionInfo.UserID = "ccis";
crystalReportViewer1.LogOnInfo[0].ConnectionInfo.Password = "******";
CrystalReportEvaluation1.SetParameterValue("appno", xform.textBoxApplicationNo.Text);
CrystalReportEvaluation1.SetParameterValue("APPNO", xform.textBoxApplicationNo.Text, "Materials");
CrystalReportEvaluation1.SetParameterValue("APPNO", xform.textBoxApplicationNo.Text, "TechReq");
//using (SqlConnection cnn = new SqlConnection(ConfigurationManager.ConnectionStrings["ccis"].ConnectionString))
//{
// cnn.Open();
// DataTable dt = new DataTable();
// SqlDataAdapter da = new SqlDataAdapter("select *,stuff ((select ' and ' + [description] from procurement where procurement.ApplicationNo=Application.applicationNo for xml path('')),1,5,'') as [procurements] from Application", cnn);
// da.Fill(dt);
// //crystalReportViewer1.ReportSource = dt;
//}
crystalReportViewer1.Refresh();
}
private void SetParameter()
{
FormAO16 form = (FormAO16)this.Owner;
crystalReportViewer2.LogOnInfo[0].ConnectionInfo.ServerName = ".\\sqlexpress";
crystalReportViewer2.LogOnInfo[0].ConnectionInfo.DatabaseName = "ccis";
crystalReportViewer2.LogOnInfo[0].ConnectionInfo.UserID = "ccis";
crystalReportViewer2.LogOnInfo[0].ConnectionInfo.Password = "******";
CrystalReportClearance2.SetParameterValue("appno", form.textBoxApplicationNo.Text);
crystalReportViewer2.Refresh();
}
private void crystalReportViewer2_Load(object sender, EventArgs e)
{
FormAO16 form = (FormAO16)this.Owner;
SqlConnectionStringBuilder builder = new SqlConnectionStringBuilder(ConfigurationManager.ConnectionStrings["ccis"].ConnectionString);
crystalReportViewerClearance.LogOnInfo[0].ConnectionInfo.ServerName = builder.DataSource;
crystalReportViewerClearance.LogOnInfo[0].ConnectionInfo.DatabaseName = "ccis";
crystalReportViewerClearance.LogOnInfo[0].ConnectionInfo.UserID = "ccis";
crystalReportViewerClearance.LogOnInfo[0].ConnectionInfo.Password = "******";
CrystalReportClearance3.SetParameterValue("appno", form.textBoxApplicationNo.Text);
crystalReportViewerClearance.Refresh();
}
private void dataGridView1_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
{
if (e.RowIndex != -1)
{
FormAO16 form = (FormAO16)this.Owner;
form.textBoxAgency.Text = dataGridView1.SelectedRows[0].Cells[0].Value.ToString();
form.textBoxAddress.Text = dataGridView1.SelectedRows[0].Cells[1].Value.ToString();
form.textBoxContact.Text = dataGridView1.SelectedRows[0].Cells[2].Value.ToString();
this.Close();
}
}
private void ReportParameter()
{
FormAO16 xform = (FormAO16)this.Owner;
crystalReportViewer1.LogOnInfo[0].ConnectionInfo.ServerName = ".\\sqlexpress";
crystalReportViewer1.LogOnInfo[0].ConnectionInfo.DatabaseName = "ccis";
crystalReportViewer1.LogOnInfo[0].ConnectionInfo.UserID = "ccis";
crystalReportViewer1.LogOnInfo[0].ConnectionInfo.Password = "******";
CrystalReportEvaluation1.SetParameterValue("appno", xform.textBoxApplicationNo.Text);
CrystalReportEvaluation1.SetParameterValue("APPNO", xform.textBoxApplicationNo.Text, "Materials");
CrystalReportEvaluation1.SetParameterValue("APPNO", xform.textBoxApplicationNo.Text, "TechReq");
crystalReportViewer1.Refresh();
}
