i need days countdown in gridview

Question

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

Rijwan Ansari · Answer

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. "gvountDown" runat= "server" AutoGenerateColumns= "false" > "EndTime" HeaderText= "EndTime" ItemStyle-Width= "150px" /> "CountDown" HeaderText= "City" ItemStyle-Width= "100px" /> 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; gv CountDown .DataBind(); } } } } You can write above code in Page_Load.

KHALID ALSABBALI · Answer

sda.Fill(ds); gvCountDown.DataSource = ds; gvCountDown.DataBind(); i have this error databind under red line

i need days countdown in gridview

Answers (2)