<div>
Grab some parameters from the user and create a SQL query using a StringBuilder object. &nbsp;Then, use SQL controls to get the data you want. &nbsp;This is just one option.<br />
<br />
SQLDataSource:<br />
<a href="http://msdn.microsoft.com/en-us/library/system.web.ui.webcontrols.sqldatasource.aspx" rel="ugc">http://msdn.microsoft.com/<wbr />en-us/libr<wbr />ary/system<wbr />.web.ui.we<wbr />bcontrols.<wbr />sqldatasou<wbr />rce.aspx</a><br />
<br />
Ryan F
</div>


Grab some parameters from the user and create a SQL query using a StringBuilder object.  Then, use SQL controls to get the data you want.  This is just one option.

SQLDataSource:
http://msdn.microsoft.com/en-us/library/system.web.ui.webcontrols.sqldatasource.aspx [http://msdn.microsoft.com/en-us/library/system.web.ui.webcontrols.sqldatasource.aspx]

Ryan F

<div>
Thanks for the response. But is there a better approach then using a StringBuilder to build an SQL query?<br />
<br />
Plus, how would you then determine and display how many records are left in another facet?
</div>


Thanks for the response. But is there a better approach then using a StringBuilder to build an SQL query?

Plus, how would you then determine and display how many records are left in another facet?

<div>
<div class="content wysiwyg-content">
I have a basic implementation of using multi-facet searching in a small application I created. Similar to the one this guy has: <a href="http://www.isurinder.com/blog/post/2011/01/14/At-Last!-Created-My-Own-eBay-Style-Search-Using-Solrnet.aspx" rel="ugc">http://www.isurinder.com/blog/post/2011/01/14/At-Last!-Created-My-Own-eBay-Style-Search-Using-Solrnet.aspx</a>.<br />
<br />
I am using SolrNet to create my search facet's. However, SolrNet uses Tomcat Apache as its backbone to do the indexing. Unfortunately, due to hosting restrictions, I cannot install Apache on my clients server.<br />
<br />
Is there any .NET alternatives to carry out searching in a similar manner using just .NET and SQL Server?<br />
<br />
I have been looking up SQL Server Full Text Indexing, but I don't know how I would use this for my situation.
</div>
</div>


I have a basic implementation of using multi-facet searching in a small application I created. Similar to the one this guy has: http://www.isurinder.com/blog/post/2011/01/14/At-Last!-Created-My-Own-eBay-Style-Search-Using-Solrnet.aspx.

I am using SolrNet to create my search facet's. However, SolrNet uses Tomcat Apache as its backbone to do the indexing. Unfortunately, due to hosting restrictions, I cannot install Apache on my clients server.

Is there any .NET alternatives to carry out searching in a similar manner using just .NET and SQL Server?

I have been looking up SQL Server Full Text Indexing, but I don't know how I would use this for my situation.

Multi-facet search using SQL Server Full Text Search in ASP.NET

The successor to Active Server Pages, ASP.NET websites utilize the .NET framework to produce dynamic, data and content-driven web applications and services. ASP.NET code can be written using any .NET supported language. As of 2009, ASP.NET can also apply the Model-View-Controller (MVC) pattern to web applications

ASP.NET

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.