private void btnshow_Click(object sender, EventArgs e) { SqlConnection conn = new SqlConnection(ConfigurationSettings.AppSettings ["ConnectionString"]); conn.ConnectionString = "Data Source=USER-PC;Initial Catalog=MUCGPROJECT;User ID=sa;Password=mike"; SqlCommand cmd = new SqlCommand(string.Format("SELECT * FROM tblCollectorsRegistration WHERE Collectorid='{0}'", this.txtCollectorid.Text), conn); conn.Open(); SqlDataReader dr = cmd.ExecuteReader(); if (dr.HasRows) { conn.Close(); DataTable tbl = new DataTable(); conn.Open(); SqlDataAdapter adp = new SqlDataAdapter("SELECT Collectorid, Title, Surname, Firstname, Middlename, Gender, Dateofbirth, Nationality, Religion, Maritalstatus, Spousename, Telephone, Postaladdress, Residentialaddress, Hometownaddress from tblCollectorsRegistration WHERE Collectorid = '" + this.txtCollectorid.Text + "'", conn); adp.Fill(tbl); rptCollectorindividual objRpt = new rptCollectorindividual(); objRpt.Database.Tables[0].SetDataSource(tbl); crystalReportViewer1.ReportSource = objRpt; crystalReportViewer1.Refresh(); } else { // Id already present MessageBox.Show("The Collector ID does not Exist"); return; } }
did u added using these three statement as headers using CrystalDecisions.CrystalReports.Engine; using CrystalDecisions.Shared; using CrystalDecisions.Windows.Forms;
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)