DateTime Todaydate = DateTime.Now; DateTime Pridaydate = DateTime.Now.AddDays(-5); int TotalPendingOrder = 0; SqlConnection con = new SqlConnection(ConnString); con.Open(); string Qry = "select COUNT(*) from OrderMaster where OrderDate between CONVERT(CHAR(10),'" + Pridaydate + "',112) and CONVERT(CHAR(10),'" + Todaydate + "',112) and OrderStatus='Confirm'"; SqlDataAdapter da = new SqlDataAdapter(Qry, con); DataTable dt = new DataTable(); da.Fill(dt); if (dt.Rows.Count > 0) { Summary.Visible = true; TotalPendingOrder = dt.Rows.Count; lblpending.Text = "There are " + " " + TotalPendingOrder.ToString() + " Orders Pending From Last 5 Days Please Shipped that order." + "<br/>" + " To Ship that order Please"; }
select COUNT(*) from OrderMaster where OrderDate between CONVERT(CHAR(10),(GETDATE()-5),112) and CONVERT(CHAR(10),GETDATE(),112) and OrderStatus='Confirm'
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)