In vb.net you can use datepart function in a same way you are using in sql like : 
 Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
        Dim currdate As String = DatePart("d", DateTime.Now)
'and so on for others
    End Sub
But in c# you have to have to do some manipulation like  this :
  protected void Page_Load(object sender, EventArgs e)
    {
        DateTime currentdate = DateTime.Now;
        int minutes = currentdate.Minute;
        int seconds = currentdate.Second;
        int day = currentdate.Day;
        int month = currentdate.Month;
        //and so on for others ..................
    }
 
Hope this works for you