Last post Oct 02, 2013 12:20 PM by smirnov
Oct 01, 2013 11:35 AM|banksidepoet|LINK
I have an issue in which I need to replace an array with SQL data. I have used code direct from a Microsoft HowTo which uses an array. This code works perfectly but my data is in a SQL table.
I have posted the issue to the ADO.NET Forum but have had no response so I am broadenening my request a little (as C# is also intrinsically involved). I have even posted this in the OpenXML forums but no-one has answered. This is quite a surprise as, surely,
most people who want to use OpenXML will have data in a database not an array...
Please see here (http://forums.asp.net/t/1939763.aspx?How+to+replace+an+array+with+sql+data) and don't hesitate to ask for clarification if required. Basically the issue
is simple: how to take the array and replace it with a SQL Command and how to take the C# nested For loop and replace it with (I'm guessing) a ADO.NET DataReader.
Thank you in advance for any help.
Oct 02, 2013 12:20 PM|smirnov|LINK