how to direct login into database in case of crystal report

• pulak_mca

  Mr or Mrs. 500

  Points: 505

  More actions

  August 6, 2008 at 12:21 am

  #122802

  I want to display some record in a crystal report from database but before display the crystal report everytime i have to login .how can i directly login to database. i m using c#.net

  here is my code:

  SqlConnection conn;

  SqlCommand cmd;

  SqlDataAdapter adap;

  UserDataReader udr = new UserDataReader();

  protected SqlConnection myConnection = new SqlConnection("Server=localhost; Database=arun;User ID=sa;Password=*****;");

  protected SqlDataAdapter DAMASTER = new SqlDataAdapter();

  protected DataSet DSMaster = new DataSet();

  CrystalReport rptacc;

  public string majhead;

  public string subhead;

  protected void Page_Load(object sender, EventArgs e)

  {

  if (Session["officetype"].ToString().Trim().Length < 1)

  {

  Response.Redirect("WorkExperience.aspx");

  }

  if (Session["officename"].ToString().Trim().Length< 1)

  {

  Response.Redirect("WorkExperience.aspx");

  }

  if (Convert.ToInt32(Session["contractor"].ToString().Trim()) < 1)

  {

  Response.Redirect("WorkExperience.aspx");

  }

  string officetype =(string)Session["officetype"];

  string officename = (string)Session["officename"];

  int contractor = Convert.ToInt32(Session["contractor"]);

  DAMASTER = new SqlDataAdapter("select * from ContractorWorkExp", myConnection);

  DSMaster = new DataSet();

  DAMASTER.Fill(DSMaster, "Table");

  if (DSMaster.Tables[0].Rows.Count > 0)

  {

  string cond = "contractorid='" + contractor + "'";

  udr = trm.get_db_table_colVal("ContractorWorkExp", "contractorid", cond,udr);

  if (udr.read())

  {

  rptacc = new CrystalReport();

  string mypath = System.AppDomain.CurrentDomain.BaseDirectory;

  mypath = mypath + "CrystalReport.rpt";

  rptacc.str = mypath;

  rptacc.SetDataSource(DSMaster);

  rptacc.DataDefinition.GroupSelectionFormula = "{ContractorWorkExp.contractorid} = " + contractor + "";

  CrystalReportViewer1.ReportSource = rptacc;

  CrystalReportViewer1.Visible = true;

  CrystalReportViewer1.HasSearchButton = false;

  CrystalReportViewer1.HasViewList = false;

  CrystalReportViewer1.Visible = true;

  }

  else

  {

  lblerror.Visible = true;

  lblerror.Text = "No Record Found!";

  }

  }

  else

  {

  lblerror.Visible = true;

  lblerror.Text = "No Record Found!";

  }

  }

  }