Click here to Skip to main content
13,293,894 members (55,986 online)
Rate this:
Please Sign up or sign in to vote.
See more:
1st query:
select Name,DOB = case datepart(year,dob) when '1900' then ''else CONVERT(varchar, DOB, 103) end,Mobileno as Mobile_Number,Wedding = case datepart(year,Weddingday) when '1900'  then '' else CONVERT(varchar, Weddingday, 103) end,EMail as E_Mail  from BirthDayWish where Active = 'A' ORDER BY Name

I have written this query and it is working fine.

In the design page I write the query as follows (2nd query):
Sql = "select Name,CONVERT(varchar, DOB, 103) AS Date_of_birth,Mobileno as Mobile_Number,CONVERT(varchar, Weddingday, 103) AS Wedding_Day,EMail as E_Mail  from BirthDayWish where Active = 'A' ORDER BY Name";

From the above 1st query how to add the datepart query in the 2nd SQL query.
The 2nd query refers to want to written in staff.aspx.cs page.

Please send the code from using my above code.
Posted 27-Dec-12 3:37am
Updated 27-Dec-12 4:28am

1 solution

Rate this: bad
Please Sign up or sign in to vote.

Solution 1

Try this, its working fine. I have tested it.
        SqlCommand command;
        command = new SqlCommand();
        command.Connection = DBConnection;
        command.CommandType = CommandType.Text;
        command.CommandText = "select case DATEPART(year,LastUpdated_Date) when '2012' then '-' else CONVERT(varchar, LastUpdated_Date, 103) end as TTT, DATEPART(year, LastUpdated_Date) as myYEAR from Candidate where Candidate_Code = 49";
        SqlDataAdapter da = new SqlDataAdapter(command);
        DataTable dt = new DataTable();

Mark solution as Answer if it works for you.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy |
Web03 | 2.8.171207.1 | Last Updated 27 Dec 2012
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100