Please don't repost your entire comment just to bump it. It was a holiday weekend in Canada so I wasn't checking the thread.
For your question, please read and understand what the code does. The variable, dcValue, is just the column I created for the purposes of your example. If your data table has a different column you want to split with, use that instead.
You don't need to construct dtMain... your adapter.Fill already gets you the dataset, so just pick the table you want and go from there. I think you can reference columns by names as well (look at DataTable.Colum ns["COLUMN_NAM E"]).
For your question, please read and understand what the code does. The variable, dcValue, is just the column I created for the purposes of your example. If your data table has a different column you want to split with, use that instead.
You don't need to construct dtMain... your adapter.Fill already gets you the dataset, so just pick the table you want and go from there. I think you can reference columns by names as well (look at DataTable.Colum ns["COLUMN_NAM E"]).
Comment