How to stop FOREACH loop without breaking out of the loop

Dear friends,

Best of the day, i will apreciate any solution from you,

i am writting a program that loop through set of records in a database

this database contain duplicate records to loop through the records i am

fist use a sql statement to pass the records to a datatable

Select Distinct * from tbl_PatientsTable

i then use the following statement to loop through the record, where i find thesame record ID coming back it should skip it and take the next record it that way i will not display duplicates,

var PatientIDs = "";
DT1 = ConnectAll.LastDrugPickup(TextBox1.Text.Trim(), TextBox2.Text.Trim());
foreach (DataRow r in DT1.Rows)
{
if (PatientIDs == r["PatientID"].ToString().Trim()) { break; }
do other things ......
}

But my problem is break command make the loop to happend only once.

please how can i resolve this without using break and be able to fetch my records with no duplicates, since DISTINCT could not help.

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Sakthivel Ganesan9y ago
Hi,

You said that table tbl_PatientsTable would contain duplicate patient records. How would you find out the correct one if the same patient contains two records? I mean, what is logic to find out the correct patient record if there is more than one.

You said that break command makes the loop run only once. I think the variable PatientIDs is declared with empty and r["PatientID"].ToString().Trim() is also empty (I suppose). Therefore it's getting break.

Thanks,
Sakthi.