• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 416
  • Last Modified:

ASP.NET, SQL Server

I am researching on what programming language to use if I have data stored in a SQL Server database.   If I wanted to have a webpage with a search field. Can you give me some options on what language to use to accomplish this using .NET.  I am not concerned with how to do this with code, just general direction at this point.  Also, I read about SQL Server having an option for Free Text Search,  can this be incorporated as well?  Thanks.
0
fjkaykr11
Asked:
fjkaykr11
  • 4
  • 4
1 Solution
 
PortletPaulCommented:
perhaps consider: C#

it seems to be gaining in popularity for .net e.g.
http://msdn.microsoft.com/en-us/library/aa664274(v=vs.71).aspx
http://programmers.stackexchange.com/questions/125712/for-what-reasons-should-i-choose-c-over-java-and-c

You can access the free text search capabilities of sql server via standard query execution (as long as you use the correct syntax, but that's true of any query).
0
 
fjkaykr11Author Commented:
thanks for the reply.   Just to clarify. So if I have a blank webpage.  And I want to insert a search field and connect to a SQL Server database. I would just need C# to add this particular function? I definitely want to stick with .NET.  Thanks again.
0
 
PortletPaulCommented:
C# is an option, not a necessity

e.g. http://www.dotnetpowered.com/languages.aspx

C# does have the advantage of Microsoft being behind it, and as I suggested earlier appears to be gaining in popularity.

hello world
http://msdn.microsoft.com/en-us/library/aa288463(v=vs.71).aspx
http://stackoverflow.com/questions/10919519/how-can-i-display-hello-world-in-an-aspx-file
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
fjkaykr11Author Commented:
thanks for the links on comparison of languages.  I just want to make sure the feature I am looking to ad is done with #C or do also need to incorporate another language within the C# code to add the search field and connect it to the database.
0
 
PortletPaulCommented:
"need another language?" = not to my knowledge, no.
what you are asking for isn't weird or unusual
a web form
a way to access sql server
a way to pass a query to sql server
a way to get the results of the query
a way to present the results of a query

C# is used every day someplace in the world for this type of thing
& every one of those languages should be capable of this (well the vast majority)

I'm not pushing you to C#, I repeat it is an option.
0
 
fjkaykr11Author Commented:
thanks. the reason I am asking is because I had someone else create a basic website for me in the past with an ASP calendar and storing info in SQL Server. It sounded fairly straight forward but it involved quite a bit more than just C#.  I know they weren't trying to just over complicate or add hours because it was a flat rate.  I wanted to learn this basic step of adding a search field, I just wanted to make sure i was starting the right direction.
0
 
PortletPaulCommented:
If you are adding to something exists then why not use the same technology? particularly if you already have a sql server backend already established. "if it ain't broke don't fix it"

if you are completely overhauling that website (or replacing it) then you might want to explore newer approaches.
0
 
fjkaykr11Author Commented:
this is a new webpage that I am just trying to create from scratch for learning. I just wanted to add a field to search the database as a start.  I am not looking to edit the old webpage.  thanks again.
0

Featured Post

Become an Android App Developer

Ready to kick start your career in 2018? Learn how to build an Android app in January’s Course of the Month and open the door to new opportunities.

  • 4
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now