Print Page | Close Window

Crystal Report with report

Printed From: Crystal Reports Book
Category: Crystal Reports for Visual Studio 2005 and Newer
Forum Name: Writing Code
Forum Discription: .NET programming API, report integration
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=3591
Printed Date: 17 May 2024 at 8:40pm


Topic: Crystal Report with report
Posted By: yumert
Subject: Crystal Report with report
Date Posted: 03 Jul 2008 at 3:34am
Hello friends;
Csharp with use crystal report.Database use sqlserver.
Crystal Report in click when is your print button  not  view data.Why do not view data?
Sqldatareader with crystal report in multi record list.
Please help me..
Code..
protected void Button1_Click(object sender, EventArgs e)
    {
        string isemrino2 = TextBox1.Text;
        
        SqlConnection baglantim = new SqlConnection("Data Source=***;Database=****;User Id=***;Password=****");
        baglantim.Close();  
    string sorgu = "SELECT po.po5,po.description,po.ponum,po.orderdate,po.vendor,po.po3,po.po6,po.totalcost,companies.phone,companies.address1,longdescription.ldtext from po LEFT OUTER JOIN poline ON po.ponum=poline.ponum LEFT OUTER JOIN companies ON po.vendor =companies.company  LEFT OUTER JOIN longdescription ON po.ldkey=longdescription.ldkey   where po.ponum =@satinalmano";
      
    SqlCommand cmd = new SqlCommand(sorgu,baglantim);
        SqlParameter param = new SqlParameter();
        baglantim.Open();
    
    param.ParameterName = "@satinalmano";
    param.Value = TextBox1.Text;
    cmd.Parameters.Add(param);
    cmd.ExecuteNonQuery();
    
    
    SqlDataAdapter deneme = new SqlDataAdapter(sorgu,baglantim);

    deneme.SelectCommand.Parameters.AddWithValue("@satinalmano", TextBox1.Text);
    DataSet ds = new DataSet();
  deneme.Fill(ds);
  foreach (DataRow row in ds.Tables[0].Rows)
  {

      

      Label1.Text= row["po3"].ToString();

      
  }




Print Page | Close Window