Imports DotNetNuke

Imports System.Web.UI

Imports System.Collections.Generic

Imports System.Reflection

Imports DotNetNuke.Security.PortalSecurity

Partial Class DesktopModules_DevelopedSite_DevelopedSite

Inherits Entities.Modules.PortalModuleBase

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

If Not Page.IsPostBack Then

 ShowData("")

End If

End Sub

Protected Sub btnSearch_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnSearch.Click

ShowData(txtSearch.Text)

End Sub

Private Sub ShowData(ByVal SearchString As String)

Dim mySqlString As New StringBuilder()

mySqlString.Append("SELECT FriendlyName, Description ")

mySqlString.Append("FROM {databaseOwner}{objectQualifier}DesktopModules ")

mySqlString.Append("WHERE Description like '%' + @SearchString + '%' ")

mySqlString.Append("ORDER BY FriendlyName")

Dim myParam As SqlParameter = New SqlParameter("@SearchString", SqlDbType.VarChar, 150)

myParam.Value = SearchString

Me.GridView1.DataSource = CType(DataProvider.Instance().ExecuteSQL(mySqlString.ToString(), myParam), IDataReader)

Me.GridView1.DataBind()

End Sub

End Class

using DotNetNuke;

using System.Web.UI;

using System.Text;

using System.Collections.Generic;

using System.Reflection;

using DotNetNuke.Security;

using System.Data.SqlClient;

using System.Data;

using DotNetNuke.Data;

partial class DesktopModules_DevelopedSite_DevelopedSite: DotNetNuke.Entities.Modules.PortalModuleBase 

{ 

 protected void Page_Load(object sender, System.EventArgs e) {

 if (!Page.IsPostBack) 

 {

 ShowData("");

 }

 }

 protected void btnSearch_Click(object sender, System.EventArgs e) {

 ShowData(txtSearch.Text);

 }

 private void ShowData(string SearchString) {

 StringBuilder mySqlString = new StringBuilder();

 mySqlString.Append("SELECT FriendlyName, Description ");

 mySqlString.Append("FROM {databaseOwner}{objectQualifier}DesktopModules ");

 mySqlString.Append("WHERE Description like \'%\' + @SearchString + \'%\' ");

 mySqlString.Append("ORDER BY FriendlyName");

 SqlParameter myParam = new SqlParameter("@SearchString", SqlDbType.VarChar, 150);

 myParam.Value = SearchString;

 this.GridView1.DataSource = ((IDataReader)(DataProvider.Instance().ExecuteSQL(mySqlString.ToString(), myParam)));

 this.GridView1.DataBind();

 }

}