C#中来自SQL server的JavaScript数组数据

using System;
using System.Data.SqlClient;
using System.Web.Script.Serialization;

namespace SQLServerArrayData
{
    class Program
    {
        static void Main(string[] args)
        {
            string connectionString = "Data Source=YourServer;Initial Catalog=YourDatabase;User ID=YourUsername;Password=YourPassword";
            string query = "SELECT * FROM YourTable";

            using (SqlConnection connection = new SqlConnection(connectionString))
            {
                SqlCommand command = new SqlCommand(query, connection);
                connection.Open();

                SqlDataReader reader = command.ExecuteReader();

                // 创建一个JavaScriptSerializer对象，用于序列化数据为JSON格式
                JavaScriptSerializer serializer = new JavaScriptSerializer();

                // 创建一个数组，用于存储从数据库中读取的数据
                var dataArray = new object[reader.FieldCount];

                while (reader.Read())
                {
                    // 读取每一行数据，并将其存储到数组中
                    reader.GetValues(dataArray);

                    // 将数组序列化为JSON字符串
                    string jsonData = serializer.Serialize(dataArray);

                    // 在这里可以对jsonData进行进一步处理或输出
                    Console.WriteLine(jsonData);
                }

                reader.Close();
            }
        }
    }
}