Able to write to asp.Net listbox one record id at a time

Abraham Olatubosun

Dear all,

I want to trust that this mail meet you all in good health, i am processing some records from a database, i want each record unique id to be written into an asp.net ListBox after it has been processed,

i have tried

string SQLS = "Select * from Patient_Identifier where Patient_id <> '10'";
var DF = new DataTable();
DF = conn.GetMySQL(ref SQLS);
foreach (DataRow p in DF.Rows)
{
PUID = p["identifier"].ToString().Trim();
ListBox1.Items.Add(PUID + " added to Person and Patient Successfully..");
PUID = "";
cnt++;
}

the above sample will write these records ID at once into the ASP.NET ListBox, what i wanted is as after each record is processed it will write it unique ID to the ListBox before processing another one.

Thank you for yor help

2 Replies

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

Abraham Olatubosun7y ago
Many thanks Salman,

You are right i actually get the Patient Unique ID (PUID), what i really want is the patient ID will only write to the list box after proceesing is done on the PUID, that is, patient ID will be displayed one after the other, unlike the one you respond to that will display all the PUID at once.

Thanks again
Salman Beg7y ago
Hi. Already you are retrieving unique id in this line PUID = p["identifier"].ToString().Trim(); right. So in the next loop it will get the next identifier and so on. Thanks