Simple DB appliaction - DB

[Andy.I]

Hi

I'm working on a little database application, and mst be cosnidered a
newbie. What are the recomended way of making the database? Is it by adding
a database file directy in my vb solution, or making a database on my SQL
server and connecting to this?
If I choose add item from "solution explorer" and adds a SQL Server database
this way, what are the differendec with this and making it on the SQL
Server?

/A.

[Miro]

If you are like me - and when I started I went the Access Database
method - I would suggest - Don't.

I have switched to SQL Express. ( you will have to learn it sooner or
later anyway ).

Creating the database in the Solutions Explorer is just like doing it
through SQL Server. You will notice some terminology on some screens
will change ( seems like 2 different groups wrote them and didn't talk
to each other ) - and some items are in different positions.

As a newbie... you should get by with visual studio just fine up until
you get to security stuff ( for connecting to the database ). - I have
not gotten to this part yet.

There are some very helpful videos on Microsoft as well.
http://msdn2.microsoft.com/en-ca/vstudio/Aa700732.aspx

Hope that helps, and those are my 2 beginner cents as well.

Miro

Andy.I wrote:

Hi

I'm working on a little database application, and mst be cosnidered a
newbie. What are the recomended way of making the database? Is it by
adding a database file directy in my vb solution, or making a database
on my SQL server and connecting to this?
If I choose add item from "solution explorer" and adds a SQL Server
database this way, what are the differendec with this and making it on
the SQL Server?

/A.

[Andy.I]

I thanks for the answer.
I'm talking about SQL databases in both options. But the difference between
adding the database (sql database) in solution explorer as oposed to doing
this on the SQL serfer through management studio. Sorry if it seemed like
i'm was talking about Access.

/A.

"Miro" <mi******@golden.netwrote in message
news:46**************@golden.net...

If you are like me - and when I started I went the Access Database
method - I would suggest - Don't.

I have switched to SQL Express. ( you will have to learn it sooner or
later anyway ).

Creating the database in the Solutions Explorer is just like doing it
through SQL Server. You will notice some terminology on some screens will
change ( seems like 2 different groups wrote them and didn't talk to each
other ) - and some items are in different positions.

As a newbie... you should get by with visual studio just fine up until you
get to security stuff ( for connecting to the database ). - I have not
gotten to this part yet.

There are some very helpful videos on Microsoft as well.
http://msdn2.microsoft.com/en-ca/vstudio/Aa700732.aspx

Hope that helps, and those are my 2 beginner cents as well.

Miro

Andy.I wrote:

>Hi

I'm working on a little database application, and mst be cosnidered a
newbie. What are the recomended way of making the database? Is it by
adding a database file directy in my vb solution, or making a database on
my SQL server and connecting to this?
If I choose add item from "solution explorer" and adds a SQL Server
database this way, what are the differendec with this and making it on
the SQL Server?