Archive

Archive for February, 2010

Migratation Tool for Sql Database To MySql Database

February 15, 2010 Leave a comment

Various migration tools are available for converting sql database to mysql database.  I personally use the Ispirer – Sqlways migration tool for my projects,  it supports conversion of tables and stored procedures ,you can download it from below:

http://www.ispirer.com/download

Advertisements

Using Dataview RowFilter (Syntax) in Asp.net C#

February 8, 2010 1 comment

Lets say we have a datatable, we want to select rows that meet certain criteria, then we can use Dataview.Rowfilter.

For example we have a datatable having empid column, we want the row whose empid is 8.

dataView.RowFilter = "empid = 8";

Other examples are
dataView.RowFilter = "EmpName = 'Pankaj'" ;
dataView.RowFilter = "Date = #12/08/2000#" ;

Comparision
dataView.RowFilter = "Date>=" + "#" + startdate + "#" +
"And Date <=" + "#" + enddate + "#";
You can find other examples at:
http://www.csharp-examples.net/dataview-rowfilter/

Validator Enable/Disable in Asp.net using Javascript

February 3, 2010 Leave a comment

You can enable/disable validators using javascript as follows:

ValidatorEnable(document.getElementById(‘<%= rfv.ClientID %>’), false);

First argument is id of validator, second argument is to enable pass “true”, else pass “false”.