ScriptManager dynamically alert message

string msg="Hello Pabitra";
 string message = "alert('"+msg+"');";
                    ScriptManager.RegisterStartupScript(this, this.GetType(),"alert" + UniqueID, message, true);

sorting in datatable

DataTable dtddlHotel=GetDataFromData();
 DataTable distinctTable = dtddlHotel.DefaultView.ToTable( /*distinct*/ true);

--------------------------------------
Or
------------
Example
----------
Table Emp Has One column Year and having Data
------------------
Year
------
2014
2015
2016



----------------------
DataTable dt = new DataTable();
       dt=getData("Select Year From emp");
        DataView dtview = new DataView(dt);
        dtview.Sort = "Year DESC";    
        dt = dtview.ToTable();
------------------------------------
Now In dt
contain
Result
---------------------
Year
--------
2016
2015
2014    
----------------------------------------
For Asending
-------------------
DataTable dt = new DataTable();
       dt=getData("Select Year From emp");
        DataView dtview = new DataView(dt);
        dtview.Sort = "Year ASC";    
        dt = dtview.ToTable();   

Date Format in c#

public  DateTime GetBDFormatedDate(string _date)
        {
            CultureInfo provider = CultureInfo.InvariantCulture;
            string dateTime = _date;
            string[] formats = { "dd/MM/yyyy", "dd-MM-yyyy", "d/M/yyyy", "d.M.yyyy", "d-M-yyyy", "d M yyyy", "d/M/yy", "d.M.yy", "d-M-yy", "d M yy", "MM/dd/yyyy", "MM-dd-yyyy", "M/d/yyyy", "M.d.yyyy", "M-d-yyyy", "M-d-yyyy", "M/d/yy", "M.d.yy", "M-d-yy", "M d yy" };
            DateTime dtdateTime = DateTime.Now;
            try
            {
                dtdateTime = DateTime.ParseExact(dateTime, formats, provider, DateTimeStyles.AdjustToUniversal);
            }
            catch { }
            return dtdateTime;
        }

foreach loop in Repeater control in asp.net

<asp:Repeater ID="rptr" runat="server">
                                                <ItemTemplate>
                                                    <div class="divclass" >
                                                      <a href="<%#Eval("link") %>" ><img src='<%#Eval("imgurl") %>'  /> </a>
                                                    </div>
                                               
                                                </ItemTemplate>
                                            </asp:Repeater>    



   foreach (RepeaterItem ri in rpt.Items)
        {
            LinkButton lnk = ri.FindControl("LinkButton1") as LinkButton;
            lnk.Text="Pabitra";
            lnk.ToolTip = "Pabitra";
        }