private void GetSalesManager()
    {
        DataTable ds = new DataTable();

        try
        {
            ds = ClsSalesManagerChecking.Get_SalesOrder(Convert.ToDateTime(Txt_FromDate.Text.Trim()), Convert.ToDateTime(Txt_ToDate.Text.Trim()));
            GvwSalesManagerChecking.DataSource = ds;
            GvwSalesManagerChecking.DataBind();

            if (ds.Rows.Count > 0)
            {
                lblmessage.Text = "";
            }
            else
            {
                lblmessage.Text = "No Records Found...";
            }
            ViewState["Data"] = ds;
            ds.Dispose();
            if (ViewState["PageINdex"] != null)
            {
                GvwSalesManagerChecking.PageIndex = Convert.ToInt32(ViewState["PageINdex"].ToString());
            }
        }
        catch (Exception ex)
        {
        }
    }
    private void GetSalesManager()
    {
        DataTable ds = new DataTable();

        try
        {
            ds = ClsDeliveryChallan.Get_SalesOrderForDC(Convert.ToDateTime(Txt_FromDate.Text.Trim()), Convert.ToDateTime(Txt_ToDate.Text.Trim()));
            GvwSalesManagerChecking.DataSource = ds;
            GvwSalesManagerChecking.DataBind();
            ViewState["Data"] = ds;
            ds.Dispose();
            if (ViewState["PageINdex"] != null)
            {
                GvwSalesManagerChecking.PageIndex = Convert.ToInt32(ViewState["PageINdex"].ToString());
            }
        }
        catch (Exception ex)
        {
        }
    }