readdatatoxml.cs

来自「C#开发者可使用的经典案例集,源自于ASP.NET经典范例50讲」· CS 代码 · 共 38 行

using System;
using System.Data;
using System.Data.SqlClient;

public class App
{
  public static void Main()
  {
    string dataSource = "Data Source=localhost;";
    string security = "user id=sa; password=;";
    string initialCatalog = "initial catalog=Diablo;";
    string cnnString = dataSource + security + initialCatalog;
    SqlConnection connection = new SqlConnection(cnnString);

    string strSql = " SELECT * from Character ";
    SqlCommand command = new SqlCommand(strSql, connection);
    SqlDataAdapter adapter = new SqlDataAdapter();
    adapter.SelectCommand = command;

    DataSet dataSet = new DataSet();
    try
    {
      connection.Open();
      adapter.Fill(dataSet);
    }
    catch(Exception e)
    {
      Console.WriteLine(e.ToString());
      return;
    } 
    finally
    {
      connection.Close();
    }
    dataSet.WriteXml("example.xml");
  }
}