Reply to thread

Message: <blockquote data-quote="amila.ela" data-source="post: 7926013" data-attributes="member: 274557"><img src="http://www.codeproject.com/KB/cs/CreatingCrystalReports/CreatingCrystalReports.jpg" alt="" class="fr-fic fr-dii fr-draggable " style="" /><img src="http://www.codeproject.com/KB/cs/CreatingCrystalReports/2.jpg" alt="" class="fr-fic fr-dii fr-draggable " style="" />Create a DatasetFirst you should create a Dataset to get data from the DB. By clicking the “Add New Item” in the “Project” menu, you can add a Dataset. A picture of an added Dataset looks like the following window and you can add elements to the Dataset by dragging and dropping elements from the toolbox. This Dataset is used to fill the data, which it gets from the DB by using a query. Because of that, the names of the elements in this Dataset should be equal to the names of the elements in the DB. For an example, this Dataset can fill using the following query.String connString = @"Provider=Microsoft.Jet.OLEDB.4.0;_    Data Source=..\\..\\myDB.mdb;User ID=Admin;Password=";OleDbConnection conn = new OleDbConnection(connString);conn.Open();string query = "SELECT studentID, firstName, lastName, birthDate, _                address, contactNo FROM studentInfo";OleDbDataAdapter oleDA = new OleDbDataAdapter(query,conn);The next window looks like the following and you have to select your created Dataset under “Project Data”, and click “Insert Table”, then click next.<img src="http://www.codeproject.com/KB/cs/CreatingCrystalReports/3.jpg" alt="" class="fr-fic fr-dii fr-draggable " style="" />Then you have to add the field, which you want to display in the report through the following window and click next.<img src="http://www.codeproject.com/KB/cs/CreatingCrystalReports/4.jpg" alt="" class="fr-fic fr-dii fr-draggable " style="" />You can also go to other tabs of this window and select/deselect your choices. Use the last tab “Style” to select the format of the report. You can also type a Report Title here and click finish<img src="http://www.codeproject.com/KB/cs/CreatingCrystalReports/5.jpg" alt="" class="fr-fic fr-dii fr-draggable " style="" />Set the Created Report to Display in the FormThen you have to set a “crystalReportViewer” in your form to load the report that you created earlier. Moreover, you need to set the report source of this “crystalReportViewer” component, which falls in the properties panel or you can set the report source by using the code like the following:// code to get data from the DBDBConnection DBConn = new DBConnection();OleDbDataAdapter myDataAdapter = DBConn.getDataFromDB();// use the created Dataset to fill it with data got// from the DB by using the DataAdapterDataSet dataReport = new DataSet();myDataAdapter.Fill(dataReport,"myPersonalInfoTable");// create a new report from the created CrystalReportmyDataReport myDataReport = new myDataReport();// set the data source of the reportmyDataReport.SetDataSource(dataReport);// set the report source of the created “crystalReportViewer”// component to the created reportcrystalReportViewer1.ReportSource = myDataReport;<img src="/styles/default/xenforo/smilies/default/P.gif"  class="smilie" loading="lazy" alt=":P" title=":P    :P" data-shortname=":P" /><img src="/styles/default/xenforo/smilies/default/P.gif"  class="smilie" loading="lazy" alt=":P" title=":P    :P" data-shortname=":P" /><img src="/styles/default/xenforo/smilies/default/P.gif"  class="smilie" loading="lazy" alt=":P" title=":P    :P" data-shortname=":P" /><img src="/styles/default/xenforo/smilies/default/P.gif"  class="smilie" loading="lazy" alt=":P" title=":P    :P" data-shortname=":P" /></blockquote>

Verification: Dawasata paya keeyak thibeda?

Top Bottom