title: How to generate crystal report in ASP.net C# using visual studio 2012?
body: <p>I just recently installed Visual Studio 2012, everything's working good with 2010 with my Crystal report but when I migrated the code to 2012 I can't display anything. Can you pls check if there is something I'm missing with this code:</p>
  
  <pre><code>protected void Page_Load(object sender, EventArgs e)
          {
              SqlConnection cnn;
              string connectionString = null;
              string sql = null;
              connectionString = "data source=server; initial catalog=DBO;user id=sa; password= passw0rd";
              cnn = new SqlConnection(connectionString);
              cnn.Open();
              sql = "select BadgeNo as DataColumn1,Name as DataColumn2, Section as DataColumn3 from Safety where ID = '24'";
              SqlDataAdapter dscmd = new SqlDataAdapter(sql, cnn);
              cnn.Close();
  
              DataSet1 ds = new DataSet1();
              dscmd.Fill(ds, "DataTable1");
  
              ReportobjRpt = new Report1 ();
              objRpt.SetDataSource(ds.Tables[0]);
              CrystalReportViewer1.ReportSource = objRpt;
              CrystalReportViewer1.RefreshReport();
          }
  </code></pre>
  
  <p>I am using a dataset to transfer data from the SQL server to crystal report. Please help. Thank you.</p>