How to convert DateTime to Date in sql server like dd/mm/yyyy,mm/dd/yyyy,yyyymmdd,dd-mm-yyyy etc | C#.NET,ASP.NET,Aspdotnet,SQL Server,Ajax Samples and Tutorials

http://dotnetinfomedia.blogspot.com/

Diffrent Date Time format

SQL Query = SELECT CONVERT(VARCHAR(10),GETDATE(),111)
Result=2011/10/13

SQL Query =  SELECT DISTINCT CONVERT(VARCHAR(11),(date)) FROM user_log
Result=Oct 11 2011

SQL Query =SELECT Convert(char(2),DATEPART(hour, GETDATE())) + ':'+convert(char(2),datepart(mi,getdate())) + ':' + convert(char(2),datepart(s,getdate()))
Result=11:20:36

SQL Query = select substring(convert(varchar(20),date),12,8) as TheTime FROM user_log
Result=10:31PM

UserControl Enable and Disable in asp.net

Hi,

        //    In Page_Load


          uname = Page.User.Identity.Name;// Find the user Role who is logged in
        Control admin = Page.FindControl("~/_controls/UC1");
        Control user = Page.FindControl("~/_controls/UC2");
        if (Roles.IsUserInRole("Admin"))
        {
                ((UserControl)AdminMenu1).Visible = true ;
                ((UserControl)UserMenu1).Visible = false;
                Panel_status.Visible = true;
                 
        }
        else if (Roles.IsUserInRole("User"))
        {
         
            ((UserControl)UC1).Visible =false;
            ((UserControl)UC2).Visible = true;
            Panel_status.Visible = false;

        }