我在sqlquery中使用datepart查询如何在设计页面代码中编写该查询
问题描述：
第一个查询：
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";
从上面的第一个查询中，如何在第二个SQL查询中添加datepart查询。
第二个查询是指想写在staff.aspx.cs页面。
请使用上面的代码发送代码。
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.
答
试试这个，它的工作正常。我测试了它。
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.