Call javascript from server side

ScriptManager.RegisterStartupScript(Page, Page.GetType(), "SetHiddenAdSegmentDuration", "SetHiddenAdSegmentDuration('" + SumAdSegmentDuration + "');", true);

Hide particular column into Grid on special condition

In Aspx :

----------

<telerik:GridBoundColumn DataField="LastName" UniqueName="LastName"

                                                                                                  HeaderText="Last Name" HeaderStyle-HorizontalAlign="Right">

                                                                                                    <ItemStyle HorizontalAlign="Right" />

                                                                                                </telerik:GridBoundColumn>

In Aspx.cs

-------------

protected void Page_Load(object sender, EventArgs e)

        {

HideColumn("LastName "); //-- Column Name

}

private void HideColumn(string uniqueName)

        {

            GridColumn gridCol = dgSiteList.Columns.FindByUniqueNameSafe(uniqueName);

            if (gridCol != null)

                gridCol.Visible = false;

        }

RadAjaxManager Asynchronous call on server side.

Example:

On Client Side:

<table align="center" width="100%">

  <tr>

   <td align="center" width="100%">

      <table align="center" width="100%" style="background-color: #ffffff; border: 0; margin-left: -5;">

        <tr id="trRotator" runat="server" visible="false">

        <td align="center" style="background-color: #ffffff; margin-left: -5;" width="100%">

         <telerik:RadRotator ID="rdRotator" runat="server" Width="432px" Height="132px" CssClass="horizontalRotator" ScrollDuration="500" ItemHeight="120" ItemWidth="128" RotatorType="Buttons" WrapFrames="false" OnItemDataBound="rdRotator_ItemDataBound" BorderColor="white">

     <ItemTemplate>

     <asp:Image ID="imgPreview" Height="108" Width="125" CreativeId='<%# Eval("CreativeId")%>' onclick='<%# "InitiateAsyncRequest(" +Eval("CreativeID") + " );" %>' runat="server" ToolTip='<%# Eval("Filename") %>' Style="cursor: pointer; opacity: 0.5" />

       &nbsp;

      </ItemTemplate>

     </telerik:RadRotator>

    </td>

    </tr>

    </table>

     </td>

    </tr>

    <tr>

     <td align="center">

        <br />

         <div id="dvMediaInformation" runat="server">

          <table width="90%" cellpadding="2" cellspacing="0" border="0">

               <tr>

                <td align="left" valign="top" colspan="2">

                     <b> <asp:Label ID="lblMedialbl" CssClass="lblCampaignMedia" runat="server">Media : </asp:Label>

                    </b><b>

                    <asp:Label ID="lblMediaName" CssClass="lblCreative" runat="server"></asp:Label>

                    </b>

                     </td>

                    </tr>

           </table>

          </div>

      </td>

  </tr>

</table>

<telerik:RadAjaxManager ID="rdAjaxManager" runat="server" OnAjaxRequest="rdAjaxManager_AjaxRequest">

        <AjaxSettings>

            <telerik:AjaxSetting AjaxControlID="rdAjaxManager">

                <UpdatedControls>

                    <telerik:AjaxUpdatedControl ControlID="MediaContent" />

                    <telerik:AjaxUpdatedControl ControlID="dvMediaInformation" />

                </UpdatedControls>

            </telerik:AjaxSetting>

        </AjaxSettings>

    </telerik:RadAjaxManager>

    <telerik:RadCodeBlock ID="RadCodeBlock1" runat="server">

        <script type="text/javascript">

            function InitiateAsyncRequest(argument) {

                $("img[id*='imgPreview']").css("opacity", "0.5");

                $("img[creativeid='" + argument + "']").css("opacity", "1");

                var ajaxManager = $find("<%= rdAjaxManager.ClientID %>");

                ajaxManager.ajaxRequest(argument);

                return false;

            }

        </script>

    </telerik:RadCodeBlock>

On Server Side:

protected void rdRotator_ItemDataBound(object sender, RadRotatorEventArgs e)

{

  ClientCampaignCreative _ClientCampaignCreative = (ClientCampaignCreative)e.Item.DataItem;

 if (_ClientCampaignCreative != null)

 {

                CacheManager.Instance.CacheCreativeImage(_ClientCampaignCreative.FileThumbnail, _ClientCampaignCreative.CreativeId);

  Image imgPreview = (Image)e.Item.FindControl("imgPreview");

 if (imgPreview != null)

   {

  imgPreview.ImageUrl =  QueryStringManager.Instance.AddCreativeId(NECAdNetwork.Common.Utils.BaseUrl + "ShowImage.aspx", _ClientCampaignCreative.CreativeId);

    if (e.Item.Index == 0)

      {

        imgPreview.Attributes.Add("style", "opacity:1; cursor: pointer;");

      }

    }

  }

  else

  {

     lblMessage.Text = "Media Information not found.";

     dvMediaInformation.Visible = false;

  }

}

Multipal Field Group By IN LINQ

var objOrderList = from OL in
        (from OrderDetail in objOrderDetail
      join Item in objItem on OrderDetail.ItemId equals Item.ItemId
      join ItemGroup in objItemGroup on Item.GroupId equals ItemGroup.GroupId
      select new
      {
       GroupName = ItemGroup.GroupName,
       ItemName = Item.ItemName,
       Rate = Item.Rate,
       Qty = OrderDetail.Qty
      }
      )
       group OL by new
       {
        OL.GroupName,
        OL.ItemName
       } into OrderList
       select new
       {
        GroupName = OrderList.Key.GroupName,
        ItemName = OrderList.Key.ItemName,
        OrderTotal = OrderList.Sum(OL => OL.Qty * OL.Rate)
       };

Create XML in Store procedure

Ex :
Select Column1,
    Column2,
    Column3
from Table
where Column1 = '5'
for xml path('video'), ROOT('videoPaths')

Import Address of Email Account links

Gmail
http://aspdotnet-suresh.blogspot.com/2010/04/import-contacts-from-gmail.html

http://www.netrostar.com/Tutorials-210-How%20to%20import%20address%20book%20from%20Gmail%20using%20C

http://code.google.com/apis/contacts/docs/2.0/developers_guide_dotnet.html#Retrieving




yahoo

http://developer.yahoo.com/dotnet/howto-rest_cs.html



Yahoo/gmail/hotmail address book at below link
http://sourceforge.net/project/downloading.php?group_id=210092&filesize=178426&filename=OpenContactsNet-1.0.zip

Partitioned by Example

  SELECT User_FirstName,
         User_LastName,
         User_Date,
         User_Email,
         SUM(User_ID) OVER (Partition by User_Salary) as TotalUserSalary,
         row_number() OVER (ORDER BY User_ID DESC) as SrNo
       
  FROM     [TestProject].[dbo].[TBL_USER]