SQL XML 或 JSON 通过 ASP.NET 返回到 Objective-C

使用ASP.NET将SQL、XML或JSON返回给Objective-C

csharp
string connectionString = "Data Source=your_server;Initial Catalog=your_database;User ID=your_username;Password=your_password";
string query = "SELECT * FROM your_table";
using (SqlConnection connection = new SqlConnection(connectionString))
{
    connection.Open();
    SqlCommand command = new SqlCommand(query, connection);
    SqlDataReader reader = command.ExecuteReader();
    while (reader.Read())
    {
        // 处理查询结果
    }
    reader.Close();
}

csharp
using (SqlConnection connection = new SqlConnection(connectionString))
{
    connection.Open();
    SqlCommand command = new SqlCommand(query, connection);
    SqlDataReader reader = command.ExecuteReader();
    // 创建XmlTextWriter对象
    StringWriter stringWriter = new StringWriter();
    XmlTextWriter xmlWriter = new XmlTextWriter(stringWriter);
    // 开始写入XML文档
    xmlWriter.WriteStartDocument();
    xmlWriter.WriteStartElement("data");
    while (reader.Read())
    {
        // 将查询结果写入XML
        xmlWriter.WriteStartElement("item");
        xmlWriter.WriteElementString("id", reader["id"].ToString());
        xmlWriter.WriteElementString("name", reader["name"].ToString());
        xmlWriter.WriteEndElement();
    }
    // 结束XML文档
    xmlWriter.WriteEndElement();
    xmlWriter.WriteEndDocument();
    xmlWriter.Flush();
    // 将XML文档转换为字符串并返回给Objective-C
    string xmlResponse = stringWriter.ToString();
    // 返回给Objective-C
}
reader.Close();

csharp
using (SqlConnection connection = new SqlConnection(connectionString))
{
    connection.Open();
    SqlCommand command = new SqlCommand(query, connection);
    SqlDataReader reader = command.ExecuteReader();
    List> data = new List>();
    while (reader.Read())
    {
        // 创建字典对象
        Dictionary item = new Dictionary();
        // 将查询结果写入字典
        item["id"] = reader["id"];
        item["name"] = reader["name"];
        data.Add(item);
    }
    // 将字典对象序列化为JSON字符串
    JavaScriptSerializer serializer = new JavaScriptSerializer();
    string jsonResponse = serializer.Serialize(data);
    // 返回给Objective-C
}
reader.Close();