private void FillDataTableWithRequiredData(DataTable myDataTable) { try { DataSet ds = new DataSet(); DataSet dsDefault = new DataSet(); Banner objB = new Banner(); ds = objB.GetBannerList(); if (ds.Tables[0].Rows.Count > 0) { for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { int BannerId = 0; int BId = 0; string BannerName = ""; string BannerPath = ""; string UsedForms = ""; string virtualmobilepath = ""; BId = Convert.ToInt32(ds.Tables[0].Rows[i]["BId"]); BannerId = Convert.ToInt32(ds.Tables[0].Rows[i]["BannerId"]); BannerName = Convert.ToString(ds.Tables[0].Rows[i]["BannerName"]); BannerPath = Convert.ToString(ds.Tables[0].Rows[i]["BannerPath"]); virtualmobilepath = Convert.ToString(ds.Tables[0].Rows[i]["virtualmobilepath"]); //Find Set Banner DataSet ds1 = new DataSet(); ds1 = objB.CheckUsedBannerList(BannerId); string FormNameList = ""; if (ds1.Tables[0].Rows.Count > 0) { for (int k = 0; k < ds1.Tables[0].Rows.Count; k++) { string pgNm = ""; pgNm = Convert.ToString(ds1.Tables[0].Rows[k]["pageName"]); FormNameList = FormNameList + ", " + pgNm; } FormNameList = FormNameList.Remove(0, 1); } //Find is Banner Set Default For any Form DataSet ds2 = new DataSet(); ds2 = objB.CheckUsedDefaultBanner(BannerId); if (ds2.Tables[0].Rows.Count > 0) { for (int j = 0; j < ds2.Tables[0].Rows.Count; j++) { FormNameList = FormNameList + ", Default-" + Convert.ToString(ds2.Tables[0].Rows[j]["pageName"]); } } if (FormNameList.Length == 0) { FormNameList = "NOT IN USE"; } UsedForms = FormNameList; AddDataToTable(Convert.ToString(BannerId), BannerName, BannerPath, UsedForms, myDataTable, Convert.ToString(BId), virtualmobilepath); } } } catch { } }