protected DataTable GetAllTransInfoByReferenceCode() { List <string> ssReferenceCodeFINAL = new List <string>(); ssReferenceCodeFINAL = (List <string>)Session["ssReferenceCode"]; string stReferenceCode1 = string.Empty; string stReferenceCode2 = string.Empty; for (int i = 0; i < ssReferenceCodeFINAL.Count; i++) { if (i == 0) { stReferenceCode2 = stReferenceCode1.ToString() + ssReferenceCodeFINAL[i].ToString(); } else { stReferenceCode2 = stReferenceCode1.ToString() + "," + ssReferenceCodeFINAL[i].ToString(); } stReferenceCode1 = stReferenceCode2; } dt = new DataTable(); dt = sqlTRANSProvider.GetAllTransInfoByReferenceCodeForReport(stReferenceCode1); return(dt); }
protected DataTable GetAllTransInfoByReferenceCode() { dt = new DataTable(); dt = sqlTRANSProvider.GetAllTransInfoByReferenceCodeForReport(txtReferenceCode.Text); return(dt); }
protected DataTable GetAllTransInfoByReferenceCode() { dt = new DataTable(); dt = sqlTRANSProvider.GetAllTransInfoByReferenceCodeForReport("11AFS140,11AFS141,11AFS142"); return(dt); }