Resources for the DotNetNuke Community
Well, I got it working except for the checkbox part to make the Header in bold. It does not save it when it is checked. I guess this has to be a minor issue. I will check it out later on.
Vicenç Masanas I read the forum on ASP.NET and I was impressed by all the compliments you received. Now that I tried it out myself I also like to give my compliments to you. I am in the middle of something that I like to build. If I succeed, and I believe now that I will, I wil make a donation.
Hablas Espanol? Porque llo no hablo Catalan. He nacido en Holanda y mis padres son de la provincia de Cadiz. Me algero mucho de ver Espanoles dedicado con DNN y mas todavia al ver tu trabajo tan professional.
Hasta luego, Paco
_____________________________________________
Eureka, I understand now what the step is that I have to take. I replaced the code in the SQLDataprovider.vb within the folder "\HelloWorld\Providers\SqlDataProvider" where all HelloWorld related methods are defined. I just missed the connection to that file in the specified folder, now it seems obvious.
_____________________________________________________
I had the Module working I thought until I tried to add an item. It said something like the Item_ID can not be NULL which sound reasonable. The field does not allow NULLS. Anyway, I am installing the Module for the second time now and decided to place here the points that are not clear to me in the Tutorial. I bumped against some points where I can not figger out what is exactly the step to take. This is the first one:
In page 6 of the Tutorial it says, I quote: Just replace the last part of the code, where all HelloWorld related methods are defined. Save the file and close.
Maybe I am missing something, here below is the code and I really have no idea what I have to replace because it looks all fine to me. Please, can someone help out? Do I have to replace "DatabaseOwner & ObjectQualifier &", is that it?
#Region "HelloWorld Methods" Public Overrides Function GetHelloWorld(ByVal itemID As Integer,ByVal moduleId as Integer) As IDataReader Return CType(SqlHelper.ExecuteReader(ConnectionString, DatabaseOwner & ObjectQualifier & "VMasanas_HelloWorldGet", itemID,moduleId), IDataReader) End Function
Public Overrides Function ListHelloWorld() As IDataReader Return CType(SqlHelper.ExecuteReader(ConnectionString, DatabaseOwner & ObjectQualifier & "VMasanas_HelloWorldList"), IDataReader) End Function
Public Overrides Function GetHelloWorldByModules(ByVal moduleID As Integer ) As IDataReader Return CType(SqlHelper.ExecuteReader(ConnectionString, DatabaseOwner & ObjectQualifier & "VMasanas_HelloWorldGetByModules", moduleID), IDataReader) End Function Public Overrides Function AddHelloWorld(ByVal moduleID As Integer , ByVal message As String) As Integer Return CType(SqlHelper.ExecuteScalar(ConnectionString, DatabaseOwner & ObjectQualifier & "VMasanas_HelloWorldAdd", moduleID, message), Integer) End Function Public Overrides Sub UpdateHelloWorld(ByVal itemID As Integer, ByVal moduleID As Integer , ByVal message As String) SqlHelper.ExecuteNonQuery(ConnectionString, DatabaseOwner & ObjectQualifier & "VMasanas_HelloWorldUpdate", itemID, moduleID, message) End Sub
Public Overrides Sub DeleteHelloWorld(ByVal itemID As Integer) SqlHelper.ExecuteNonQuery(ConnectionString, DatabaseOwner & ObjectQualifier & "VMasanas_HelloWorldDelete", itemID) End Sub#End Region