Click here to Skip to main content
Rate this: bad
good
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 2:37am
Edited 27-Dec-12 3:28am
v2

1 solution

Rate this: bad
good
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();
        da.Fill(dt);
 
        Response.Write(dt.Rows[0]["TTT"].ToString());
 
 

Mark solution as Answer if it works for you.
  Permalink  

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 480
1 mhegazy94 460
2 Ravi Bhavnani 190
3 Kornfeld Eliyahu Peter 185
4 Shemeemsha RA 160
0 Sergey Alexandrovich Kryukov 7,135
1 OriginalGriff 6,801
2 CPallini 5,350
3 George Jonsson 3,619
4 Gihan Liyanage 2,797


Advertise | Privacy | Mobile
Web01 | 2.8.140922.1 | Last Updated 27 Dec 2012
Copyright © CodeProject, 1999-2014
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