This is my code....
If i read records from datareader it only return first 6 records
string str = "Data Source=200.0.1.150;Database=cpms;User ID=rakesh;Password=rakesh";
MySQLConnection con = new MySqlConnection (str);
con.Open();
MySqlCommand cmdSelect1 = new MySqlCommand("Select LoginID,FirstExpStartDate,FirstExpEndDate, ,SecondExpEndDate,ThirdExpStartDate,ThirdExpEndDate from experiance where LoginID = '"+ user +"'",con);
dr = cmdSelect1.ExecuteReader ();