datbases and c#
I'm trying to make this thing thats hard coded dynamic and trying to convert it from coldfusion to C#. In my program Im trying to get information from a field called 'fields' in the database called 'Exporter'. The only thing is that for every row in the field called 'fields' it contains different information. Lets say the id is equal to '1001', then the 'fields' field would contain a bunch of fields like this 'plan_id, pcode, relcode, e_over, lastname, firstname, coveragetype' etc etc etc. But I only want to get everything BUT the last and first names. Is there a way to do that dynamically, to get the list from the fields field?
By the way they are all different, if the id was equal to '1002' he would have something like "action_id, lastname, coverage type, group_id" but then i would only want to get the action_id and group _id from that list. They arent equal to anything, they are just merely strings that I would like to get from the field 'fields'.
What is the format of the data that is in the "fields" field? Text? If so, how is it formatted.
Hey sorry it took me a while to get back to you, instead i created a new database with those fields, and I fixed it, thanks anyways though!