private void DisplayData() { string vWhere = string.Empty; if (!string.IsNullOrEmpty(txtFilter.Text)) { vWhere = " AND StockWastage.Remarks Like '%" + txtFilter.Text + "%'"; } vWhere += string.Format(" And convert(datetime,Convert(varchar,StockWastage.EntryDate,1)) Between Convert(Datetime,(convert(varchar,convert(Datetime,'{0} 00:00:00',102),1)))and Convert(Datetime,(convert(varchar,convert(Datetime,'{1} 00:00:00',102),1)))", dt_From.Value.ToShortDateString(), dt_ToDate.Value.ToShortDateString()); if (vIsFromReturn) { vWhere += " AND SaleID NOT IN (Select SaleID From SaleReturn)"; } try { DAL.StockWastage objDAL = new DAL.StockWastage(); objDAL.connectionstring = connectionString; dt = objDAL.getSearchRecord(vWhere); Grid.AutoGenerateColumns = false; Grid.DataSource = dt; } catch (Exception exc) { MessageBox.Show(exc.Message.ToString()); } }