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());
}
}
