asp.net通用的连接数据库实例代码

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>

访问数据库的通用代码实例

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;

public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
//通用数据库连接代码，这里以连接Access数据库为测试示例
if (!IsPostBack)
{
ConnStrTextBox.Text = "Provider=Microsoft.Jet.OLEDB.4.0; Data source=" + Server.MapPath("User.mdb");
SqlTextTextBox.Text = "Select COUNT(*) From Info Where Name='小顾'";
lblMessage.Text = "";
}
}
protected void Button1_Click(object sender, EventArgs e)
{

//定义数据库连接字符串
string MyCOnnectionString= this.ConnStrTextBox.Text;
//定义查询操作的SQL语句
string MySQL = this.SqlTextTextBox.Text;
//定义所要连接的数据库类型为Access
string MyType = this.DBDropDownList.SelectedValue;
System.Data.IDbConnection MyCOnnection= null;
// 根据数据库类型，创建相应的 Connection 对象
switch (MyType)
{
//选择的数据库类型为“SQLServer”，创建SqlConnection类数据库连接对象
case "SQLServer":
MyCOnnection= new System.Data.SqlClient.SqlConnection(MyConnectionString);
break;
case "Oracle":
MyCOnnection= new System.Data.OracleClient.OracleConnection(MyConnectionString);
break;
//选择的数据库类型为“Access”，创建OleDbConnection类数据库连接对象
case "Access":
MyCOnnection= new System.Data.OleDb.OleDbConnection(MyConnectionString);
break;
//选择的数据库类型为“DB2”，创建OleDbConnection类数据库连接对象
case "DB2":
MyCOnnection= new System.Data.Odbc.OdbcConnection(MyConnectionString);
break;
default:
MyCOnnection= new System.Data.OleDb.OleDbConnection(MyConnectionString);
break;
}
Execute(MyConnection, MySQL);
}
public void Execute(System.Data.IDbConnection MyConnection, string strquery)
{
//使用 CreateCommand() 方法生成 Command 对象
System.Data.IDbCommand MyCommand = MyConnection.CreateCommand();
//执行定义的SQL查询语句
MyCommand.CommandText = strquery;
try
{
//打开数据库连接
MyConnection.Open();
//定义查询的结果信息
String MyInfo = "测试连接成功！符合查询要求的记录共有：" + MyCommand.ExecuteScalar().ToString() + "条！";
//输出查询结果信息
lblMessage.Text = MyInfo;
}
catch (Exception ex)
{
//输出错误异常
Response.Write(ex.ToString());
}
finally
{
//关闭数据库连接
MyConnection.Close();
}
}
}

//选择的数据库类型为“SQLServer”，创建SqlConnection类数据库连接对象
case "SQLServer":
MyCOnnection= new System.Data.SqlClient.SqlConnection(MyConnectionString);
break;
case "Oracle":
MyCOnnection= new System.Data.OracleClient.OracleConnection(MyConnectionString);
break;
//选择的数据库类型为“Access”，创建OleDbConnection类数据库连接对象
case "Access":
MyCOnnection= new System.Data.OleDb.OleDbConnection(MyConnectionString);
break;
//选择的数据库类型为“DB2”，创建OleDbConnection类数据库连接对象
case "DB2":
MyCOnnection= new System.Data.Odbc.OdbcConnection(MyConnectionString);
break;
default:
MyCOnnection= new System.Data.OleDb.OleDbConnection(MyConnectionString);
break;