You could use a
DataTable like this:
using (SqlConnection conn = new SqlConnection(CONN_STR))
using (SqlDataAdapter da = new sqlDataAdapter("roboticSiteNames", conn)) {
DataSet ds = new DataSet();
da.Fill(ds);
DataTable dt = ds.Tables[0];
lbSiteCode.DisplayMember = dt.Columns[0].ColumnName;
lbSiteCode.ValueMember = dt.Columns[1].ColumnName;
lbSiteCode.DataSource = dt;
}
This is from an answer here:
Datatable to listbox[
^]
Then you can delete rows in the DataTable, see
How to: Delete Rows in a DataTable[
^]
This can also be done in a
DataSet, e.g.
NorthwindDataSet1.Customers.Rows(0).Delete()