public void Bind(string selectedval) { string from = txtFromDate.Text.Split('/')[1].ToString() + "/" + txtFromDate.Text.Split('/')[0].ToString() + "/" + txtFromDate.Text.Split('/')[2]; string to = txtToDate.Text.Split('/')[1].ToString() + "/" + txtToDate.Text.Split('/')[0].ToString() + "/" + txtToDate.Text.Split('/')[2]; DateTime FromDate = Convert.ToDateTime(from); DateTime ToDate = Convert.ToDateTime(to); DataSet dt = new DataSet(); dt = PurchaseDetails.GetPurchaseRegister(FromDate, ToDate, Convert.ToInt32(strFY), txtEMcode.Text.Trim(), ddlSD.SelectedValue.ToString() + selectedval); ViewState["Total"] = dt.Tables[1]; if (dt.Tables[0].Rows.Count != 0) { grdDetails.DataSource = dt; grdDetails.DataBind(); } else { MessageBox("No Record Found"); } }