public void BindVendorGrid()
        {
            objService = new ServeAtDoorstepService();
            DataTable dtVend = objService.SelectVendorByService(intServiceID);

            if (dtVend.Rows.Count > 0)
            {
                //decimal dPageSize = (dt.Rows.Count / 4M);
                //GridView1.PagerSettings.PageButtonCount = Convert.ToInt32(Math.Floor(dPageSize));
                //GridView1.PageSize = Convert.ToInt32(Math.Ceiling(dPageSize));
            }
            gvVendor.DataSource = dtVend;
            gvVendor.DataBind();
        }
        public void LoadVendorDiv()
        {
            objService = new ServeAtDoorstepService();
            DataTable dtVendor = objService.SelectVendorByService(intServiceID);
            int intCityCount = 0;
            string[] strVendorCity = new string[dtVendor.Rows.Count];
            string strDivVendor = "";
            if (dtVendor.Rows.Count > 0)
            {
                for(int i=0;i<dtVendor.Rows.Count;i++)
                {
                    strVendorCity[i] = dtVendor.Rows[i]["VendorCity"].ToString();
                }
            }

            int intTotalCount = 0;
            for (int i = 0;( i < strVendorCity.Length && intTotalCount < strVendorCity.Length); i++)
            {
                intCityCount=0;
                int Available = 0;
                for (int j = i; j < strVendorCity.Length; j++)
                {
                    for (int k = 0; k < i; k++)
                    {
                        if (strVendorCity[i] == strVendorCity[k])
                            Available = 1;
                    }

                    if (Available == 1) break;
                    if (strVendorCity[i] == strVendorCity[j] )
                    {
                        intTotalCount++;
                        intCityCount++;
                    }
                }

                if (Available == 0)
                {
                    strDivVendor += "<img src='image/locationg.png' height='40px' width='40px' />&nbsp;&nbsp;" +
                                         strVendorCity[i] + "(&nbsp;<span style='color:blue;'><strong>" + intCityCount.ToString() + "</span></strong>&nbsp;)<br/>";
                }
            }

            divVendor.InnerHtml = strDivVendor;
            if (dtVendor.Rows.Count == 0)
                divVendor.InnerHtml = "No Vendors";
        }