Custom Modules

Re: Advanced Datagrid Module by Efficion Consulting

oledave — Thu, 22 Jun 2006 01:41:00 GMT

The current version should work on 4.3. There is a new version in the works but I have no idea when I'll actually have it ready for release.

Re: Advanced Datagrid Module by Efficion Consulting

bradoyler — Wed, 21 Jun 2006 03:35:14 GMT

When's a new version for DNN 4.3 being released?

Re: Advanced Datagrid Module by Efficion Consulting

dgrassel — Tue, 02 May 2006 13:15:18 GMT

If there is no data returned from the SELECT statement I get an error. As soon as I enter a row in the table though it all works great. Below is the error message I get but the only thing I've changed in the source is I moved sIDField, bEnableEditing, bEnableDetails outside of If NOT Page.IsPostBack so they will work when I go to the next page. Any ideas? Thanks!

Error: System.InvalidOperationException: Invalid attempt to Read when reader is closed. at System.Data.OleDb.OleDbDataReader.Read() at System.Data.Common.DbEnumerator.MoveNext() at System.Web.UI.WebControls.DataGrid.CreateControlHierarchy(Boolean useDataSource) at System.Web.UI.WebControls.BaseDataList.OnDataBinding(EventArgs e) at System.Web.UI.WebControls.BaseDataList.DataBind() at EfficionConsulting.AdvancedDataGrid.AdvancedDataGrid.BindData()
CommandText: SELECT STATEMENT

Re: Advanced Datagrid Module by Efficion Consulting

oledave — Tue, 18 Apr 2006 20:42:03 GMT

chammock:
What does Provider=SQLNCLI mean?

Based on everything I've read, that's what you need to add to the ConnectionString for SQL 2005 for it to work with Oledb (see connectionstrings.com). I haven't tried it myself, please let me know if anyone gets this to work.

Re: Advanced Datagrid Module by Efficion Consulting

oledave — Tue, 18 Apr 2006 20:40:07 GMT

ravensensei:
is it possible to hit a SQL db on another machine and display in the portal? I have a bunch of accountants who are interested in seeing reports in the portal from their Great Plains database. I'm assuming that if I can connect to the great plains db, it shouldn't be an issue, right?

Is there a module that does complex sql? ie - select table1.col1, table1.col2, table2.col2, table2.col1 from table1, table2 where table1.col1 = table2.col2 etc?

Can I do this with Advanced Datagrid?
ps - is the source of this module available?

Yes, that's what it's made for... I would recommend creating a view for really complex SQL to make it easier.

And yes, the source of the module is freely available.

Re: Advanced Datagrid Module by Efficion Consulting

ravensensei — Sun, 16 Apr 2006 16:19:15 GMT

is it possible to hit a SQL db on another machine and display in the portal? I have a bunch of accountants who are interested in seeing reports in the portal from their Great Plains database. I'm assuming that if I can connect to the great plains db, it shouldn't be an issue, right?

Is there a module that does complex sql? ie - select table1.col1, table1.col2, table2.col2, table2.col1 from table1, table2 where table1.col1 = table2.col2 etc?

Can I do this with Advanced Datagrid?

thanks,

ps - is the source of this module available?

Re: Advanced Datagrid Module by Efficion Consulting

chammock — Sat, 15 Apr 2006 21:59:46 GMT

What does Provider=SQLNCLI mean?

Re: Advanced Datagrid Module by Efficion Consulting

oledave — Fri, 14 Apr 2006 18:34:09 GMT

I believe this error occurs when using SQL Express or SQL 2005 as they require a different PROVIDER value in the connection string and right now the ADG prepends "PROVIDER=sqloledb;" to the connection string when none is provided...

So, try specifying a connection string along the lines of:
Provider=SQLNCLI;Server=Aron1;Database=pubs;UID=sa;PWD=asdasd;

Let me know if that works.

Re: Advanced Datagrid Module by Efficion Consulting

ravensensei — Fri, 14 Apr 2006 15:18:51 GMT

I'm getting the same error when I try to simply select a column from an existing DNN table or a user created one:

Error: System.Data.OleDb.OleDbException: No error message available, result code: DB_E_ERRORSOCCURRED(0x80040E21). at System.Data.OleDb.OleDbConnectionInternal..ctor(OleDbConnectionString constr, OleDbConnection connection) at System.Data.OleDb.OleDbConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.OleDb.OleDbConnection.Open() at EfficionConsulting.AdvancedDataGrid.AdvancedDataGrid.BindData()
CommandText: select status from sysusers

I'm not sure where to go from here - I haven't updated anything or made any changes. I just uploaded the PA, injected it into a page, and tried a simple query.

Any ideas?
M@

Re: Advanced Datagrid Module by Efficion Consulting

oledave — Tue, 11 Apr 2006 13:46:05 GMT

I'm here, just don't know what to tell you... Looks like you've made changes as I can see you've got it in the PYC_DataGrid directory... That's not a message I've seen or that anyone else has reported.

Re: Advanced Datagrid Module by Efficion Consulting

pchan — Tue, 11 Apr 2006 11:31:12 GMT

Any comment ?

Are you there, Dave ?

Re: Advanced Datagrid Module by Efficion Consulting

pchan — Wed, 05 Apr 2006 13:32:29 GMT

Dear David,

I have moved onto DNN4 and am looking to using your Advanced Data Grid Source version 3.1.3. The various files are dispatched into various directories in DesktopModules, enregistered as a module and ready for modifying settings.

I ran into difficulties in AdvancedDataGrid.ascx.vb:Page_Load() calling BindData() and calling myConnection.Open(). The connection string is "Provider=SQLOLEDB;Data Source=.\SQLExpress;Integrated Security=True;User Instance=True;AttachDBFilename =|DataDirectory|Database.mdf;" and the query is "Select * from GuestBook;"

"Error: System.Data.OleDb.OleDbException: No error message available, result code: DB_E_ERRORSOCCURRED(0x80040E21).
   at System.Data.OleDb.OleDbConnectionInternal..ctor(OleDbConnectionString constr, OleDbConnection connection)
   at System.Data.OleDb.OleDbConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)
   at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup)
   at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
   at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
   at System.Data.OleDb.OleDbConnection.Open()
   at Pyc.Modules.AdvancedDataGrid.AdvancedDataGrid.BindData() in E:\ASPNET\DNN4StK1\DesktopModules\PYC_DataGrid\AdvancedDataGrid.ascx.vb:line 177<br> CommandText: select * from GuestBook "

Any hints on where to go from here ?

And Many thanks for this great module !

Paging disables Edit/Details

dgrassel — Wed, 22 Mar 2006 16:17:14 GMT

New Question - if I enable Paging and then go to the next page it makes the Edit and Details links dissapear? Any ideas here? Thanks!

Re: Advanced Datagrid Module by Efficion Consulting

oledave — Fri, 17 Mar 2006 15:41:33 GMT

just_for_forums wrote:
I thought I could just create a 2003 project and link the dotnetnuke.dll. I added the .ascx.vb and .ascx files and then compiled. Not the way to do it.

First, you cannot just rename a DLL in the bin directory. .Net loads and compiles all DLLs in the bin directory.

Second, In both #Dev and VS, you need to make sure you have added a reference to a valid DotNetNuke.dll. In future releases, I will be including an obj directory which contains all referenced DLL to make it easier for others to compile my source.

Third, I don't know how you were able to compile a DLL in SharpDevelop without it working. Under project options, in the General/Compile section, make sure you have all .vb files checked.

Fourth, in VS just adding the ascx and vb files to a new project and then adding the proper references and project level imports should work just fine. The project level imports I have for the ADG are: System,DotNetNuke,DotNetNuke.Services.Exceptions

Re: Advanced Datagrid Module by Efficion Consulting

chammock — Fri, 17 Mar 2006 15:20:05 GMT

Try the videos at Traincert http://www.traincert.net/ and also www.speerio.net has a good approach with the My Modules.