Wednesday, 16 October 2013

how to disable focus on textbox

   <asp:TextBox ID="TextBox1" runat="server" readonly="true" onfocus="this.blur();" ></asp:TextBox>


Monday, 9 September 2013

How to set the position of the ASP.NET Ajax ModalPopupExtender?

<AjaxToolkit:ModalPopupExtender ...otherproperties...
     X="100" Y="300">

</AjaxToolkit:ModalPopupExtender>

Sunday, 1 September 2013

Telerik Radgrid load grouping at Client Side

 <MasterTableView GroupLoadMode="Client">

Telerik Rad Grid Nested Grouping

 <MasterTableView GroupLoadMode="Client">
   <GroupByExpressions>
    <telerik:GridGroupByExpression >
    <GroupByFields>                                               
    <telerik:GridGroupByField FieldName="status"  />
    </GroupByFields>
    <SelectFields>
    <telerik:GridGroupByField FieldName="status" HeaderValueSeparator="" HeaderText=" " FieldAlias="status" />
     </SelectFields>
     </telerik:GridGroupByExpression>
     <telerik:GridGroupByExpression >
     <GroupByFields>                                               
     <telerik:GridGroupByField FieldName="date"  />
     </GroupByFields>
     <SelectFields>
       <telerik:GridGroupByField FieldName="date" HeaderValueSeparator="" HeaderText=" " FieldAlias="Test" />
       </SelectFields>
       </telerik:GridGroupByExpression>
       </GroupByExpressions>

       </MasterTableView>

Group by column in Telerik Rad grid

 <MasterTableView GroupLoadMode="Client">
   <GroupByExpressions>
    <telerik:GridGroupByExpression >
    <GroupByFields>                                               
    <telerik:GridGroupByField FieldName="status"  />
    </GroupByFields>
    <SelectFields>
    <telerik:GridGroupByField FieldName="status" HeaderValueSeparator="" HeaderText=" " FieldAlias="status" />
     </SelectFields>
     </telerik:GridGroupByExpression>  
</GroupByExpressions>
</MasterTableView>

Thursday, 29 August 2013

Telerik radgridview change row color based on value

  protected void gvUserDetail_ItemDataBound(object sender, Telerik.Web.UI.GridItemEventArgs e)
        {
           
            if (e.Item is GridDataItem)
            {
                //Get the instance of the right type
                GridDataItem dataBoundItem = e.Item as GridDataItem;
               

                //Check the formatting condition
                if ((dataBoundItem["column"].Text) == "Test")
                {
                    dataBoundItem["column"].ForeColor = Color.Green;
                    dataBoundItem["column"].Font.Bold = true;
                    e.Item.BackColor = Color.Red;
                    //Customize more...
                }
            }
          
        }


Saturday, 3 August 2013

SQL Time Overlap/Conflict Query

select * from table t2
 where name = @name
 and (@inserted_start_datetime between start_datetime and end_datetime
  or @inserted_end_datetime between start_datetime and end_datetime
  or start_datetime between @inserted_start_datetime and @inserted_end_datetime

  or end_datetime between @inserted_start_datetime and @inserted_end_datetime