Databases
StackOverflow2013
Postsdbo
POGenerate XML using C# from SQL Server Data
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POGenerate XML using C# from SQL Server Data
    primarykey
    data
    text
    <p>I have a query in SQL Server which generates an XML Output.</p> <p>I want to produce the same result using C#. Is it possible??</p> <p>The query is </p> <pre><code>select T1_1.HomeID as [@HomeID], ( select T1_2.DayID as [@ID], ( select T2.RndString+' '+left(T1_3.TimeValue, 5) as '*' from TB1 as T1_3 inner join TB2 as T2 on T1_3.DayID = T2.DayType and T1_3.TimeCode = T2.StringCode where T1_2.HomeID = T1_3.HomeID and T1_2.DayID = T1_3.DayID order by T2.StringCode for xml path('String'), type) from TB1 as T1_2 where T1_2.HomeID = T1_1.HomeID group by T1_2.DayID,T1_2.HomeID order by T1_2.DayID for xml path('Day'), type ) from TB1 as T1_1 group by T1_1.HomeID order by T1_1.HomeID for xml path('Person'), root('Persons') </code></pre> <p>For further details regarding this refer to my earlier post. <a href="https://stackoverflow.com/questions/16686554/producing-xml-from-multiple-tables-in-sql-server/16689035#16689035">Producing XML from Multiple Tables in SQL Server</a>.</p> <p>I am extremely poor in C#. A beginner of sorts. Do need some help here.</p> <p>The code i used is...</p> <pre><code> using System; using System.Collections.Generic; using System.Linq; using System.Windows.Forms; using System.Text; using System.Data; using System.Data.SqlClient; namespace SQL__ { static class Program { /// &lt;summary&gt; /// The main entry point for the application. /// &lt;/summary&gt; [STAThread] static void Main() { // Create a String to hold the database connection string. // NOTE: Put in a real database connection string here or runtime won't work string sdwConnectionString = @"Data Source=IE1ADTBD5ZL1S\;Initial Catalog=RecommendEngine;Integrated Security=True"; // Create a connection SqlConnection sdwDBConnection = new SqlConnection(sdwConnectionString); // Open the connection sdwDBConnection.Open(); // To generate XML File using C# from SQL Server Data using (SqlDataAdapter da = new SqlDataAdapter()) { da.SelectCommand.CommandText = @"select T1_1.HomeID as [@HomeID], ( select T1_2.DayID as [@ID], ( select T2.RndString+' '+left(T1_3.TimeValue, 5) as '*' from TB1 as T1_3 inner join TB2 as T2 on T1_3.DayID = T2.DayType and T1_3.TimeCode = T2.StringCode where T1_2.HomeID = T1_3.HomeID and T1_2.DayID = T1_3.DayID order by T2.StringCode for xml path('String'), type ) from TB1 as T1_2 where T1_2.HomeID = T1_1.HomeID group by T1_2.DayID, T1_2.HomeID order by T1_2.DayID for xml path('Day'), type ) from TB1 as T1_1 group by T1_1.HomeID order by T1_1.HomeID for xml path('Person'), root('Persons')"; da.SelectCommand.Connection = new SqlConnection("sdwDBConnection"); string xml = ""; using (DataSet ds = new DataSet()) { da.SelectCommand.Connection.Open(); da.Fill(ds); da.SelectCommand.Connection.Close(); if (ds != null &amp;&amp; ds.Tables.Count &gt; 0) xml = ds.GetXml(); } } // Close the connection sdwDBConnection.Close(); } } } </code></pre>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USCommunity
    1. USSarangArd
    plurals
    1. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POGenerate XML using C# from SQL Server Data
      1. This table or related slice is empty.
      1. VTApproveEditSuggestion
    2. VO
      singulars
      1. POGenerate XML using C# from SQL Server Data
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. POGenerate XML using C# from SQL Server Data
      1. This table or related slice is empty.
      1. VTUpMod
    1. This table or related slice is empty.
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload