using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using Microsoft.Practices.EnterpriseLibrary.Common;
using Microsoft.Practices.EnterpriseLibrary.Data;
using System.Data.Common;
using System.Data.SqlClient;
public partial class _Default : System.Web.UI.Page
{
Database db = DatabaseFactory.CreateDatabase("NorthWind");
// Database db = DatabaseFactory.CreateDatabase();
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
this.GridView1.DataSource = GetDateSet("select top 10 * from dbo.Products").Tables[0];
this.GridView1.DataBind();
}
}
/// <summary>
/// 执行单条SQL 语句
/// </summary>
/// <param name="sql">sql</param>
/// <returns>DataSet</returns>
private DataSet GetDateSet(string sql)
{
DataSet ds = db.ExecuteDataSet(CommandType.Text,sql);
return ds;
}
/// <summary>
/// 执行单条SQL 语句——只读数据
/// </summary>
/// <param name="sql">sql</param>
/// <returns>IDataReader</returns>
private IDataReader GetDataReader(string sql)
{
IDataReader idatareader = db.ExecuteReader(CommandType.Text,sql);
return idatareader;
}
/// <summary>
/// 执行单条SQL 语句——获得一列数据
/// </summary>
/// <param name="sql">sql</param>
/// <returns>int</returns>
private int GetSingleValue(string sql)
{
int value =(int)db.ExecuteScalar(CommandType.Text,sql);
return value;
}
/// <summary>
/// 执行存储过程
/// </summary>
private void ExeProcNonPar()
