Crystal report record selection formula in C# from SQL

See more:

C#

SQL

.NET

Visual-Studio

WinForms

, +

i am new in Crystal Report, I've Created a Crystal Report Successfully By following Methods

1)Created Crystal Report As Blank
2)get into Database Expert and create Database using OLE DB(ADO)
3)in OLE DB(ADO) i simply add tables into the Database and showed it on Crystal Report
4)Then i created a Win form on which i used Crystal Report Viewer
5)then i use following Code on Crystal Report Viewer Tab to Call the Crystal Report

Code:

var cryRpt = new ReportDocument();
cryRpt.Load(@"C:\Users\Ahsan\Desktop\PROJECT INVENTORY SOFTWARE\InventorySoftware\InventorySoftware\Crystal Reports\CrystalReport2.rpt");
crystalReportViewer1.ReportSource = cryRpt;
crystalReportViewer1.Refresh();

Now what does it do, it go to table fetch complete Data on the table, like if i have 500 Records then it will load all the 500 Records, and that's what i don't want to do. what i actually need to do is to fetch data of a specific invoice no and i am not able to do this in any way.

i want it to fetch data for only that invoice number which is written on the form (a text box) at run time, and the query through which i want to fetch data is build using Joins.

i am stuck and doing Google from past 3 hours but not able to do it.

Please dear fellows Help me out. i will be very grateful

Thanks.