Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Sheryl99
Starting Member
1 Post |
 Posted - 2008-09-30 : 22:01:11
|
| Hi, there. I am using VB.NET 2005 and SQL Server 2005. I don't have a clue about how to connect to SQL Server, or where to enter the fields for a new database. I am very experienced with databases, especially designing them, I just need some help getting started with SQL Server.Thank you!Sheryl |
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2008-09-30 : 22:15:54
|
| http://www.asp.net/learn/ |
 |
|
|
Chinni
Yak Posting Veteran
95 Posts |
Posted - 2008-10-01 : 12:39:45
|
| If you install SQL server...........start - programs-sql servre management studioWhen you open this this will ask to connect Servertype:database engineservername:drop down list populated server /enter ur server nameauthentication:1.windows if local server2.sql server authentication if u have passwd n username for that particular serverthen ConnectOnce you connectedUnder ur server name you can see database,security,etc..right click on databases - new databaseonce database created - in that u have tablesright click tables - new table - give the field names,datatype,null/not nullOnce done with creation of tableYou can use sql quries to insert/update/delete...or right click on your table you can see modify,open etc..If I understand your question correct........hope this mat help you a little bit |
|
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2008-10-01 : 13:10:42
|
quote:
Originally posted by Chinni
If you install SQL server...........start - programs-sql servre management studioWhen you open this this will ask to connect Servertype:database engineservername:drop down list populated server /enter ur server nameauthentication:1.windows if local server2.sql server authentication if u have passwd n username for that particular serverthen ConnectOnce you connectedUnder ur server name you can see database,security,etc..right click on databases - new databaseonce database created - in that u have tablesright click tables - new table - give the field names,datatype,null/not nullOnce done with creation of tableYou can use sql quries to insert/update/delete...or right click on your table you can see modify,open etc..If I understand your question correct........hope this mat help you a little bit
in vb.net ?Its way beyond that. You have to use Visual studio.1. Create a connection string in your web.config file2. Declare you sql namespace3. create your connection in your code behind4. reference your connection from your control events.... etc Buy a book or go through those tutorials above, as its quite vast. |
|
|
|
|
|
|
|
|
How do I connect to SQL Server?