Crystal Report Example

In Aspx file

  <CR:CrystalReportViewer ID="CrystalReportViewer1" runat="server" AutoDataBind="true" PrintMode="ActiveX" DisplayGroupTree="False"></CR:CrystalReportViewer>

In Aspx.cs  file

ReportDocument rptDocument = null;

protected void Page_Load(object sender, EventArgs e)

    {

        if (!IsPostBack)

        {

            rptDocument = new ReportDocument();

            Session["rptDocument"] = rptDocument;

        }

        else

        {

            rptDocument = (ReportDocument)Session["rptDocument"];

            if (rptDocument == null)

            {

                rptDocument = new ReportDocument();

                Session["rptDocument"] = rptDocument;

            }

        }

        if (IsPostBack)

        {

            CreateReport();

        }

    }

private void CreateReport()

    {

       

rptDocument = new ReportDocument();

            string Query = string.Empty;

rptDocument.Load(Server.MapPath("report path"));

using (OdbcConnection OCN = new OdbcConnection(ConfigurationManager.ConnectionStrings["connectionstring"].ConnectionString))

            {

                OCN.Open();

                OdbcCommand ocmd = OCN.CreateCommand();

                OdbcDataAdapter sadpt = new OdbcDataAdapter(ocmd);

dsReport DSTEMP = new dsReport();

                DSTEMP.Clear();

                ocmd.CommandText = Query;

                sadpt.Fill(DSTEMP, "datatable1");

                rptDocument.SetDataSource(DSTEMP);

                rptDocument.SetParameterValue("",””);//parameter nameAnd val

                CrystalReportViewer1.ReportSource = rptDocument;

                CrystalReportViewer1.Visible = true;

            }

    }

    protected void cmdPrint_Click(object sender, EventArgs e)

    {

        rptDocument.PrintToPrinter(1, false, 0, 0);

    }

In Aspx

<asp:ScriptManager ID="ScriptManager1" runat="server" EnablePartialRendering="true">

        <Services>

            <asp:ServiceReference Path="~/WebServices/AutoComplete.asmx" />

        </Services>

    </asp:ScriptManager>

  <asp:TextBox ID="txtName" TabIndex="3" runat="server" CssClass="TextBox"

                        Width="250px" MaxLength="100"></asp:TextBox>

                    <cc1:AutoCompleteExtender ID="AutoCompleteExtender1" runat="server" Enabled="true"

                        EnableCaching="true" MinimumPrefixLength="1" TargetControlID="txtName"

                        ServiceMethod="GetNames" ServicePath="~/WebServices/AutoComplete.asmx">

                    </cc1:AutoCompleteExtender>

In asmx.cs file

using System;

using System.Web;

using System.Collections;

using System.Web.Services;

using System.Web.Services.Protocols;

using System.Collections.Generic;

using System.Web.Script.Services;

using System.Data;

[ScriptService()]

[WebService(Namespace = "http://tempuri.org/")]

[WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]

public class AutoComplete : System.Web.Services.WebService

{

    [WebMethod]

    [ScriptMethod()]

    public string[] GetNames(string prefixText, int count)

    {

        ArrayList filteredList = new ArrayList();

        MySQLConnection con = new MySQLConnection();

        string qry = "SELECT column_name FROM table_name WHERE column_name LIKE '%" + prefixText + "%' ";

        DataSet ds;

        ds = con.getDataset(qry);

        foreach (DataRow dr in ds.Tables[0].Rows)

        {            if(dr["column_name"].ToString().ToLower().StartsWith(prefixText.ToLower()))

                filteredList.Add(dr["column_name "].ToString());

        }

        con.closeConnection();

       

        return (string[])filteredList.ToArray(typeof(string));

    }

}