I am trying to pass data from the database to pass into XML node. The data I am calling, has two columns (title, body) and will always have more than 2 or more rows. The method i have created below, is outputting
a null result, on the client-side.
Would I require a for loop before the XML code? Please advice further, if possible.
public static string createXML()
{
string xml = "";
string title = "";
string content = "";
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["########"].ConnectionString);
string commandtext = "######################";
SqlCommand command = new SqlCommand(commandtext, con);
c ...
Go to the complete details ...