Week Number from date in .Net

Hello friends,

I will show an example that find out week no. from date in VB.net.

Step 1: Imports System.Globalization in your page.
Step 2 : Now in your Page_load event of default.aspx page,paste the following code

Dim ciCurr As CultureInfo = Nothing
Dim intweekNo As Integer = 0
Dim intCalendarWeekRule = 0
Dim dteDate as DateTime=Now.Date
Try
ciCurr = CultureInfo.CurrentCulture
intweekNo = ciCurr.Calendar.GetWeekOfYear(dteDate, CalendarWeekRule.FirstFourDayWeek, DayOfWeek.Monday)
lblOutput.Text=intweekNo.ToString()
Catch ex As Exception
lblMessage.Text=ex.Message
Finally
End Try
Step:3 When you run the following code you will get the weekno. of current date.

Comments

Post a Comment

Popular posts from this blog

SQL Interview Questions

Image
SQL Interview Questions Q. Display names of all salesperson whose customers are john? Q. Display names of all salesperson whose customers are not john? Q. Insert   those records into a table highvale(name,age) from saleperson whose salary is 2000 or greater than ? Q.   Display name of customer who have 2 or more order ? Q. Display name of saleperson who have maximum amt in orders ? Q. Display name of saleperson,total of amt   who have maximum amt in orders ? Q.   Display 3 rd highest salary of salesperson (Assume there are 1000 records in salesperson table). Q. Difference between Delete and Truncate ? Q.   Select substr(‘shubh’,2) from dual ? Is this Query will run ? yes /No .If not then what will be correct Query ? Q.   Select Round(2.75,2) from dual, Select   trunc(2.75,2) from dual ? what will be output ? Q. Difference between CAST and Convert ? (note : both function may be or may...
Read more

How to Use Not IN operator

Hello Friends Here i am explaining an example of NOT IN operator. Suppose you have two tables one is employee and Bademployee employee and Bademployee has relationship. Bademployee contains records who are bad Now you want to show the Good employee so following is the example Step : 1 create Table emp Run this Query in your Query Analyzer for table emp 1) CREATE TABLE [dbo].[emp]( [empId] [int] NOT NULL, [empName] [nvarchar](max) NULL, CONSTRAINT [PK_emp] PRIMARY KEY CLUSTERED ( [empId] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] Now Run this Query in your Query Analyzer for table bademp CREATE TABLE [dbo].[bademp]( [empid] [int] NOT NULL, [bademp] [nvarchar](50) NOT NULL, CONSTRAINT [PK_bademp] PRIMARY KEY CLUSTERED ( [empid] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY...
Read more

Posting Blog After 10 year :)

 Hi All, Its been almost 10 years I haven't posted  anything  on my blog , As lot of changes happened during this tenure :) in my personal and professional life. Here I will talk only about my professional career and learning events related with it  :) Of course  I would share knowledge and cascade information what I have and  learnt concepts in my past 10 years with all of you So be Ready for my new posts !  Next Post on my Blog -  Cloud and How I cleared AZ-900 Microsoft Azure Fundamental exam and Why I choose fundamental  Regards Shubhank 'Google will tell  u SYNTAX ! 'But I will tell u  CONCEPTS '
Read more