tdsallflight.cs

来自「航空公司用的简单管理系统」· CS 代码 · 共 40 行

using System.Data;
using System.Data.Sql;
using System.Data.SqlClient;
using System.Data.Common;
using System.ComponentModel;
using System;

namespace SouthernAir.Business.TypeDataSet {

    [DataObject]
    partial class tdsAllFlight
    {
        [DataObjectMethod(DataObjectMethodType.Select, true)]
        public static BSAAllFlightDataTable GetAllFlight()
        {
            try
            {
                string strConn = "Data Source=TRTGR\\SQLEXPRESS;AttachDbFilename=D:\\Project\\SouthernAir\\SouthernAir.Business\\SouthernAirData.mdf;Integrated Security=True";
                string strSQL = "Select * From BSAFlight";
                
                using (SqlConnection conn = new SqlConnection(strConn))
                {
                    conn.Open();
                    SqlDataAdapter da = new SqlDataAdapter(strSQL, conn);
                    DataSet ds = new DataSet();
                    da.Fill(ds, "AllFlight");
                    BSAAllFlightDataTable oDataTable = new BSAAllFlightDataTable();
                    oDataTable.Merge(ds.Tables["AllFlight"]);
                    return oDataTable;
                }
            }
            catch
            {
                BSAAllFlightDataTable oDataTable = new BSAAllFlightDataTable();
                return oDataTable;
            }
        }
    }
}