Solved

ASP.NET, SQL Server

Posted on 2013-05-29
8
405 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
PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

 
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

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.

Question has a verified solution.

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

Suggested Solutions

Whether you've completed a degree in computer sciences or you're a self-taught programmer, writing your first lines of code in the real world is always a challenge. Here are some of the most common pitfalls for new programmers.
This article shows how to deploy dynamic backgrounds to computers depending on the aspect ratio of display
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…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

713 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