Wrox Programmer Forums
Go Back   Wrox Programmer Forums > ASP.NET and ASP > ASP.NET 2.0 > ASP.NET 2.0 Basics
|
ASP.NET 2.0 Basics If you are new to ASP or ASP.NET programming with version 2.0, this is the forum to begin asking questions. Please also see the Visual Web Developer 2005 forum.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the ASP.NET 2.0 Basics section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old January 6th, 2007, 01:17 AM
Registered User
 
Join Date: Dec 2004
Posts: 9
Thanks: 0
Thanked 0 Times in 0 Posts
Default Need help with databases in ASP.NET 2.0

I have Visual Studio 2005. It seems to be set up to use SQL Server Express, and I want to use SQL Server 2005.

What are the databases I can create in VS? Are they part of SQL Express? Are they intermediate for holding data before uploading it to the actual database? What does it mean to attach and detach? Can someone point me to a good overview on this? There seem to be too many parts and I don't know how they all fit in together.

Thanks,
Diane

 
Old March 3rd, 2007, 11:57 PM
Authorized User
 
Join Date: Sep 2006
Posts: 41
Thanks: 0
Thanked 0 Times in 0 Posts
Default

SqlExpress Versus Sql Server 2005.
In general you can use both Express and the regular one. it doesn't matter.
However some features doesn't work with express version, but at the same time some of them wil require only express version to be installed on your system.
Yes at some cases you will need to setup two instances of the Sql servers at the same time.
generally the Sql Server 2005 will go first, then install the express version on top of the regular one.
Most of the Examples from the Professional Asp.Net Book will work with Express version.
For example in a case you need to import another database to sql server you better use the Regular one not the express, because there's an import option-wizard available in the Regular Sql Server 2005.
You can easily import EXEL databases by simply cliking the import button.
............
usually you will create an SQl databases in the VS.. I'm not an expert in sql server. but,
this kind of things are very easy to achieve.
basically all the databases will be created in the utility programm called Sql managment studio express.
Whithin the database it self you will be able to create a tables, usually the information is stored inside the tables.
attach/detach
Well let's keep it simple.. at the begining I didn't knew this my self, but as I realised from experementing with the sql server. attaching means this:
Imagine your self a database file that exists somewhere in your hard-drive..
So generally all of the sql databases have an MDF extention. For example: Northwind.mdf
Basically if you have this mdf file somewhere in your Pc you can attach it to your sql server.
The same thing with the detaching, once you attached the mdf file to your sql server you can detach it vice versa.
...As I remember, generally if you want to delete the database from the sql server you must first detach it from the sql server.
howevere it seems to me that attach/detach capability is not presented in the Express version.
I'm not sure, I simply don't remeber this one :)
..about the intermediate...
Well I think that all of the data that comes from User is going straight to the database table.
...
yep if you talking about complicated tasks like... for example: adding an update functionality to the gridview control. this allows you to Update information whithin a customers table for example. So, yep in this case yoou will need to setup-Write some code in the sqldatasource control that called parameters.Yes you can call this thing Intermadiate MODE, when the actuall data that comes from the user, first go's to the parameters, and only then it go's to the physical table in the database.. But this is very easy to understand, because you will realise that the only whay to do this is simply use this parameters everytime you want to update information within any table..Thinks ike this taking time to learn.
yep i know that there's a lot of things going on in the sql server, but believe me it's not that hard.
you simply must learn things here and there. I realised that things get easyer with the time... don't stop study. :)





Similar Threads
Thread Thread Starter Forum Replies Last Post
Professional ASP.NET 2.0 Databases bonekrusher BOOK: Beginning ASP.NET 2.0 and Databases 2 January 3rd, 2007 10:37 AM
code of "Begining ASP.NET Databases using C#" aini2003 ASP.NET 1.0 and 1.1 Basics 1 December 12th, 2006 04:27 AM
ASP.NET Databases Using VB.NET Christiane Giguere General .NET 2 January 23rd, 2005 02:27 PM
Beginning ASP.Net Databases Using VB.Net ISBN 6195 tlamazares SQL Server ASP 1 December 15th, 2003 01:28 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.