get all procedures in SQL server

select * from sysobjects where type ='p' order by crdate desc

                  or

--->>Getting Specified procedure Details

SELECT name, create_date, modify_date
FROM sys.objects
WHERE type = 'P'
AND name = 'SP_NAME'

List Out all Tables and Procedures From SQL Database

select * from sys.tables

Select * from sys.procedures 

Refreshing the Asp.net Webpage

  <meta http-equiv="refresh" content="60"/>

Getting page name from URL's

         string sourcePath = Request.RawUrl;/*this for mapped URL*/
            string destPath = Request.Url.AbsolutePath;/*this is for URL*/
            System.IO.FileInfo fInfo= new System.IO.FileInfo(sourcePath);
          string pagename=fInfo.Name.ToString();

getting Querystring value from MAPPED URL

-->> pass like{sample.aspx?id=1}    


 if (Request.RawUrl.LastIndexOf("id=") != -1)
            {
                int index = Request.RawUrl.LastIndexOf("id=");
               string  id = Request.RawUrl.Substring(index + 3);
            }

Working With Generics

working with generics

create a class-->>declare the properties/variable-->>with in the class create a Method with inherited one(here it will be inherited from the Interface{Class:Interface})


public class sample:ICreatable
{
  public string ramu {get;set;}

   public void Create(SqlDataReader Reader)
   {
    ramu=Convert.ToString(Reader["DBname"]);
   }
}

/*------this is the list-------*/

List<sample> sampledata = new List<sample>();


public class DAGetList
{
    public static List<T> GetListFromCommand<T>(SqlCommand sqlcmd)
    where T : ICreatable, new()
    {
        List<T> results = new List<T>();
        using (sqlcmd.Connection)
        {
            sqlcmd.Connection.Open();
            SqlDataReader sdr = sqlcmd.ExecuteReader();
            while (sdr.Read())
            {
                T newthing = new T();
                newthing.Create(sdr);
                results.Add(newthing);
            }
        }
        return results;
    }
}

public interface ICreatable
{
    void Create(SqlDataReader reader);
}

Downloading file from Physicalpath in asp.net

string filePath= ConfigurationManager.AppSettings["physicalpath"].ToString() + "Members\\filename";;
Response.AddHeader("Content-Disposition", "attachment;filename=\"" + filePath + "\"");
Response.TransmitFile(filePath);
Response.End();