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

usingSystem;usingSystem.Configuration;usingSystem.Data;usingSystem.Linq;usingSystem.Web;usingSystem.Web.Security;usingSystem.Web.UI;usingSystem.Web.UI.HtmlControls;usingSystem.Web.UI.WebControls;usingSystem.Web.UI.WebControls.WebParts;usingSystem.Xml.Linq;public partial class_Default : System.Web.UI.Page

{protected void Page_Load(objectsender, 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(objectsender, EventArgs e)

{ www.jbxue.com//定义数据库连接字符串

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= newSystem.Data.SqlClient.SqlConnection(MyConnectionString);break;case "Oracle":

MyConnection= newSystem.Data.OracleClient.OracleConnection(MyConnectionString);break;//选择的数据库类型为“Access”，创建OleDbConnection类数据库连接对象

case "Access":

MyConnection= newSystem.Data.OleDb.OleDbConnection(MyConnectionString);break;//选择的数据库类型为“DB2”，创建OleDbConnection类数据库连接对象

case "DB2":

MyConnection= newSystem.Data.Odbc.OdbcConnection(MyConnectionString);break;default:

MyConnection= newSystem.Data.OleDb.OleDbConnection(MyConnectionString);break;

}

Execute(MyConnection, MySQL);

}public void Execute(System.Data.IDbConnection MyConnection, stringstrquery)

{//使用 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();

}

}

}