with visual studio 2010 i got microsoft sql server 2008,, now for the first time how to create a datasource and database in it..to make database connectivity??
You can make a database by epanding the server explorer then right click on it then create new database. Now in order to determine the connection string of this database you can also right click the database then click properties then find the connection
string. Use this connection string for you to have connections in your database
shruthi06
0 Points
1 Post
database connectivity using sql server 2008!!
Jul 15, 2012 07:13 AM|LINK
with visual studio 2010 i got microsoft sql server 2008,, now for the first time how to create a datasource and database in it..to make database connectivity??
Ruchira
All-Star
44342 Points
7194 Posts
MVP
Re: database connectivity using sql server 2008!!
Jul 15, 2012 08:28 AM|LINK
Hello,
Below link will help you
http://msdn.microsoft.com/en-us/library/tw738475.aspx
My Tech blog | My YouTube ChannelPlease 'Mark as Answer' if this post helps you.ustbwuyi
Member
12 Points
6 Posts
Re: database connectivity using sql server 2008!!
Jul 15, 2012 01:46 PM|LINK
Check the code of SqlHelp.cs
paulalvin
Member
229 Points
246 Posts
Re: database connectivity using sql server 2008!!
Jul 16, 2012 03:33 AM|LINK
You can make a database by epanding the server explorer then right click on it then create new database. Now in order to determine the connection string of this database you can also right click the database then click properties then find the connection string. Use this connection string for you to have connections in your database
Frank Jiang ...
All-Star
16006 Points
1728 Posts
Microsoft
Re: database connectivity using sql server 2008!!
Jul 19, 2012 10:15 AM|LINK
Connect to a SQL Server Database using the SqlDataSource Control:
http://msdn.microsoft.com/en-us/library/ms247242.aspx
Create DataBase in viual studio ultimate 2010
http://www.dotnetcurry.com/ShowArticle.aspx?ID=548
http://www.youtube.com/watch?v=KWCIyvka9eA
Feedback to us
Develop and promote your apps in Windows Store
pradeep shar...
Contributor
4004 Points
763 Posts
Re: database connectivity using sql server 2008!!
Jul 19, 2012 11:27 AM|LINK
follow this link, it will help u sure
http://www.asp.net/web-forms/tutorials/data-access/accessing-the-database-directly-from-an-aspnet-page/querying-data-with-the-sqldatasource-control-vb
http://asp-net-example.blogspot.co.uk/2008/12/aspnet-sqldatasource-example-using.html