 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
.NET Forum / ASP.NET / General / July 2007Create Database
Using Asp.net 1.1 I find tutorials on accessing or querying databases with asp.net. But how do I create the database to begin with (from a form that the user fills out)? > Using Asp.net 1.1 > > I find tutorials on accessing or querying databases with asp.net. But how > do I create the database to begin with (from a form that the user fills > out)? What database format? SQL Server, SQL Compact Edition, Jet, Oracle, FoxPro, MySql...???  Signaturehttp://www.markrae.net I don't know what format I should use. I know Access. I do not know the others. I don't have any programs on my computer except for Access. As for language - I do not know c#. I know vb. What would you recommend? >> Using Asp.net 1.1 >> [quoted text clipped - 4 lines] > What database format? SQL Server, SQL Compact Edition, Jet, Oracle, > FoxPro, MySql...??? >I don't know what format I should use. I know Access. I do not know the >others. I don't have any programs on my computer except for Access. As for >language - I do not know c#. I know vb. > What would you recommend? OK, let's for the sake of argument say that you're going to use Jet (which you refer to as an "Access database", although there's actually no such thing as an "Access database")... ADO.NET can do everything you could possibly want to do with a Jet database - except create one... :-) Fortunately, there's an easy workround for that - just create a completely blank database yourself, and then copy it to your website somewhere that ASP.NET can get hold if it but your users can't. Then, whenever you need to "create" a new database, just copy the blank one, rename it and add any database objects as required... SignatureMark Rae ASP.NET MVP http://www.markrae.net I don't understand. I have never heard of Jet. Why is Access not a database? Sorry to be so ignorant, but please enlighten me. Thanks >>I don't know what format I should use. I know Access. I do not know the >>others. I don't have any programs on my computer except for Access. As [quoted text clipped - 14 lines] > Then, whenever you need to "create" a new database, just copy the blank > one, rename it and add any database objects as required... Technically: JET (Joint Engine Technology) is the actual database engine for MS Access. MS Access is a visual add on to allow people to work with JET. But as far as I am concerned I and most of the programmers saying that we using MS Access database even if we do not use MS Access and accessing MDB files with .NET George. >I don't understand. I have never heard of Jet. > Why is Access not a database? Sorry to be so ignorant, but please [quoted text clipped - 20 lines] >> Then, whenever you need to "create" a new database, just copy the blank >> one, rename it and add any database objects as required... > Technically: JET (Joint Engine Technology) is the actual database engine > for MS Access. Yes indeed, and written by the SQL Server team, not the Access team... Microsoft shipped Jet with several tools, not just Access e.g. VB, VC++ etc... > MS Access is a visual add on to allow people to work with JET. Correct. > But as far as I am concerned I and most of the programmers saying that we > using MS Access database even if we do not use MS Access and accessing MDB > files with .NET Indeed - it has become synonymous with Access... AAMOI, the Jet database format is now deprecated and is about to become obsolete... SignatureMark Rae ASP.NET MVP http://www.markrae.net "AAMOI, the Jet database format is now deprecated and is about to become obsolete..." So does that mean that Access is about to become obsolete? >> Technically: JET (Joint Engine Technology) is the actual database engine >> for MS Access. [quoted text clipped - 16 lines] > AAMOI, the Jet database format is now deprecated and is about to become > obsolete... > "AAMOI, the Jet database format is now deprecated and is about to become > obsolete..." > > So does that mean that Access is about to become obsolete? You really need to sever the link between Jet and Access in your head... :-) The latest version of Access uses a new database format. It's quite similar to Jet, but isn't Jet http://databases.about.com/od/access/a/accdb.htm SignatureMark Rae ASP.NET MVP http://www.markrae.net You were the one who put the link in my head. Remember, I had never heard of Jet. >> "AAMOI, the Jet database format is now deprecated and is about to become >> obsolete..." [quoted text clipped - 7 lines] > similar to Jet, but isn't Jet > http://databases.about.com/od/access/a/accdb.htm > I don't know what format I should use. I know Access. I do not know the > others. I don't have any programs on my computer except for Access. As for > language - I do not know c#. I know vb. > What would you recommend? I would recommend to identify what kind of data and how many data you would have. 100 rows can be served anywhere, 1,000,000 would be a problem for Access. The number of records would not be large, but there would be a large number of fields: 50 fields, 4 of which could contain several sentences. Does that make a difference? >> I don't know what format I should use. I know Access. I do not know the >> others. I don't have any programs on my computer except for Access. As [quoted text clipped - 5 lines] > would have. 100 rows can be served anywhere, 1,000,000 would be a > problem for Access. > The number of records would not be large, but there would be a large number > of fields: 50 fields, 4 of which could contain several sentences. > Does that make a difference? I don't think that it make sense to install SQL Server for that, especially if you have no any background in it. That could be done either with Access or XML. Both have some advantages, and disadvantages. Maybe, Access (Jet) would be a best choice for you at the moment - you will see how it works and later maybe you could consider for a real database such as SQL Server. > I don't think that it make sense to install SQL Server for that, > especially if you have no any background in it. That could be done > either with Access or XML. Both have some advantages, and > disadvantages. Maybe, Access (Jet) would be a best choice for you at > the moment - you will see how it works and later maybe you could > consider for a real database such as SQL Server. SQL Server Compact Edition would also be a good solution: http://www.microsoft.com/sql/editions/compact/default.mspx SignatureMark Rae ASP.NET MVP http://www.markrae.net > > I don't think that it make sense to install SQL Server for that, > > especially if you have no any background in it. That could be done [quoted text clipped - 8 lines] > Mark Rae > ASP.NET MVPhttp://www.markrae.net Well, we need a database for one table with few records and 50 fields. SQL CE would be a good choice to learn the basics, but it cannot be used in production, right? I don't know where it supposed to be used, but if it will be hosted somewhere in the internet we would need another version of SQL. In this case, dancer could go for SQL Server Express Edition, which is better, I think. To switch from CE to SQL Server Standard Edition (or Enterprise) would require a change of data access code and CE is really limited (no stored procedures, etc). > Using Asp.net 1.1 > > I find tutorials on accessing or querying databases with asp.net. But how > do I create the database to begin with (from a form that the user fills > out)? You should create a database from the beginning. If a user filled out a form, the application should insert new record into a database. there are lots of example about of how to do this from code - for SQL server and for Access http://www.codeproject.com/cs/database/CreateDB.asp http://support.microsoft.com/kb/307283 http://support.microsoft.com/kb/317881 Regards John Timney (MVP) http://www.johntimney.com http://www.johntimney.com/blog > Using Asp.net 1.1 > > I find tutorials on accessing or querying databases with asp.net. But how > do I create the database to begin with (from a form that the user fills > out)? Will an XML file serve as a database? > Using Asp.net 1.1 > > I find tutorials on accessing or querying databases with asp.net. But how > do I create the database to begin with (from a form that the user fills > out)? > Will an XML file serve as a database? Yes, but that's really not what it's for... An Excel workbook could also be used as a database but, again, that's not what Excel is designed for... SignatureMark Rae ASP.NET MVP http://www.markrae.net What is XML designed for? >> Will an XML file serve as a database? > > Yes, but that's really not what it's for... > > An Excel workbook could also be used as a database but, again, that's not > what Excel is designed for... Its best suited for passing data around, so its good for small data islands, single recordsets, configuration data etc. Its more suited as the results of a database query as opposed to the database itself. Regards John Timney (MVP) http://www.johntimney.com http://www.johntimney.com/blog > What is XML designed for? > [quoted text clipped - 4 lines] >> An Excel workbook could also be used as a database but, again, that's not >> what Excel is designed for... Free MagazinesGet these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...
|
Reply to this Message
|
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.