Setting up a database for work
Setting up a database for work
Setting up a database for work
Setting up a database for work
Setting up a database for work
Setting up a database for work Setting up a database for work Setting up a database for work Setting up a database for work Setting up a database for work Setting up a database for work Setting up a database for work Setting up a database for work
Setting up a database for work Setting up a database for work
Setting up a database for work
Go Back  Xtreme Visual Basic Talk > > > Setting up a database for work


Reply
 
Thread Tools Display Modes
  #1  
Old 02-09-2014, 06:26 PM
thousandpimps thousandpimps is offline
Newcomer
 
Join Date: Feb 2010
Posts: 1
Smile Setting up a database for work


Hi Guys,

I have setup some asp.net websites with a small database in the past but it was long time ago. I used vb.net and it was for a school project. I have some experience with it and I think with the help of youtube and google I will be able to get one up at work.

Right now, they are using a lot of spreadsheets and lot of vlookups and pivot tables. I will have access to VB Studio which should come with SQL. I was thinking to making their feeder(massive spreadsheet) as my database. What I want to accomplish are:

1. Making a webpage from which they can see the database(part of it) as a table with nice formats.
2. Making features from which they can add to the db or delete from the db.
3. Sorting features
4. Making a lot of graphs based on the information that I pull from the database.

I want the graphs and reports to dynamically change with the information in the database. So if someone enters a new customer and they say would go to a graph, it will reflect that new addition.


Could you guys reccomend me any videos, tutorials, any charting and graphing help, well anything that would help me set up a asp.net website. Also, if there anything I can add on to Visual Studio that can simplify the whole charting and graphing.

All the current data is in excel spreadsheets. What is the best way for me to put that into SQL database. I can just just go and start manually typing Customer Name, Revenue and so on, there area lot of fields.

I am thinking about making a prototype and seeing how it works.

Thanks a lot guys!
Reply With Quote
  #2  
Old 04-04-2014, 05:19 AM
JustinCase2 JustinCase2 is offline
Junior Contributor
 
Join Date: Apr 2006
Posts: 324
Default Suggestions

- For creating and manipulating Your database, i would recommend you use some sort of ORM. That will help you a lot in defining and accessing the db, and let you work With Objects instead of datasheets. In my opinion the best one for .Net is NHibernate. It will work against most types of SQL databases (you did not mention which one you will be using, but SQLExpress, MySQL or PosgreSQL are Your best options). There are plenty of tutorial videos on youtube for this.
- When it comes to Charts, .Net has a build-in chart Control (http://msdn.microsoft.com/en-us/libr...v=vs.110).aspx). However that may not be the best, and using a 3rd party Control will simplify it and probably make it look better (http://www.telerik.com/products/aspn...tml-chart.aspx, http://www.chartingcontrol.net/). I'm sure you can find some freeware ones aswell.
- Dynamically updating the data in the webpage is just a matter of adding a timer to your page, and update the data now and again. http://robertgreiner.com/2010/06/usi...timers-in-net/.
- When it comes to creating the DB and fill the data from Your spreadsheets, most db engines have routines for this. In SQLExpress for instance, you can easily import data from an Excel spreadsheet into tables. The tables must be predefined, but you should let Your ORM handle that part anyway.

Hope that gets you started.
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Forum Jump

Advertisement:





Free Publications
The ASP.NET 2.0 Anthology
101 Essential Tips, Tricks & Hacks - Free 156 Page Preview. Learn the most practical features and best approaches for ASP.NET.
subscribe
Programmers Heaven C# School Book -Free 338 Page eBook
The Programmers Heaven C# School book covers the .NET framework and the C# language.
subscribe
Build Your Own ASP.NET 3.5 Web Site Using C# & VB, 3rd Edition - Free 219 Page Preview!
This comprehensive step-by-step guide will help get your database-driven ASP.NET web site up and running in no time..
subscribe
Setting up a database for work
Setting up a database for work
Setting up a database for work Setting up a database for work
Setting up a database for work
Setting up a database for work
Setting up a database for work Setting up a database for work Setting up a database for work Setting up a database for work Setting up a database for work Setting up a database for work Setting up a database for work
Setting up a database for work
Setting up a database for work
 
Setting up a database for work
Setting up a database for work
 
-->