ASP.NET - How to filter row from dataset - Asked By bhanupratap singh on 20-Nov-15 07:32 PM
I want to filter record from dataset with three parameters
How to filter data passing three parameters. I want get record from the dataset which date are between fromdate and todate and like clause is on one parameter
My query is below
DataRow[] dr = dtt.Select("(Subject like '%') '"+txtSearch.Text+"' AND Message Date >='"+startDate+"'AND Message Date = '"+txtSearch.Text+"'");
if (dr != null && dr.Length > 0)
{
DataTable dt = dr.CopyToDataTable();
grdMessageDetails.DataSource = dt;
grdMessageDetails.DataBind();
}
else
{
grdMessageDetails.DataSource = null;
grdMessageDetails.DataBind();
}
It is not working.
How to achieve this.
Thanks
This is also not working
DataRow[] dr = vsMasterDataSet.Tables[0].Select("[Subject] like'" + txtSearch.Text + "%" + "' AND [Message Date]>='"+Convert.ToDateTime(startDate.ToString("MM/dd/yyyy"))+"' AND [Message Date]<='"+Convert.ToDateTime(EndDate.ToString("MM/dd/yyyy"))+"' ");