If you can't get what you want elsewhere you could look at our modules.  With the ActiveHTML module you can take a selection from the database and display it in any format you want using a asp:repeater like control.  Complete with heading, footing, details, anternate rows...

They use System.Data.sqlclient for data access so you should be able to connect to a MySQL server. 

mj
Brillnat.com

Hi Paul,

I'm not sure which connect string is needed. I have MySQL 4.0.18 on port 3306 and ASPnet 2.0 and want to connect using the SQlGridSelectedView module.

I tried the following conenction string which fails with error below.

Data Source=nybcssmts;Port=3306;Database=abcsmartsalerts;User ID=root;Password=;Command Logging=false;

Error: Reports is currently unavailable.
DotNetNuke.Services.Exceptions.ModuleLoadException: An OLE DB Provider was not specified in the ConnectionString. An example would be, 'Provider=SQLOLEDB;'. ---> System.ArgumentException: An OLE DB Provider was not specified in the ConnectionString. An example would be, 'Provider=SQLOLEDB;'. at System.Data.OleDb.OleDbConnectionString.ValidateProvider(String progid) at System.Data.OleDb.OleDbConnectionString.ValidateConnectionString(String connectionString) at System.Data.OleDb.OleDbConnectionString..ctor(String connectionString, Boolean validate) at System.Data.OleDb.OleDbConnectionFactory.CreateConnectionOptions(String connectionString, DbConnectionOptions previous) at System.Data.ProviderBase.DbConnectionFactory.GetConnectionPoolGroup(String connectionString, DbConnectionPoolGroupOptions poolOptions, DbConnectionOptions& userConnectionOptions) at System.Data.OleDb.OleDbConnection.ConnectionString_Set(String value) at System.Data.OleDb.OleDbConnection.set_ConnectionString(String value) at System.Data.OleDb.OleDbConnection..ctor(String connectionString) at TressleWorks.SQLGridSelectedView.SQLGridSelectedView.DisplayGrid(String psSortExpr, Boolean pbExport) at TressleWorks.SQLGridSelectedView.SQLGridSelectedView.Page_Load(Object sender, EventArgs e) --- End of inner exception stack trace ---

My SQL command is simple "Select * from notifications;"

I know access to MySQL is working well because I have several PHP Web pages that connect successfuly with the below settings (excerpt).

// connect to the database
if (!($mylink = mysql_connect("nybcssmts:3306","root","")))
 {
  print "<h3>could not connect to database</h3>\n";
  exit;
 }
Mysql_select_db("abcsmartsalerts");

$inst_query = "select count(*) as count, Instance from notifications where EventTime > UNIX_TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL ".$daysback." DAY)) group by instance order by severity, count DESC limit 0,10" ;

$result = mysql_query($inst_query)
  or die("ack! query failed: "
   ."<li>errorno=".mysql_errno()
   ."<li>error=".mysql_error()
   ."<li>query=".$inst_query
  );

Please advise.