Solved

ASP.NET, SQL Server

Posted on 2013-05-29
8
407 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 4
8 Comments
 
LVL 49

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 49

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
Linux Academy Android App Now Supports Chromecast

We have some fantastic news for our Android fans. We’re so excited to announce that the Linux Academy Android app is now available with Chromecast support. That’s right – simply download the latest update of the Linux Academy App and start casting your favorite course videos!

 
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 49

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 49

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

RHCE - Red Hat OpenStack Prep Course

This course will provide in-depth training so that students who currently hold the EX200 & EX210 certifications can sit for the EX310 exam. Students will learn how to deploy & manage a full Red Hat environment with Ceph block storage, & integrate Ceph into other OpenStack service

Question has a verified solution.

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

Introduction This article shows how to use the open source plupload control to upload multiple images. The images are resized on the client side before uploading and the upload is done in chunks. Background I had to provide a way for user…
It was really hard time for me to get the understanding of Delegates in C#. I went through many websites and articles but I found them very clumsy. After going through those sites, I noted down the points in a easy way so here I am sharing that unde…
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…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

628 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