Xtreme Visual Basic Talk

Xtreme Visual Basic Talk (http://www.xtremevbtalk.com/)
-   ASP.Net (http://www.xtremevbtalk.com/asp-net/)
-   -   Setting up a database for work (http://www.xtremevbtalk.com/asp-net/326823-setting-database.html)

thousandpimps 02-09-2014 06:26 PM

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!

JustinCase2 04-04-2014 05:19 AM

- 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. :)

All times are GMT -6. The time now is 12:41 AM.

Powered by vBulletin® Version 3.8.9
Copyright ©2000 - 2018, vBulletin Solutions, Inc.
Search Engine Optimisation provided by DragonByte SEO v2.0.15 (Lite) - vBulletin Mods & Addons Copyright © 2018 DragonByte Technologies Ltd.
All site content is protected by the Digital Millenium Act of 1998. Copyright©2001-2011 MAS Media Inc. and Extreme Visual Basic Forum. All rights reserved.
You may not copy or reproduce any portion of this site without written consent.