Build XML from SQL Server Stored Procedure output in C# .Net

You can get the Data from SQL into Dataset. Now from DataSet you can get the XML string like this,

string xml = ds.GetXml();

 Code to get the Data in DataSet

string conString = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
using (SqlConnection con = new SqlConnection(conString))
{
    using (SqlCommand cmd = new SqlCommand("Employees_GetEmployees"))
    {
        using (SqlDataAdapter sda = new SqlDataAdapter())
        {
            cmd.Connection = con;
            cmd.CommandType = CommandType.StoredProcedure;
            sda.SelectCommand = cmd;
            DataSet ds = new DataSet();
            sda.Fill(ds);
        }
    }
}