September 11, 2014 at 7:55 am
Hey guys,
I would like to make my first web page which can talk to a local sql 2008r2 server and I am not sure where to begin. I have some experience coding and I am confident I can put my nose in a manual and learn whatever language is most appropriate for this situation..however, I am not sure what languages to start investing my time in. I have never made a web page before but I would like to start.
My mission is to retrieve data from a few sql views and allow the website end (front end) to filter on some cases. I only have a few things to filter on at the moment, but of course I would like to keep my options open and be able to fill a grid with as many different columns as possible (I am trying to make something similar to access but I do not want to use access). I currently program with visual studio and would like to keep that option open (if possible) because my friends also use this and we would like to work on it together.
Could someone with more experience than please let me know what direction I should head in, and if you have done this type of thing before could you please let me know what you did and how it turned out. Thank you
September 11, 2014 at 8:38 am
Ryan1 (9/11/2014)
Hey guys,I would like to make my first web page which can talk to a local sql 2008r2 server and I am not sure where to begin. I have some experience coding and I am confident I can put my nose in a manual and learn whatever language is most appropriate for this situation..however, I am not sure what languages to start investing my time in. I have never made a web page before but I would like to start.
My mission is to retrieve data from a few sql views and allow the website end (front end) to filter on some cases. I only have a few things to filter on at the moment, but of course I would like to keep my options open and be able to fill a grid with as many different columns as possible (I am trying to make something similar to access but I do not want to use access). I currently program with visual studio and would like to keep that option open (if possible) because my friends also use this and we would like to work on it together.
Could someone with more experience than please let me know what direction I should head in, and if you have done this type of thing before could you please let me know what you did and how it turned out. Thank you
Teaching you how to write a web application is way beyond the scope of an online forum and is subject to everybody's personal taste. If you are doing a website stay away from Access unless your website is only going to have 1 visitor at a time.
Visual Studio is a great choice for this. Create a new web application and find some tutorials. There are lots of third party tools out there for grids (DevExpress and Telerik are the big ones) which provide lots of functionality out of the box.
Decide on your database. SQLExpress might be a good choice as it is free which makes learning a lot less painful.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
September 11, 2014 at 8:48 am
Sean Lange (9/11/2014)
Teaching you how to write a web application is way beyond the scope of an online forum and is subject to everybody's personal taste. If you are doing a website stay away from Access unless your website is only going to have 1 visitor at a time.
Visual Studio is a great choice for this. Create a new web application and find some tutorials. There are lots of third party tools out there for grids (DevExpress and Telerik are the big ones) which provide lots of functionality out of the box.
Decide on your database. SQLExpress might be a good choice as it is free which makes learning a lot less painful.
Thank you for your response.
I do not need to be taught at this time. I need help deciding what languages I should be working with? Once I know that I can start going to town on simple tutorials until I get the basics down. I don't want to waste tons of time learning something that is irrelevant to my little project. Also, my database will be sql 2008 r2.
September 11, 2014 at 9:02 am
If you're interested on having help in the same place for front and back end, you might want to use SQL Server with visual studio and take a look at the Microsoft Virtual Academy.
Otherwise, there are lots of options and most languages will work with any commercial RDBMS without trouble.
September 11, 2014 at 9:04 am
Ryan1 (9/11/2014)
Sean Lange (9/11/2014)
Teaching you how to write a web application is way beyond the scope of an online forum and is subject to everybody's personal taste. If you are doing a website stay away from Access unless your website is only going to have 1 visitor at a time.
Visual Studio is a great choice for this. Create a new web application and find some tutorials. There are lots of third party tools out there for grids (DevExpress and Telerik are the big ones) which provide lots of functionality out of the box.
Decide on your database. SQLExpress might be a good choice as it is free which makes learning a lot less painful.
Thank you for your response.
I do not need to be taught at this time. I need help deciding what languages I should be working with? Once I know that I can start going to town on simple tutorials until I get the basics down. I don't want to waste tons of time learning something that is irrelevant to my little project. Also, my database will be sql 2008 r2.
Then stick with VisualStudio since you already use it. There are some differences between web applications and windows applications but many of the things you already know how to do are exactly the same.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
September 11, 2014 at 9:43 am
Thank you very much.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply