Solved

ASP.NET, SQL Server

Posted on 2013-05-29
8
404 Views
Last Modified: 2013-05-29
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
Comment
Question by:fjkaykr11
  • 4
  • 4
8 Comments
 
LVL 48

Expert Comment

by:PortletPaul
ID: 39206525
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
 
LVL 3

Author Comment

by:fjkaykr11
ID: 39206536
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
 
LVL 48

Expert Comment

by:PortletPaul
ID: 39206545
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
Webinar: Aligning, Automating, Winning

Join Dan Russo, Senior Manager of Operations Intelligence, for an in-depth discussion on how Dealertrack, leading provider of integrated digital solutions for the automotive industry, transformed their DevOps processes to increase collaboration and move with greater velocity.

 
LVL 3

Author Comment

by:fjkaykr11
ID: 39206562
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
 
LVL 48

Accepted Solution

by:
PortletPaul earned 500 total points
ID: 39206599
"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
 
LVL 3

Author Closing Comment

by:fjkaykr11
ID: 39206702
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
 
LVL 48

Expert Comment

by:PortletPaul
ID: 39206728
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
 
LVL 3

Author Comment

by:fjkaykr11
ID: 39206743
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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

For most people, the WrapPanel seems like a magic when they switch from WinForms to WPF. Most of us will think that the code that is used to write a control like that would be difficult. However, most of the work is done by the WPF engine, and the W…
Problem Hi all,    While many today have fast Internet connection, there are many still who do not, or are connecting through devices with a slower connect, so light web pages and fast load times are still popular.    If your ASP.NET page …
This is Part 3 in a 3-part series on Experts Exchange to discuss error handling in VBA code written for Excel. Part 1 of this series discussed basic error handling code using VBA. http://www.experts-exchange.com/videos/1478/Excel-Error-Handlin…

856 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question