Login
Register
29-07-2010

Resources for the DotNetNuke Community


Support this site

  Support forums  

You need to be logged in in order to post to this forums.
SearchForum Home
  DotNetNuke Development  Templates  Problem in my M...
 Problem in my Module
 
imgOfflinehassan83
2 posts
Joined
6/25/2006

Problem in my Module
Posted: 19 Apr 07 2:47 AM

Dear Sir,

I downloaded CodeSmith Templates v3.0.1 and DNNProjectTemplates v3.0.1 and also video tutorials that I downloaded it from http://www.seaburydesign.com/Tutorials/DNN3xModuleCreation/tabid/67/Default.aspx and it helped me to understand how can I develop my modules and I developed sample module to show list of companies But I have aproblem in this module I have more than 100 company in this module so i want to allow pages on these data first I suggested to mine to use DataGrid to show these data but it have some problems in it and I can't solved it  :

1- it show ComID (Company ID ) , PortalId, ModuleId and some other data that I want to  neglect it

2- I want to reorder Columns in DataGrid

3- I allowed pages in this grid but it didn't work

I have Stored Procedure named Listcompanies

CREATE PROCEDURE dbo.ListCompanies
 @PortalID int,
 @ModuleID int
AS

SELECT
 [ComID],
 [PortalID],
 [ModuleID],
 [ShortName],
 [CatNum],
 [Symbol],
 [MarketID],
 [secname],
 [HaveForiegn],
 [Ratio],
 [Telephone],
 [email],
 [Fax],
 [WebSite],
 [ViewOrder],
 [DateAdd],
 [DateMod]
 
FROM
 Companies
WHERE
 PortalID = @PortalID
AND
 ModuleID = @ModuleID
GO
---------------------------------------------------

And In Companies.ascx page this code

#Region "Event Handlers"

Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load

Try

'Sample code to get data

Dim objCompaniesController As New CompaniesController

'Dim list As ArrayList

If Not Page.IsPostBack Then

Grdcompanies.DataSource = objCompaniesController.ListCompanies(PortalId, ModuleId)

Grdcompanies.DataBind()

End If

Catch exc As Exception

ProcessModuleLoadException(Me, exc)

End Try

End Sub

#End Region

I tried to delete my negelected data from this procedure but the same data is showned in my module.

please help me

Regards, Hassan Ali

imgOfflinednnjungle
151 posts
5th
Joined
3/13/2005

Re: Problem in my Module
Posted: 24 Apr 07 6:51 AM
Since I don't really know what is you problem here (seems a datagrid issue...) best advice I can give you is to look at this site www.datagridgirl.com and try some of the tutorials for paging a datagrid.
Disgrafic.com
  DotNetNuke Development  Templates  Problem in my M...
© Vicenç Masanas Terms Of Use Privacy Statement   
.