Diff betweeen Jquery and Javascript

Javascript:

JavaScript is a scripting language that was designed for use within a web browser. Typically, JavaScript is used for interface interactions. Slideshows and other interactive components are typically done using JavaScript.

Jquery:

This will work on top of the javascript where it has the script plugins which can use flexible and easy to write functions, event handlers.

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