• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 418
  • 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
 
PortletPaulfreelancerCommented:
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
 
PortletPaulfreelancerCommented:
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
The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

 
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
 
PortletPaulfreelancerCommented:
"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
 
PortletPaulfreelancerCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

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