我该怎么做才能满足条件？ [英] How do I do this so condition is met?

问题描述

我尝试过以下代码但不会工作



我尝试过的事情：

 使用（SqlConnection con =  new  SqlConnection（strConnString） ）
 {
  string  strQuery =   SELECT * FROM LoanRates，其中DateTime.Now介于LoanAvailableFrom和LoanAvailableTo之间; 
 SqlCommand cmd =  new  SqlCommand（strQuery）; 
 使用（SqlDataAdapter sda =  new  SqlDataAdapter（））
 {
 cmd.Connection = con; 
 con.Open（）; 
 sda.SelectCommand = cmd; 
 sda.Fill（da）; 
 GridView1.DataSource = da; 
 GridView1.DataBind（）; 
 
} 
} 

解决方案

如果应用程序和数据库位于同一服务器或位置，你可以用这个

  string  strQuery =   SELECT * FROM LoanRates LoanAvailableFrom和LoanAvailableTo之间的 getdate（）; 

else

  string  strQuery =   SELECT * FROM LoanRates，其中@date介于LoanAvailableFrom和LoanAvailableTo之间; 
 SqlCommand cmd =  new  SqlCommand（strQuery）; 
  string  date = DateTime.Now.ToString（  YYYY-MM-DD）;  //  检查表格中的格式 
 cmd.Parameters.Add（  @ date，date）; 

请尝试使用此行：

  string  dt = DateTime.Now.ToString（  yyyy-MM-dd）; 
  string  strQuery =   SELECT * FROM LoanRates其中 + dt +   LoanAvailableFrom和LoanAvailableTo; 

I tried codes below but wont work

What I have tried:

using (SqlConnection con = new SqlConnection(strConnString))
{
    string strQuery = "SELECT * FROM LoanRates where DateTime.Now between LoanAvailableFrom and LoanAvailableTo";
    SqlCommand cmd = new SqlCommand(strQuery);
    using (SqlDataAdapter sda = new SqlDataAdapter())
    {
        cmd.Connection = con;
        con.Open();
        sda.SelectCommand = cmd;
        sda.Fill(da);
        GridView1.DataSource = da;
        GridView1.DataBind();

    }
}

解决方案

If the Application and Database is in same server or location, you could use this

string strQuery = "SELECT * FROM LoanRates where getdate() between LoanAvailableFrom and LoanAvailableTo";

else

string strQuery = "SELECT * FROM LoanRates where @date between LoanAvailableFrom and LoanAvailableTo";
           SqlCommand cmd = new SqlCommand(strQuery);
           string date = DateTime.Now.ToString("yyyy-MM-dd"); // check the format in your table
           cmd.Parameters.Add("@date", date);

Try this line instead :

string dt = DateTime.Now.ToString("yyyy-MM-dd");
string strQuery = "SELECT * FROM LoanRates where " + dt +" between LoanAvailableFrom and LoanAvailableTo";

这篇关于我该怎么做才能满足条件？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！