Monday, October 28, 2013

Validating date using Range Validator asp net

Q: Why Validate date using Range Validator? 
A: All validation controls use culture specified in the web.config globalization tag. We don't need to hard code values every time we change culture. So using Range Validator as a date comparator makes things easy. To use range validator make sure to specify Type="Date" else it won't work. Choose Maximum and Minimum Values as required

<asp:RangeValidator ID="RangeValidator1" runat="server" ErrorMessage="Invalid Date" 
Type="Date" ControlToValidate="{}" MaximumValue="3000-12-12" MinimumValue="1900-12-12">
</asp:RangeValidator>

Thanks

Crystal Reports: Suppressing a object based on condition

Suppressing a object based on condition is pretty easy. Just use a Boolean field or Boolean parameter or an expression that returns Boolean value.

No if else is required.

e.g.

{?ShowPaid}
 
If it returns true object will be suppressed else no

Sunday, October 27, 2013

Count total rows of gridview with pagination asp net

For this example
GridView ID: gvStudents
SqlDataSourceID: dsApplications
Event: dsApplications_Selected
protected void dsApplications_Selected(object sender, SqlDataSourceStatusEventArgs e)
{
   int PageIndex = gvStudents.PageIndex;
   int start = PageIndex * gvStudents.PageSize + 1;
   int end = Math.Min(start + gvStudents.PageSize - 1, e.AffectedRows);
   navi.InnerHtml = string.Format("Showing record {0} - {1} of {2}", start, end, e.AffectedRows);
}

Friday, October 25, 2013

Hide InsertItem While Editing in listview asp net c#

If you want to hide InsertItem while editing just use these three events

protected void lv_ItemEditing(object sender, ListViewEditEventArgs e)
{
     ListView lvSender = (ListView)sender;
     lvSender.InsertItemPosition = InsertItemPosition.None;
}
 
protected void lv_ItemUpdated(object sender, ListViewUpdatedEventArgs e)
{
      ListView lvSender = (ListView)sender;
      lvSender.InsertItemPosition = InsertItemPosition.FirstItem;
}
 
protected void lv_ItemCanceling(object sender, ListViewCancelEventArgs e)
{
     ListView lvSender = (ListView)sender;
     lvSender.InsertItemPosition = InsertItemPosition.FirstItem;
}
and then append this to list view
OnItemCanceling="lv_ItemCanceling" OnItemUpdated="lv_ItemUpdated" OnItemEditing="lv_ItemEditing"
Hope this helps

Crystal Reports: Missing Parameter Values

Steps to solve the problem Crystal Missing Parameter Values
  • Make sure SetParameterValues are not empty or null
  • Use ReportDocument.SetParameterValues after loading main report and most importantly subreports
  • If you use setparametervalues between load report and subreport this error will occur
    • Settings subreports  nullifies previous set parameter values