Sql output json

Sql server query output to json file automatically

// TODO: Add your code here
                string query = "SELECT TOP 5 [BusinessEntityID],[NationalIDNumber],[OrganizationNode],[OrganizationLevel] FROM [HumanResources].[Employee]";
                string connectionSql = "Server=(local);Database=AdventureWorks2016CTP3;Integrated Security=true";
                StreamWriter myFile = new StreamWriter(@"c:\sql\fileCSharp.txt");
                using (SqlConnection connection = new SqlConnection(connectionSql))
                {
                    SqlCommand command = new SqlCommand(query, connection);
                    connection.Open();
                    SqlDataReader reader = command.ExecuteReader();
                    try
                    {
                        while (reader.Read())
                        {
                            myFile.WriteLine(String.Format("{0}, {1}, {2}, {3}", 
                            reader["BusinessEntityID"], reader["NationalIDNumber"], reader["OrganizationNode"], reader["OrganizationLevel"]));
                        }
                    }
                    catch (Exception ex)
                        {
                            MessageBox.Show(ex.ToString());
                            Dts.TaskResult = (int)ScriptResults.Failure;
                        }
                    finally
                        {
                            reader.Close();
                            myFile.Close();
                        }
                }

Source: sqlservercentral.com

Similar codes

1 vote130 views2 answers
Parse datetime c#
C#
0 vote136 views1 answer
How to change argument of function in f#
C#
1 vote137 views1 answer
UnityEngine.Transform.get_position () (at <a0ef933b1aa54b668801ea864e4204fe>:0) Gamekit3D.MeleeWeapon.BeginAttack (System.Boolean thowingAttack)
C#
13 votes164 views3 answers
C# join array
C#
1 vote161 views1 answer
There is already a virtual axis named Horizontal registered. unity
C#Unity
7 votes180 views2 answers
Unity move character
C#Unity
0 vote132 views1 answer
C# initialize constant
C#
2 votes137 views1 answer
C# start process and wait for exit code
C#
0 vote129 views1 answer
Unity can't put tmpro in script
C#
6 votes123 views2 answers
C# const vs readonly
C#