; Accessing Data With The Server Explorer In ASP.Net | SQL Server

Big Entertainment On Demand

Download APK  - Visit Here

Accessing Data With The Server Explorer In ASP.Net


Know More :  ASP.Net  VB.Net  C#.Net  Sliverlight  XML  WPF  WCF Ajax 
Let’s start in Microsoft Visual Studio 2010 and Microsoft SQL Server 2008,To work with a database, you need a connection to that database. In Microsoft Visual Basic.Net , the server explorer lets you work with connections to various data sources. To display the server explorer if it is not already visible, use view | server explorer menu item , or press Ctrl + Alt + S. As shown in figure.
ScreenShot071






where i have docked it to the left edge of the visual basic IDE(By Clicking the thumbnail icon). This tool lets you create and examine data connections , including connections to web servers ; you can see connections to various databases in the server explorer already. In this easy example , I am going to  display the data from the Employee table in the Microsoft SQL Server’s AdventureWorks – HumanResources sample database , So we’ll need a connection to that database. To create that connection , right click  the data connection icon in the server explorer and select the “add connection” item.Doing so opens the data link  properties dialog box you see in figure.
ScreenShot019 ScreenShot072
After complete your database connection. Now drag table from server explorer on the form as shown in figure.
ScreenShot073
Now , run the application or press f5 button | start debugging from debug menu , you can see the result in figure.Thanks.
ScreenShot074
 Know More :  ASP.Net  VB.Net  C#.Net  Sliverlight  XML  WPF  WCF Ajax
Share on Google Plus

About Sujay

Hi ! I am Sujay Sharma. I am working in Indian Railway as Guard. I am sharing my experience about Microsoft SQL Server with ASP.NET ,VB.NET,C#.NET,XML "" Thanks.
    Blogger Comment
    Facebook Comment

0 comments:

Post a Comment