Getting data from SQL server and send that as XML to a restful webservice using C#

See more:

ASP

C#7.0

Hi all.

I need to get I have a url from outside that in need to post data to as xml.

this data comes from my sql server. I need to use C# for this functionality.

What I have tried:

Im currently writing this data to a file.

I need to do this per row from a database:

here is what I have so far.

connetionString = ConfigurationManager.ConnectionStrings["CompanyConnectionString"].ConnectionString;
           connection = new SqlConnection(connetionString);
           sql = "select * from Employee";
           try
           {
               connection.Open();
               adapter = new SqlDataAdapter(sql, connection);
               adapter.Fill(ds);
               connection.Close();
               //Label1.Text = (ds.WriteXml);

               ds.WriteXml("c:/temp/Product.xml");
               Response.Write("Done");
           }
           catch (Exception ex)
           {
               Response.Write(ex.ToString());

           }