Click here to Skip to main content
11,490,801 members (74,797 online)
Rate this: bad
Please Sign up or sign in to vote.
See more: C#
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
Edited 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
0 Sergey Alexandrovich Kryukov 521
1 Andy Lanng 288
2 Sascha Lefèvre 240
3 Maciej Los 195
4 OriginalGriff 173
0 Sergey Alexandrovich Kryukov 9,713
1 OriginalGriff 8,475
2 Sascha Lefèvre 3,544
3 Maciej Los 3,106
4 Richard Deeming 2,370

Advertise | Privacy | Mobile
Web04 | 2.8.150520.1 | Last Updated 27 Dec 2012
Copyright © CodeProject, 1999-2015
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