473,322 Members | 1,510 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

Create 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)?
Jul 1 '07 #1
20 1585
On Jul 1, 10:11 pm, "dancer" <dan...@microsoft.comwrote:
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.

Jul 1 '07 #2
"dancer" <da****@microsoft.comwrote in message
news:ud**************@TK2MSFTNGP04.phx.gbl...
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...???
--
http://www.markrae.net

Jul 1 '07 #3
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
"dancer" <da****@microsoft.comwrote in message
news:ud**************@TK2MSFTNGP04.phx.gbl...
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)?

Jul 1 '07 #4
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?
"Mark Rae" <ma**@markNOSPAMrae.netwrote in message
news:uS**************@TK2MSFTNGP02.phx.gbl...
"dancer" <da****@microsoft.comwrote in message
news:ud**************@TK2MSFTNGP04.phx.gbl...
>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...???
--
http://www.markrae.net

Jul 2 '07 #5
Will an XML file serve as a database?
"dancer" <da****@microsoft.comwrote in message
news:ud**************@TK2MSFTNGP04.phx.gbl...
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)?

Jul 2 '07 #6
"dancer" <da****@microsoft.comwrote in message
news:ue**************@TK2MSFTNGP02.phx.gbl...
>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...
--
Mark Rae
ASP.NET MVP
http://www.markrae.net

Jul 2 '07 #7
"dancer" <da****@microsoft.comwrote in message
news:e%****************@TK2MSFTNGP06.phx.gbl...
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...
--
Mark Rae
ASP.NET MVP
http://www.markrae.net

Jul 2 '07 #8
What is XML designed for?
"Mark Rae" <ma**@markNOSPAMrae.netwrote in message
news:eS**************@TK2MSFTNGP06.phx.gbl...
"dancer" <da****@microsoft.comwrote in message
news:e%****************@TK2MSFTNGP06.phx.gbl...
>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...
--
Mark Rae
ASP.NET MVP
http://www.markrae.net

Jul 2 '07 #9
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
"Mark Rae" <ma**@markNOSPAMrae.netwrote in message
news:eQ**************@TK2MSFTNGP05.phx.gbl...
"dancer" <da****@microsoft.comwrote in message
news:ue**************@TK2MSFTNGP02.phx.gbl...
>>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...
--
Mark Rae
ASP.NET MVP
http://www.markrae.net

Jul 2 '07 #10
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
"dancer" <da****@microsoft.comwrote in message
news:%2****************@TK2MSFTNGP02.phx.gbl...
What is XML designed for?
"Mark Rae" <ma**@markNOSPAMrae.netwrote in message
news:eS**************@TK2MSFTNGP06.phx.gbl...
>"dancer" <da****@microsoft.comwrote in message
news:e%****************@TK2MSFTNGP06.phx.gbl...
>>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...
--
Mark Rae
ASP.NET MVP
http://www.markrae.net


Jul 2 '07 #11
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.
"dancer" <da****@microsoft.comwrote in message
news:%2****************@TK2MSFTNGP05.phx.gbl...
>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
"Mark Rae" <ma**@markNOSPAMrae.netwrote in message
news:eQ**************@TK2MSFTNGP05.phx.gbl...
>"dancer" <da****@microsoft.comwrote in message
news:ue**************@TK2MSFTNGP02.phx.gbl...
>>>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...
--
Mark Rae
ASP.NET MVP
http://www.markrae.net


Jul 2 '07 #12
On Jul 2, 3:16 pm, "dancer" <dan...@microsoft.comwrote:
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.

Jul 2 '07 #13
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?
"Alexey Smirnov" <al************@gmail.comwrote in message
news:11*********************@m36g2000hse.googlegro ups.com...
On Jul 2, 3:16 pm, "dancer" <dan...@microsoft.comwrote:
>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.

Jul 2 '07 #14
"George Ter-Saakov" <gt****@cardone.comwrote in message
news:OP**************@TK2MSFTNGP04.phx.gbl...
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...
--
Mark Rae
ASP.NET MVP
http://www.markrae.net

Jul 2 '07 #15
On Jul 2, 6:33 pm, "dancer" <dan...@microsoft.comwrote:
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.

Jul 2 '07 #16
"Alexey Smirnov" <al************@gmail.comwrote in message
news:11**********************@q75g2000hsh.googlegr oups.com...
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/edition...t/default.mspx
--
Mark Rae
ASP.NET MVP
http://www.markrae.net

Jul 2 '07 #17
On Jul 2, 7:19 pm, "Mark Rae" <m...@markNOSPAMrae.netwrote:
"Alexey Smirnov" <alexey.smir...@gmail.comwrote in message

news:11**********************@q75g2000hsh.googlegr oups.com...
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/edition...t/default.mspx

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

Jul 2 '07 #18
"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?

"Mark Rae" <ma**@markNOSPAMrae.netwrote in message
news:%2****************@TK2MSFTNGP05.phx.gbl...
"George Ter-Saakov" <gt****@cardone.comwrote in message
news:OP**************@TK2MSFTNGP04.phx.gbl...
>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...
--
Mark Rae
ASP.NET MVP
http://www.markrae.net

Jul 2 '07 #19
"dancer" <da****@microsoft.comwrote in message
news:ud**************@TK2MSFTNGP04.phx.gbl...
"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
--
Mark Rae
ASP.NET MVP
http://www.markrae.net

Jul 2 '07 #20
You were the one who put the link in my head.
Remember, I had never heard of Jet.

"Mark Rae" <ma**@markNOSPAMrae.netwrote in message
news:eL**************@TK2MSFTNGP05.phx.gbl...
"dancer" <da****@microsoft.comwrote in message
news:ud**************@TK2MSFTNGP04.phx.gbl...
>"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
--
Mark Rae
ASP.NET MVP
http://www.markrae.net

Jul 2 '07 #21

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

5
by: lkrubner | last post by:
I have a webserver through Rackspace. I create a domain. I create an FTP user. I upload some files. I create a database called testOfSetupScript and then I create a database user named setup. I...
5
by: Frank van Vugt | last post by:
Hi, I noticed that when using the single commandline: drop database <name>; create database <name>; this sometimes fails due to a pg_autovacuum process running on the background. When...
4
by: intl04 | last post by:
How do I create a data input form in Access that is external to the Access database to which it's connected (if that's possible, which I believe it is)? For example, if someone clicks on an Access...
1
by: intl04 | last post by:
I am getting strange print-related error messages when trying to create (not print!) reports. For example, when I click 'new' to create a report then choose 'design view', I get an error message...
9
by: Peter | last post by:
Hello£¬everyone, My program will collect a testing machine's data ,save the data and deal with the data everyday. I want to use vb.net to create database, add and delete tables or modify the...
14
by: mistral | last post by:
Need php script to create mySQL database programmatically; since hosting configuration may not allow create database from script, script also need eliminate/rewrite all restrictions in appropriate...
27
by: max | last post by:
Hello, I am a newbye, and I'm trying to write a simple application. I have five tables with three columns; all tables are identical; I need to change some data in the first table and let VB...
4
by: etuncer | last post by:
Hello All, I have Access 2003, and am trying to build a database for my small company. I want to be able to create a word document based on the data entered through a form. the real question is...
15
by: lxyone | last post by:
Using a flat file containing table names, fields, values whats the best way of creating html pages? I want control over the html pages ie 1. layout 2. what data to show 3. what controls to...
10
by: AAaron123 | last post by:
I want to create a database with one table on the host. I can't user SQL Server Management Studio to do it so I guess I have to do it programmatically. I have in mind that in the session start...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.