execute dynamic sql command in sql server 2008

DECLARE @sqlCommand varchar(1000)
DECLARE @columnList varchar(75),@G_Id int
DECLARE @city varchar(75)
SET @columnList = 'a.Id,a.Name,a.City,a.G_Id'
SET @city = '''bbsr'''
set @G_Id=1
SET @sqlCommand = 'SELECT ' + @columnList + ' FROM mytable a
 WHERE a.City='+@city+'and a.G_Id='+convert(varchar,@G_Id)
 --print @sqlCommand
EXEC (@sqlCommand)

sql server procedure list on created date

SELECT name,create_date, modify_date
FROM sys.objects
WHERE type = 'P'
AND DATEDIFF(D,create_date, GETDATE()) < 500
order by create_date asc
-----------------------------------------------------



SELECT
    name,
    create_date,
    modify_date
FROM sys.procedures
order by create_date desc
or
SELECT
    name,
    create_date,
    modify_date
FROM sys.procedures
order by create_date asc









---------------------------
SELECT name
FROM sys.objects
WHERE type = 'P'
AND DATEDIFF(D,create_date, GETDATE()) < 30
---------------------

2 down vote

SELECT name FROM sys.objects WHERE type = 'P' AND DATEDIFF(D,modify_date, GETDATE()) < 7 -------------------------------------- SELECT name,create_date, modify_date FROM sys.objects WHERE type = 'P' AND DATEDIFF(D,create_date, GETDATE()) < 30

numeric validation in jquery textbox

Only number or validate text box which receive only number in javascript function


 <script type="text/javascript">
function isNumber(evt) {
            evt = (evt) ? evt : window.event;
            var charCode = (evt.which) ? evt.which : evt.keyCode;
            if (charCode > 31 && (charCode < 48 || charCode > 57)) {
                return false;
            }
            return true;
        }
    </script>



For html input Control
-------------------------
<input type="text" id="txtEidNo" onkeypress="isNumber(event)" />



For ASPX TextBox Control
-------------------------
<asp:TextBox ID="txtEidNo" runat="server" onkeypress="return isNumber(event)"></asp:TextBox> 




In jquery 
----------------
For html input Control
------------------------------
<input type="text" id="txtEidNo" />

<script type="text/javascript">
        $(document).ready(function () {
            $("#txtEidNo").keydown(function (e) {
                if (e.shiftKey)
                    e.preventDefault();
                else {
                    var nKeyCode = e.keyCode;
                    //Ignore Backspace and Tab keys    
                    if (nKeyCode == 8 || nKeyCode == 9)
                        return;
                    if (nKeyCode < 95) {
                        if (nKeyCode < 48 || nKeyCode > 57)
                            e.preventDefault();
                    }
                    else {
                        if (nKeyCode < 96 || nKeyCode > 105)
                            e.preventDefault();
                    }
                }
            });
        });
    </script>




For ASPX TextBox Control
-------------------------
<asp:TextBox ID="txtEidNo" runat="server" ></asp:TextBox> 

<script type="text/javascript">
        $(document).ready(function () {
            $("#<%= txtEidNo.ClientID%>").keydown(function (e) {
                if (e.shiftKey)
                    e.preventDefault();
                else {
                    var nKeyCode = e.keyCode;
                    //Ignore Backspace and Tab keys      
                    if (nKeyCode == 8 || nKeyCode == 9)
                        return;
                    if (nKeyCode < 95) {
                        if (nKeyCode < 48 || nKeyCode > 57)
                            e.preventDefault();
                    }
                    else {
                        if (nKeyCode < 96 || nKeyCode > 105)
                            e.preventDefault();
                    }
                }
            });
        });
    </script>

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";
        }