What datastream API can I use to get price history of a index e.g FTSE100 using .net
You can use Datastream Web Service in Microsoft Visual Studio. For instructions see the tutorial titled "DSWS Tutorial - Microsoft Visual Studio".