asp.net通过web.config连接mysql数据库

OStack程序员社区-中国程序员成长平台 › 门户 › 编程› ASP.NET›ASP.NET编程经验

原作者: [db:作者] 来自: [db:来源] 收藏邀请

1，Download Connector/Net 5.2(odbc) and install

2, add reference "MySQL.Data.dll"

3, add connection in web.config file

4, get the connection string

].ConnectionString;
dbProviderName = ConfigurationManager.ConnectionStrings["ConnStr"].ProviderName;

5, fetch data from database using "using System.Data.Common;"

GenericDataAccess
{
    public static DataTable ExecuteSelectCommand(DbCommand command)
    {
        DataTable table = null;
        try
        {
            command.Connection.Open();
            DbDataReader reader = command.ExecuteReader();
            table = new DataTable();
            table.Load(reader);
            reader.Close();
        }
        catch (Exception ex)
        {
            Utilities.LogError(ex);
            throw ex;
        }
        finally {
            command.Connection.Close();
        }
        return table;
    }

    public static DbCommand CreateCommand()
    {
        string dataProviderName = BalloonShopConfiguration.DbProviderName;
        string connectionString = BalloonShopConfiguration.DbConnectionString;
        DbProviderFactory factory = DbProviderFactories.GetFactory(dataProviderName);
        DbConnection conn = factory.CreateConnection();
        conn.ConnectionString = connectionString;
        DbCommand comm = conn.CreateCommand();
        comm.CommandType = CommandType.StoredProcedure;
        return comm;
    }
}