component.cs

来自「Professional ASP.NET source code」· CS 代码 · 共 23 行

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

namespace Component {
	public class Simple {

		public Simple() : base() {
		}

		public System.Data.DataSet LoadDataSet() {
			DataSet myDataSet = new System.Data.DataSet();
			string Sql = "select address, city, state from Authors";
			SqlConnection myConn = new SqlConnection(ConfigurationSettings.AppSettings["DsnPubs"]);
			SqlDataAdapter myAdapter = new SqlDataAdapter(Sql, myConn);
			myAdapter.Fill(myDataSet, "products");
			myConn.Close();
			return myDataSet;
		}
	}
}