ASP.NET

dt.AsEnumerable() 

<br />
for (int CountHoliday = 0; CountHoliday < 3; CountHoliday++)<br />
{<br />
string sqlFilter = "Holiday Day = '" + Convert.ToDateTime(Al[CountHoliday]).Day + "' and Holiday Month='" + Convert.ToDateTime(Al[CountHoliday]).Month + "' and Holiday Year='" + Convert.ToDateTime(Al[CountHoliday]).Year + "'";<br />
DataRow[] dtRow = dsHoliday.Tables[0].Select(sqlFilter);<br />
if (dtRow[0].ItemArray[4].ToString() != "")<br />
{<br />
iCounter++;<br />
}<br />
}<br />
<br />
You have to get the Day, Month and Year in the DataTable as columns and use the filter in that. If you will be using the full datetime value for comparison it would not help you as it throws the error in some cases. Also try to name the columns without space like "Holiday Day" or "Holiday Date" should be "HolidayDay" or "HolidayDate" or you can use Underscore in place of Space. <br />
<br />

Guid UserID = new Guid(Membership.GetUser(User.Identity.Name)).ProviderUserKey.ToString());

Guid key = new Guid(Request.QueryString["id"].ToString());
                MembershipUser user = Membership.GetUser(key);
                user.IsApproved = true;
                Membership.UpdateUser(user);