Tender show Three Days :

SqlDataAdapter da5 = new SqlDataAdapter("select * from idco_tender where sale_date > getdate() and sale_date < DATEADD(day, 3, sale_date) ", con);

        DataSet dt5 = new DataSet();

        da5.Fill(dt5);

            if (dt5.Tables[0].Rows.Count > 0)

            {

                GridView3.Visible = true;

                Label1.Visible = false;

                GridView3.DataSource = dt5;

                GridView3.DataBind();

            }

          else

            {

                Label1.Visible = true;

                GridView3.Visible = false;

                Label1.Text = "Active Tender not Found";

            }