iTech Systemz Blog

//In the given code below, CrptInTransit is the name of calling report, and crystalReportViewer1 is use to display the report.

CrptInTransit report = new CrptInTransit();

report.RecordSelectionFormula = “{tblIntransit.ScrollDate} >= #” + DateFrom.ToShortDateString() + “# and {tblIntransit.ScrollDate} <= #” + DateTo.ToShortDateString() + “#”;

crystalReportViewer1.ReportSource = report;

private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgse)
{
bool value = (bool)(this.dataGridView1.Rows[e.RowIndex].Cells[0].Value ?? false);
this.dataGridView1.Rows[e.RowIndex].Cells[0].Value = !value;
}

1. MyISAM is faster then InnoDB
2. MyISAM
   

<?php

$string = ‘your string’;

$new_string = ereg_replace( ‘[^A-Za-z0-9]‘, ”, $string);

echo $new_string;

?>