<div>
If you like to code, then as long as you understand both front end (HTML,CS and JS) and back end (.NET, PHP, Node, Java) you can create your own. If this is not immediately familiar to you, I would skip this as each part has a learning curve. There are low-code/no-code options as well like those mentioned in this pros/cons article&nbsp;<a href="https://www.liquidweb.com/kb/the-top-five-open-source-nocode-tools/" rel="ugc">https://www.liquidweb.com/kb/the-top-five-open-source-nocode-tools/</a>. &nbsp;You will see that they can get pricy. The fastest and least expensive alternative would be to use Wordpress with Woocommerce or Shopify or other shopping site like&nbsp;<a href="https://squareup.com/us/en/ecommerce" rel="ugc">https://squareup.com/us/en/ecommerce</a>. &nbsp; With these options, you will need to import your products manually. If your products do not change very often this is not an issue. You can find connectors like zapier&nbsp;<a href="https://zapier.com/apps/sql-server/integrations/woocommerce" rel="ugc">https://zapier.com/apps/sql-server/integrations/woocommerce</a> or&nbsp;<a href="https://automate.io/integration/sql-server/woocommerce" rel="ugc">https://automate.io/integration/sql-server/woocommerce</a>. &nbsp;Importing once and then just updating pricing is going to be the easiest. To give you a direct answer will depend on your capabilities, the type of products, how often they change and any other features you require vs would just be nice to have. 
</div>

<div>
Info are changing daily and need to be updated per day. I always thing about back end as database and front end is application -presentation - form - visual part (HTML,CS and JS). Not sure why is .NET and PHP end tire? Are they kind middle tire between front and back end? &nbsp;
</div>

<div>
Depends on the life cycle of the site + how site will change over time. 
 
Using <a href="https://WordPress.org" rel="ugc">https://WordPress.org</a> is a good starting point with lots of different search approach plugins.
</div>

<div>
<blockquote>I always thing about back end as database and front end is application</blockquote> That is exactly right. Where it can get muddy is the back end code can generate the front end code. If you want to end up with<pre><code class="code-10 nolinks" id="code-20-43290057-1">&lt;!DOCTYPE html&gt;
&lt;html&gt;
&lt;head&gt;
&nbsp; &lt;meta charset="utf-8"&gt;
&nbsp; &lt;meta name="viewport" content="width=device-width"&gt;
&nbsp; &lt;title&gt;test&lt;/title&gt;
&lt;/head&gt;
&lt;body&gt;
&nbsp; &nbsp; Shirt
&lt;/body&gt;
&lt;/html&gt;
</code></pre> You can get there in multiple ways. Could be as simple as<pre><code class="code-10 nolinks" id="code-20-43290057-2">&lt;!DOCTYPE html&gt;
&lt;html&gt;
&lt;head&gt;
&nbsp; &lt;meta charset="utf-8"&gt;
&nbsp; &lt;meta name="viewport" content="width=device-width"&gt;
&nbsp; &lt;title&gt;test&lt;/title&gt;
&lt;/head&gt;
&lt;body&gt;
&nbsp; &nbsp; &lt;?php 
 // CODE TO ACCESS DATABASE
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$product = $db['Name'];

 echo $product
 ?&gt;
&lt;/body&gt;
&lt;/html&gt;
</code></pre>Or you could have an HTML page of just <pre><code class="code-10 nolinks" id="code-20-43290057-3">&lt;!DOCTYPE html&gt;
&lt;html&gt;
&lt;head&gt;
&nbsp; &lt;meta charset="utf-8"&gt;
&nbsp; &lt;meta name="viewport" content="width=device-width"&gt;
&nbsp; &lt;title&gt;test&lt;/title&gt;
&lt;/head&gt;
&lt;body&gt;
&nbsp; &nbsp; &lt;div id="response"&gt;&lt;/div&gt;
&lt;script&gt;
// AJAX CODE TO FETCH DATA AND INJECT INSIDE OF div#response
&lt;/script&gt;
&lt;/body&gt;
&lt;/html&gt;
</code></pre> All of this is really another discussion. Your question is, "...which application to use to create on company website ..." The answer to that is it depends on the factors that I already mentioned. &nbsp;If you do not have somebody that knows front end, back end and database (could be multiple people), then going down the road of PHP, .NET, Java, Node etc is not an option unless you decide to go with an outside firm to develop your site. The other end of the spectrum is using a low-code/no-code option. Those get to be expensive and are really geared for larger companies that have the budget. In the middle are wordpress/woo, shopify &nbsp;and the others. If your pricing only changes daily, that is still one human upload. There will be ways to automate as I showed you or you can do some custom programming. Without more details about your business and if you are looking to code something, use low-code or something in between.
</div>

Taras

<div>
Thank you, for giving me good info to start.
</div>

<div>
<div class="content wysiwyg-content fr-view">
What is good approach- which application to use to create on company website option for a user first to log in, verify and then search by one parameter(product catalog#)&nbsp; to display info about products. Products info are stored in database is SQL Server. Company do not have data warehouse. Please any suggestion.
</div>
</div>


What is good approach- which application to use to create on company website option for a user first to log in, verify and then search by one parameter(product catalog#)  to display info about products. Products info are stored in database is SQL Server.
Company do not have data warehouse.
Please any suggestion.

Search database on website

Web development includes all aspects of presenting content on intranets and the Internet, including delivery development, protocols, languages and standards, server software, browser clients, databases and multimedia generation.

Web Development

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.