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(); }