Results 1 to 5 of 5

Thread: vb convert c#, passing parameter crystal rpts [*Resolved*]

  1. #1

    Thread Starter
    Frenzied Member
    Join Date
    Dec 2001
    Posts
    1,331

    Resolved vb convert c#, passing parameter crystal rpts [*Resolved*]

    Hello,

    I have a vb code which l am trying to convert to c# and having many problems with it. PFD = rpt.DataDefinition.ParameterFields.Item("@dt"). In c# there is not a parameterFields method called Item. So i am not sure how do l get the name of my parameter that is in the crystal report viewer.

    Can anyone help me convert this code to c#.
    Code:
    Imports CrystalDecisions.Shared
                    Imports CrystalDecisions.CrystalReports.Engine
                    
                    Dim mDate As DataTime = #01/01/2005#
                    Dim rpt As New CrystalReport1
                    Dim PFD As ParameterFieldDefinition
                    Dim PValues As ParameterValues
                    Dim Parm As ParameterDiscreteValue
    
                    PValues = New ParameterValues
    
                    PFD = rpt.DataDefinition.ParameterFields.Item("@dt")
                    Parm = New ParameterDiscreteValue
                    Parm.Value = mDate
                    PValues.Add(Parm)
                    PFD.ApplyCurrentValues(PValues)
    
                    CrystalReportViewer1.ReportSource = rpt
    Thanks in advance,

    Steve





    Edit: Added [code][/code] tags for clarity. - Hack
    Last edited by steve_rm; Jan 27th, 2006 at 07:01 AM.
    steve

  2. #2
    I'm about to be a PowerPoster! mendhak's Avatar
    Join Date
    Feb 2002
    Location
    Ulaan Baator GooGoo: Frog
    Posts
    38,170

    Re: vb convert c#, passing parameter crystal rpts

    Instead of .Item("@dt"), you could try just ["@dt"];

    (without the .Item, and square brackets)

  3. #3
    Super Moderator jmcilhinney's Avatar
    Join Date
    May 2005
    Location
    Sydney, Australia
    Posts
    111,221

    Re: vb convert c#, passing parameter crystal rpts

    In VB.NET the Item property is often the default property, which means you can omit the property name, i.e.
    VB Code:
    1. PFD = rpt.DataDefinition.ParameterFields.Item("@dt")
    could be written
    VB Code:
    1. PFD = rpt.DataDefinition.ParameterFields("@dt")
    In C# the equivalent of a default property is an indexer. When using an indexer I believe that you MUST omit the property name, so the C# code becomes
    Code:
    PFD = rpt.DataDefinition.ParameterFields["@dt"];
    Why is my data not saved to my database? | MSDN Data Walkthroughs
    VBForums Database Development FAQ
    My CodeBank Submissions: VB | C#
    My Blog: Data Among Multiple Forms (3 parts)
    Beginner Tutorials: VB | C# | SQL

  4. #4
    Fanatic Member
    Join Date
    Jan 2006
    Posts
    710

    Re: vb convert c#, passing parameter crystal rpts

    Instant C# produces:

    using CrystalDecisions.Shared;
    using CrystalDecisions.CrystalReports.Engine;

    public void test()
    {
    DataTime mDate = DateTime.Parse("01/01/2005");
    CrystalReport1 rpt = new CrystalReport1();
    ParameterFieldDefinition PFD = null;
    ParameterValues PValues = null;
    ParameterDiscreteValue Parm = null;

    PValues = new ParameterValues();

    PFD = rpt.DataDefinition.ParameterFields["@dt"];
    Parm = new ParameterDiscreteValue();
    Parm.Value = mDate;
    PValues.Add(Parm);
    PFD.ApplyCurrentValues(PValues);

    CrystalReportViewer1.ReportSource = rpt;
    }
    David Anton
    Convert between VB, C#, C++, & Java
    www.tangiblesoftwaresolutions.com

  5. #5

    Thread Starter
    Frenzied Member
    Join Date
    Dec 2001
    Posts
    1,331

    Re: vb convert c#, passing parameter crystal rpts

    Thanks for all your help.

    PFD = rpt.DataDefinition.ParameterFields["dt"];

    Have to take out the @ sign of an error message says field name does not exist.

    Thanks,

    Steve
    steve

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width