【初学者求教】取出今天的数据,显示到gridview中

Question

数据库表table1如下：         ID                 Name               Time
         1                   A            2010-3-24 12:12:12
         2                   B            2010-3-24 13:12:12
         3                   C            2010-3-24 14:12:12
         4                   D            2010-3-25 10:12:12
         5                   E            2010-3-25 11:12:12
         6                   F            2010-3-25 11:12:12前三行是昨天的数据，后三行是今天的数据。
是不是应该用这个变量去查询数据库—> string dt = DateTime.Now.ToString("yyyy-MM-dd");写了一下，代码如下，如果没问题的话，请帮忙写个SQL语句，多谢了！！     string dt = DateTime.Now.ToString("yyyy-MM-dd");
     System.Data.DataTable dt = new System.Data.DataTable();
        DataSet dsData = null;        string sql = "这句应该怎么写？";
        SqlCommand cmd = new SqlCommand(sql, connection);
        SqlDataAdapter daAdapter = new SqlDataAdapter();
        daAdapter.SelectCommand = cmd;
        dsData = new DataSet();
        daAdapter.Fill(dsData);        connection.Close();        dt = dsData.Tables[0];
        GridView1.DataSource = dt;
        GridView1.DataBind();

Answer 1

    
System.Data.DataTable dt = new System.Data.DataTable();
        string sql = "select * from table1";
        SqlCommand cmd = new SqlCommand(sql, connection);
        SqlDataAdapter daAdapter = new SqlDataAdapter();
        daAdapter.SelectCommand = cmd;
        dsData = new DataSet();
        daAdapter.Fill(dt);
        connection.Close();        GridView1.DataSource = dt;
        GridView1.DataBind();

Answer 2

select * from test where [time] > CONVERT (date, GETDATE())

Answer 3

string sql = "select * from tb where convert(varchar(10),Time,120)='"+dt +"'";
或datediff

Answer 4

using(SqlConnection conn=new SqlConnection(""))
{}

Answer 5

方法很多，我给个c#中来处理的方法
foreach(datarow dr in dt.Rows)
{
if (((string)dr["time"]).contains(DateTime.Now.Month + "-" + DateTime.Now.Day)
{
//加入新的DataTable中
}
}

Answer 6

查询当天数据也可以这样:
select * from table1 where [Time] between
 convert(varchar(10),getdate(),20) and convert(varchar(10),getdate(),20)+' 23:59:59'

Answer 7

给你一个简单的例子 
   class CyDa
    {       
        SqlDataAdapter da = null;
        public static string sqlconnString;
        //string sqlconnString = "server=ouyanghuai;database=djnberp;uid=sa;pwd=2431864";
        public SqlConnection sqlcon = new SqlConnection();
        public System.Data.DataSet getDs(DataSet ds,string sqlstr)
        {            
            sqlcon = new SqlConnection(sqlconnString);            
            if (sqlcon.State == ConnectionState.Closed)
            {
                sqlcon.Open();
            }
            da = new SqlDataAdapter(sqlstr,sqlcon);
            ds.Clear();
            da.Fill(ds);
            sqlcon.Close();
            return ds;
        }        public  DataSet GetDataSetProce(DataSet ds,SqlCommand cmd)
        {           //string strProce ,
            SqlDataAdapter ada = new SqlDataAdapter();                 
            dbOpen();           
            ada.SelectCommand = cmd;
            cmd.Connection = sqlcon;           
            ada.Fill(ds);
            dbClose();
            return ds;
        }

Answer 8

汗把名字搞上去了，        public void dbOpen()
        {
            sqlcon = new SqlConnection(sqlconnString);
            if (sqlcon.State == ConnectionState.Closed)
            {
                sqlcon.Open();
            }
        }
        public void dbClose()
        {
            if (sqlcon.State == ConnectionState.Open)
            {
                sqlcon.Close();
            }
        }
        public System.Data.DataTable getDt(DataTable dt, string sqlstr)
        {
            dbOpen();
            da = new SqlDataAdapter(sqlstr, sqlcon);
            dt.Clear();
            da.Fill(dt);
            dbClose();
            return dt;
        }
        private DataSet GetDataSet(string sqlstr, object connection, CommandType commandType)
        {
            DataSet ds = new DataSet();
            SqlDataAdapter ada = new SqlDataAdapter();
            cmd = new SqlCommand();
            dbOpen();
            ds.Clear();
            ada.SelectCommand = cmd;
            cmd.Connection = sqlcon;
            cmd.CommandText = sqlstr;
            cmd.CommandType = commandType;
            ada.Fill(ds);
            dbClose();
            return ds;
        }

Answer 9

 GridView的绑定列就有一个属性可以改变时间的输出格式dataformatstring="0:{yy-MM-dd}"

Answer 10

select * from table where [Time] between '0:0:0'
convert(varchar(10),getdate(),20) and convert(varchar(10),getdate(),20)+' 23:59:59'

Answer 11

select * from TableName where [Time] > CONVERT (date, GETDATE())