我在sqlquery中使用datepart查询如何在设计页面代码中编写该查询 [英] i use datepart query in sqlquery how to write that query in design page code

问题描述

第一个查询：

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.

这篇关于我在sqlquery中使用datepart查询如何在设计页面代码中编写该查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！