protected void BindGridViewCollectionData()
{
string FromDate = txtFromDate.Text;
string ToDate = txtToDate.Text;
string condition = string.Empty;
DataSet ds = new DataSet();
string Stateid = App_Code.Global.GetSelectState(ref lstState, false);
string siteid = App_Code.Global.GetSelectState(ref lstSiteId, false);
string CustGroup = App_Code.Global.GetSelectState(ref lstCustGroup, false);
string BuList = App_Code.Global.GetSelectBUList(ref lstbu, false);
string CustList = App_Code.Global.GetSelectCustMaster(ref lstCust, false);
string strQuery = "EXEC USP_GETVRSSPDISCOUNTREPORT '" + Stateid + "','" + siteid + "','" + BuList + "','" + CustGroup + "','" + CustList + "','" + Session["USERID"].ToString() + "','" + Session["LOGINTYPE"].ToString() + "','" + FromDate + "','" + ToDate + "' ";
ds = baseObj.GetDsData(strQuery);
if (ds.Tables.Count > 0)
{
gvDetails.DataSource = ds.Tables[0];
gvDetails.DataBind();
grdSummary.DataSource = ds.Tables[1];
grdSummary.DataBind();
}
}