database.cs

来自「c#做的WEB disk」· CS 代码 · 共 31 行

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

namespace ConfirmWebDisk.friendshare.APP
{
	/// <summary>
	/// DataBase 的摘要说明。
	/// </summary>
	public class DataBase
	{
		public DataBase()
		{}
		string Conn = ConfigurationSettings.AppSettings["ConnectionString"];
		public DataSet ExecuteStoreProc( string StoreProcName)
		{
			SqlConnection Connection = new SqlConnection(Conn);
			SqlDataAdapter DataAdapter = new SqlDataAdapter(StoreProcName,Connection);
			DataAdapter.SelectCommand.CommandType = CommandType.StoredProcedure;
			
			DataSet ds = new DataSet();
			Connection.Open();
			DataAdapter.Fill(ds);
			Connection.Close();
			
			return ds;
		}
	}
}