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' /> " + strVendorCity[i] + "( <span style='color:blue;'><strong>" + intCityCount.ToString() + "</span></strong> )<br/>"; } } divVendor.InnerHtml = strDivVendor; if (dtVendor.Rows.Count == 0) divVendor.InnerHtml = "No Vendors"; }