DNN Community Blog

The Community Blog is a personal opinion of community members and by no means the official standpoint of DNN Corp or DNN Platform. This is a place to express personal thoughts about DNNPlatform, the community and its ecosystem. Do you have useful information that you would like to share with the DNN Community in a featured article or blog? If so, please contact community@dnnsoftware.com.

 


Using the DNN Text Suggest Control

The DNNTextSuggest control is actually a very complex control. You can go to the example website at: http://webcontrols.dotnetnuke.com where you can test out all the DNN web controls (you can download the source here). The control allows you to type in text and provides matching items from a data source (for example a database). This provides the same  functionality as Google Suggests.

This is an amazingly complex control and you are advised to read the extensive documentation that is provided to fully explore it's features. This is a brief introduction to the control to show how easy it is to get it up and running.

Here are the steps to implement this web control in your own modules. This works with the full version of Visual Studio 2005 and also Visual Web Developer Express.

If you haven't already performed this step, you will want to add the DNN web controls to your Visual Studio toolbox:

  1. Right-Click on the Toolbox in Visual Studio and select Choose Items...

     
  2. Use the Browse button to browse to DotNetNuke.WebControls.dll (in the /bin folder of your DotNetNuke installation) and click the OK button.
  3. The DotNetNuke web controls will now appear in your toolbox:

     
  4. Drag the DNNTextSuggest control from the toolbox and drop it on to your DotNetNuke User Control (See my tutorial Creating a  Super-Simple DotNetNuke module for information on how to create a DotNetNuke Web User Control) .
  1. In the properties for the DNNTextSuggest control, click on the yellow lazerbolt to show the events for the control
  2. We see that there are events that we can wireup a method to. Type "MyDNNTextSuggest_PopulateOnDemand" for the PopulateOnDemand event and click away from the box.
  3. Visual Studio switches to code view and your method is all ready for your custom code. Add "PopulateList(e.Nodes, e.Text)" to the method so it appears like this:

    Protected Sub MyDNNTextSuggest_PopulateOnDemand(ByVal source As Object, ByVal e As DotNetNuke.UI.WebControls.DNNTextSuggestEventArgs) Handles MyDNNTextSuggest.PopulateOnDemand
        PopulateList(e.Nodes, e.Text)
    End Sub

     

  4. Ensure that your User Control has this line toward the top:  Inherits Entities.Modules.PortalModuleBase
  5. Enter this additional code:
     

    Private Sub PopulateList(ByVal objNodes As DNNNodeCollection, ByVal strText As String)

    Dim
    o As DNNNode
    Dim dt As DataTable = GetData()
    'strip out troublesome chars for Select below
    strText = strText.Replace("[", "").Replace("]", "").Replace("'", "''")
    dt.CaseSensitive = Me.MyDNNTextSuggest.CaseSensitive
    Dim drs() As DataRow = dt.Select("name like '" & strText & "%'")
    Dim dr As DataRow
    For Each dr In drs
    If Me.MyDNNTextSuggest.MaxSuggestRows = 0 _
    OrElse objNodes.Count < (Me.MyDNNTextSuggest.MaxSuggestRows + 1) Then
    o = New DNNNode(CStr(dr("name")))
    o.ID = CStr(dr("id"))
    objNodes.Add(o)
    End If
    Next

    End
    Sub

    Private
    Function GetData() As DataTable

    Dim dt As DataTable = New DataTable
    dt.Columns.Add(New DataColumn("id", GetType(String)))
    dt.Columns.Add(New DataColumn("name", GetType(String)))
    AddRow(1, "name1", dt)
    AddRow(2, "name12", dt)
    AddRow(3, "name123", dt)
    AddRow(4, "name1234", dt)
    AddRow(5, "name12345", dt)
    Return dt

    End Function


    Private
    Sub AddRow(ByVal ID As Integer, ByVal Name As String, ByVal dt As DataTable)
    Dim dr As DataRow = dt.NewRow()
    dr("id") = ID
    dr("name") = Name
    dt.Rows.Add(dr)

    End Sub

     
  6. Save the page and Build the page. When you type "name" in the text box it will show you matching items.
  7. You can download the code here.

This example is so simple it really does not do the control justice. However, you can see that the control is just as easy to use as a Microsoft Atlas control. In addition, all of the web controls work with ASP.NET 1.1 and DotNetNuke 3.

Jon Henning continuously develops web controls and provides excellent documentation on the DotNetNuke site. I hope to introduce you to this incredible resource and demonstrate yet another reason why web development is faster and easier when you use the DotNetNuke Framework.

Comments

Comment Form

Only registered users may post comments.

NewsArchives


Aderson Oliveira (3)
Alec Whittington (11)
Alex Shirley (10)
Andrew Nurse (30)
Anthony Glenwright (5)
Antonio Chagoury (28)
Ash Prasad (13)
Benjamin Hermann (25)
Benoit Sarton (9)
Beth Firebaugh (3)
Bill Walker (36)
Bob Kruger (5)
Brice Snow (1)
Bruce Chapman (9)
Bryan Andrews (1)
cathal connolly (52)
Charles Nurse (157)
Chris Hammond (197)
Chris Paterra (55)
Clinton Patterson (25)
Cuong Dang (21)
Daniel Bartholomew (2)
Daniel Mettler (20)
Dave Buckner (2)
Doug Howell (11)
Erik van Ballegoij (30)
Ernst Peter Tamminga (66)
Geoff Barlow (2)
Gifford Watkins (3)
Gilles Le Pigocher (3)
Ian Robinson (7)
Israel Martinez (17)
Jan Blomquist (2)
Jan Jonas (1)
Jaspreet Bhatia (1)
Jenni Merrifield (6)
Joe Brinkman (234)
John Mitchell (1)
Jon Henning (14)
Jonathan Sheely (3)
Jordan Coopersmith (1)
Keivan Beigi (3)
Ken Grierson (10)
Kevin Schreiner (6)
Leigh Pointer (31)
Lorraine Young (60)
Matthias Schlomann (15)
Mauricio Márquez (5)
Michael Doxsey (7)
Michael Tobisch (1)
Michael Washington (202)
Mike Horton (19)
Mitchel Sellers (28)
Nathan Rover (3)
Navin V Nagiah (14)
Néstor Sánchez (31)
Nik Kalyani (14)
Patrick Santry (3)
Peter Donker (50)
Philip Beadle (135)
Richard Dumas (22)
Robert J Collins (5)
Roger Selwyn (8)
Ruben Lopez (1)
Ryan Martinez (1)
Salar Golestanian (4)
Sanjay Mehrotra (9)
Scott McCulloch (1)
Scott S (11)
Scott Willhite (97)
Sebastian Leupold (76)
Shaun Walker (237)
Shawn Mehaffie (17)
Stefan Cullmann (12)
Stefan Kamphuis (12)
Steve Fabian (31)
Timo Breumelhof (24)
Torsten Weggen (1)
Vicenç Masanas (27)
Vincent Nguyen (3)
Vitaly Kozadayev (6)
Will Morgenweck (36)
Will Strohl (140)
William Severance (5)

Copyright 2014 by DNN Corp | Terms of Use | Privacy | Design by Parker Moore Design