i need days countdown in gridview

hello guys

I need this code please in c#

I have employees table in the SQL server and it is shown in WinForm in gridview

the table has an EndTime column and Holiday date column so I need the endtime in gridview countdown how many days left

You can execute below query and bind to gridview.

SELECT EndTime, (DATEDIFF(days, HolidayDate, EndTime)- DATEDIFF(days, HolidayDate, GETDATE())) AS Counttdown FROM TableName

Gridview Sample.

C# to bind Query

string query = "SELECT EndTime, (DATEDIFF(days, HolidayDate, EndTime)- DATEDIFF(days, HolidayDate, GETDATE())) AS Countdown FROM TableName";
using (SqlConnection con = new SqlConnection(constr))
{
using (SqlCommand cmd = new SqlCommand(query))
{
using (SqlDataAdapter sda = new SqlDataAdapter())
{
cmd.Connection = con;
sda.SelectCommand = cmd;
using (DataSet ds = new DataSet())
{
sda.Fill(ds);
gvCountDown.DataSource = ds;
gvCountDown.DataBind();
}
}
}
}

You can write above code in Page_Load.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.