Crystal Reports for Visual Studio 2010 and 2012

Crystal Reports is a popular Windows-based report writer (report generation program) that allows a programmer to create reports from a variety of data sources with a minimum of written code. Developed by Seagate Software, Crystal Reports can access data from most widely-used databases and can integrate data from multiple databases within one report using Open Database Connectivity ( ODBC ). Crystal Reports uses an ActiveX control called CrystalReport to establish a connection with another program. A programmer can set properties of the CrystalReport control during design time or at run time. The programmer can use automation tools called Experts to be guided through common tasks, such as linking and embedding reports. Crystal Reports treats all text, graphics, and database fields as object s that a programmer can place, arrange, and format on forms. The program also generates a recordset object and code needed to perform programming tasks such as loop s or mathematical calculations. Crystal Reports can create a report on the fly from user-defined variables and can convert it to HTML and publish it to the Web automatically. 

Source : http://whatis.techtarget.com/definition/Crystal-Reports

Crystal report for Visual Studio Download By MITGuru-lk

Crystal Report for Visual Studio 2010 and Visual Studio 2012 Download

Support integration with Visual Studio 2012 and 4.5 .NET Framework runtime. Added support for following platforms:

a.        OS:  Windows 7 SP1, Windows 8, Windows 2012

b.       Database: SQL Server 2012, HANA SP5

c.        Web Browser:  Firefox 16, IE10 (limited support; more information forthcoming soon)

d.       Other technology: IIS 8, Flash 11

• SAP Crystal Reports, developer version for Microsoft Visual Studio SP5 - MSI (32bit)
• SAP Crystal Reports, developer version for Microsoft Visual Studio SP5 - MSI (64bit)

Crystal Report Run time Engine Download

• SAP Crystal Reports, developer version for Microsoft Visual Studio SP5 - built-in Visual Studio ClickOnce “Homesite” location (32 bit)
• SAP Crystal Reports, developer version for Microsoft Visual Studio SP5 - built-in Visual Studio ClickOnce “Homesite” location (64 bit)

More Details : http://scn.sap.com/docs/DOC-7824

1 comment

Posted at 8:16 PM |  by Mit Guru

PHP with MS Access 2010 Database Connection

This tutorial is show how to connect ms access database using PHP and how to retrive data of its table now i have ms access 2010 database in following table

Table name : result

Field names :

• indexNo
• subjectName
• subjectCode
• subjectMark

for this if you using xampp or wampp or something please change this file for suppot .net framework

Find php.ini File

Ex: in xampp environment

C:\xampp\php

Open php.ini file using notepad

Copy and Paste following code and save

[COM_DOT_NET]
     extension=php_com_dotnet.dll

then refresh the xampp

PHP and Ms Access database connection and retrive data

<?php

//Create Connection
$con = new COM("ADODB.Connection") or die("Cannot start ADODB Connection from 'database_conn.php'");

   $con->Open("Provider=Microsoft.ACE.OLEDB.12.0; Data Source=" . realpath("dbf/Student.accdb"));

//Retrive Data

echo " <table width='95%' border='1' align='center' cellpadding='0' cellspacing='0' bordercolor='#550055'>    <tr>
    <td width='20%' height='35' bgcolor='#550055'><p class='facTBLHeader facDean'>Subject Code</p></td>
    <td width='59%' bgcolor='#550055'><p class='facTBLHeader facDean'>Subject Name</p></td>
    <td width='21%' bgcolor='#550055'><p class='facTBLHeader facDean'>Mark</p></td>    </tr>";

//retrive result table data (specific Index No)

$index=001;
$sql3=$con->Execute("Select * from Result where( IndexNo='".$index."')");

     while(!$sql3->EOF)
     {
       $subCode=$sql3 ->Fields[2]->value;
       $subName=$sql3 ->Fields[3]->value;
       $subMark=$sql3 ->Fields[4]->value;
       echo "<tr>";
     echo "<td  height='26' style='padding-left:10px'>".$subCode."</td>";
     echo "<td height='26' style='padding-left:10px'>".$subName."</td>";
     echo "<td height='26' align='center'>".$subMark."</td>";

      echo" </tr>";
      $sql3->MoveNext();

     }
     $sql3->Close();


//retrieve all subject name, code and mark details of index no 001

If you want to get all details change SQL query Like this.

$sql3=$con->Execute("Select * from Result");

No comments

Posted at 10:49 PM |  by Mit Guru

Download SQL Server® 2008 R2 Express

Microsoft® SQL Server® 2008 R2 Express is a powerful and reliable data management system that delivers a rich set of features, data protection, and performance for embedded applications, lightweight Web Sites and applications, and local data stores.

Download  SQL Server® 2008 R2 Express

No comments

Posted at 2:50 AM |  by Mit Guru

Checked box in C#

This program is show how to use check box in c#.net. According to this program if you tick the course (Check Box) and click the Tell Me Button it show check courses in bellow Label.

C#.net Code for Checkbox

Download Project

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;



namespace checkedbox
{
    public partial class Form1 : Form
    {
      public Form1()
    {
    InitializeComponent();
    }
    private void tellmeButton_Click(object sender, EventArgs e)
    {

    string result = "";

    if (radcheckBox.Checked)
    {
      result += "\nRapid Application";
    }
    if (dbmscheckBox.Checked)
    {
     result += "\nData Base Management";
    }
    if (technocheckBox.Checked)
    {
     result += "\nTechnology Management";
    }
    if (pccheckBox.Checked)
    {
     result += "\nPC Application";

    }

    resultLabel.Text = "Your Cause is:." + result;

    }

    }

}

No comments

Posted at 2:11 AM |  by Mit Guru

Simple Car Rental program in C#

This program show how to calculate Car Rental using type of car, Km and Number of rental days. Insert that details and click Process Button then calculate total rental and Click Clear Button Clear all details for new One. When you click Exit button exit this program.

C#.net Code for Simple Car Rental Program

Download Source Project

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;

namespace CarRental
{
 public partial class Form1 : Form

 {
 public Form1()
 {
 InitializeComponent();
 }
 private void processButton_Click(object sender, EventArgs e)

 {
  decimal day, total,km;

  day = decimal.Parse(daytextBox.Text);

  km = decimal.Parse(kmtextBox.Text);

  total = 0;

  if (HondarButton.Checked)

  {
   total = (1500 + (20 * km)) - (80 * day);
  }
  else if (nissanrButton.Checked)
  {
  total = (2000 + (30 * km)) - (60 * day);
  }
  else if(civicrButton.Checked)
  {
  total = (2500 + (40 * km)) - (50 * day);
  }
  else
  {
  MessageBox.Show("Invalid Info");
  }
  totaltextBox.Text = total.ToString("c");
  }
 }

 private void clear()
 {
  daytextBox.Clear();

  kmtextBox.Clear();

  totaltextBox.Clear();

  HondarButton.Checked = true;

  daytextBox.Focus();
 }

 private void exitButton_Click(object sender, EventArgs e)
 {
  this.Close();
 }

 private void clearButton_Click(object sender, EventArgs e)
 {
  clear();
 }

 }

}

6 comments

Posted at 2:08 AM |  by Mit Guru

Array 2 in C# 2010

This program is show int array in C#.net. you can use four methods for this each method is show in the button click event.

C#.net Code For Int Array

Download project

using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.Linq;

using System.Text;

using System.Windows.Forms;



namespace Array_2

{

    public partial class Form1 : Form

    {

        public Form1()

        {

            InitializeComponent();

        }



        private void arrwithnewkeywordbutton_Click(object sender, EventArgs e)

        {

            listBox1.Items.Clear();

            int[] MIT31043;

            MIT31043 = new int[60];



            for (int counter = 0; counter <MIT31043.Length; counter++)

            {

                MIT31043[counter] =counter+ 1;

                listBox1.Items.Add(MIT31043[counter].ToString());



            }

        }



        private void arrinitializerbutton_Click(object sender, EventArgs e)

        {

            listBox1.Items.Clear();

            int[] number = {11,22,33,44,55 };



            for (int counter = 0; counter < number.Length; counter++)

            {

                listBox1.Items.Add(number[counter]);

            }

        }



        private void calculationwitharrbutton_Click(object sender, EventArgs e)

        {



            listBox1.Items.Clear();

            int counter;



            int[] mit = new int[5];



            for (counter = 0; counter < mit.Length; counter++)

            {

                mit[counter] = counter * 3;

                listBox1.Items.Add(mit[counter]);

            }



        }



        private void usingforeachbutton_Click(object sender, EventArgs e)

        {

            listBox1.Items.Clear();



            int sum = 0;

            int[] mit = {12,23,34,45,56,67 };



            foreach (int counter in mit)

            {

                sum += counter;

                listBox1.Items.Add(counter);

            }

            listBox1.Items.Add("===============");

            listBox1.Items.Add(sum);

        }

    }

}

No comments

Posted at 2:04 AM |  by Mit Guru