数据库通用访问过程及带传出参数存储过程的使用

GenericDataAcess.cs

using System; using System.Data; using System.Data.Common; using System.Configuration; using System.Linq; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.HtmlControls; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Xml.Linq; /// <summary> ///GenericDataAcess 的摘要说明 /// </summary> public class GenericDataAcess { public GenericDataAcess() { // //TODO: 在此处添加构造函数逻辑 // } public static DbCommand CreateCommand() { string dataProviderName = ConfigurationManager.ConnectionStrings["test"].ProviderName; string connectionString = ConfigurationManager.ConnectionStrings["test"].ConnectionString; DbProviderFactory factory = DbProviderFactories.GetFactory(dataProviderName); DbConnection con = factory.CreateConnection(); con.ConnectionString = connectionString; DbCommand cmd = con.CreateCommand(); cmd.CommandType = CommandType.StoredProcedure; return cmd; } }

 

web.config

<connectionStrings> <add name="test" connectionString="Data Source=Oracle/SQLEXPRESS;Initial Catalog=bank;Integrated Security=True" providerName="System.Data.SqlClient"/> </connectionStrings>

 

default.aspx.cs

using System; using System.Configuration; using System.Data; using System.Linq; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.HtmlControls; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Xml.Linq; using System.Data.Common; public partial class _Default : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { DbCommand cmd= GenericDataAcess.CreateCommand(); cmd.CommandText = ""; DbParameter dp = cmd.CreateParameter(); dp.Direction = ParameterDirection.Output; dp.ParameterName = "@userName"; dp.DbType = DbType.String; dp.Size = 10; cmd.Parameters.Add(dp); cmd.CommandText = "test"; cmd.Connection.Open(); cmd.ExecuteNonQuery(); string userName= (string)cmd.Parameters["@UserName"].Value; Response.Write(userName); } }