.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

what is the benefit of creating New Data Souce in Visual studio

Posted By:      Posted Date: October 08, 2010    Points: 0   Category :ASP.Net

In visual studio 2005  for windows application , there is option where you can add New datasource by going to menu Data>Add New Data source,  

I know you can connect to database by using Dim con as connection, Dim cmd as command, Dim da as dataadapter, then query database and get result,


then what is the point or advantage of using datasource(Data>Add New Data source)


Some one give me advice on this issue


thank you


View Complete Post

More Related Resource Links

About Dynamic Data in Visual Studio 2010 / .NET 4



Does anybody here have any pointers to screencasts, demos, webcasts for the latest enhancements in Dynamic Data as listed in above link? I'm repeating them here for ready reference :


  • EnableDynamicData method which enables Dynamic Data features in existing ASP.NET applications and DataSource controls
  • A new QueryExtender control, contained in the sample projects to simplify common data filtering operations. It supports a rich ASP.NET declarative query syntax that makes it easy to do things like search data for text or have filters based on ranges
  • A new Dynamic Data filter model that enables the developers to apply templates to pages just like field templates (including user defined filters)
  • New field templates of Email, URL and Enum columns
  • Support for inheritance in Entity Framework and Linq to SQL
  • Support for many to many relationships in Entity Framework
  • New Entity Templates which allow fine control over how an object is displayed and edited
  • DynamicHyperLink control for building links to tables and actions
  • Declarative support for D

VS 2010: Entity Framework 4.0 and WCF Data Services 4.0 in Visual Studio 2010


Elisa Flasko takes you through a sample weblog application to demonstrate how new improvements in Entity Framework and WCF Data Services work together to simplify the way data is modeled, consumed and produced in Visual Studio 2010.

Elisa Flasko

MSDN Magazine April 2010

Data Joins The Team: Introducing Visual Studio 2005 Team Edition for Database Professionals


Here Brian Randell presents everything you need to know to get started with Visual Studio 2005 Team Edition for Database Professionals.

Brian A. Randell

MSDN Magazine February 2007

Office Unbound: Bring Your Documents To Life With Data Binding In Visual Studio Tools For Office


Thanks to Visual Studio 2005 Tools for the Microsoft Office System, Windows Forms controls can be bound to databases, Web services, or objects and added to a workbook or document. Find out how.

Eric Carter and Eric Lippert

MSDN Magazine March 2006

Creating Custom SharePoint 2010 Field Types and Controls with Visual Studio 2010 and Silverlight 3

Learn how developers can create rich experiences in SharePoint Server 2010 publishing sites using Microsoft Silverlight 3.

Video: Creating Custom SharePoint 2010 Field Types and Controls with Visual Studio 2010 and Silverli

Watch the video that accompanies the MSDN article and learn how developers can create rich experiences in SharePoint Server 2010 publishing sites using Microsoft Silverlight 3.

Video: SharePoint 2010: Creating .NET Assembly Connectors in Visual Studio 2010 Support

Learn how the inclusion of Business Connectivity Services (BCS) creates opportunities to leverage SharePoint features and APIs against your existing line of business data that is available via direct database access or via Web services. (Length: 5:41)

Video: Creating SharePoint 2010 Workflows in Visual Studio 2010

This demonstration shows how to create a site workflow by using Visual Studio 2010. (Length: 6:19)

How to use SharePoint 2007 list data in Reporting Service (Visual Studio) 2008?

Jeez - I have been googling left and right, and tried all the suggestions. No luck in getting it to work. I am using Reporting Service 2008 tools in my VS2008, trying to create a simple report using SharePoint 2007 data (from a simple list). Here is what I've been doing: Created a simple SharePoint list in a test site - only one column (Title) with one record of data. Started Visual Studio 2008 and created a new Report Server Project Wizard project. I named the data source "dsTest". Type: "XML". As connection string I used: http://site/subsite/subsite/_vti_bin/lists.asmx. Credentials: "Use Windows Authentication (Integrated Security)". Clicked Next and arrived at the "Design the Query" form. I entered this in the Query string box: <Query> <Method Namespace="http://schemas.microsoft.com/sharepoint/soap/" Name="GetListItems" /> <SoapAction>http://schemas.microsoft.com/sharepoint/soap/GetListItems</SoapAction> </Query> Clicking Next I get this error: An error occurred while the query design method was being saved. Failed to execute web request for the specified URL. Soap Fault: Exception of type 'Microsoft.SharePoint.SoapServer.SoapServerException' was thrown. Now if I view the Details when trying it inside the Query Builder I get this: <errorstring xmlns="http://schemas.mi

Visual Studio Hangs when Creating a New Website or Project

Greetings, Just as the subject says, my VS'05 installation hangs when trying to create a new website.  I even installed a fresh version of VS08 along side '05 and '08 is doing the same.  Any ideas on a fix or where to look? Thank you in advance. 

Visual Studio 2005 loses shared data source credentials upon restart...Has it...or Will it ever be f

This issue was submitted via feedback on connect.microsoft for SQL Server on 5/14/09 and I can't seem to find anywhere that says it has been fixed!!!  I just got a new PC and they imaged my PC after another co-workers and he was having this issue and now so am I!!  I'm desperate for a resolution as I have to restart almost daily and I have several shared data source connnections...  Here are the details that were submitted to Microsoft....  Please any help is appreciated!!   Type: Bug ID: 450753 Opened: 5/14/2009 4:31:05 PM Access Restriction: Public       0 Workaround(s) view 18 User(s) can reproduce this bug         I recently installed Service Pack 3 for SQL Server 2005 on my local machine, and now my saved credentials for my shared data sources in my Reporting Services project in Visual Studio 2005 SP1 are gone every time I restart my computer. I have to enter the specific User Name and Password into the Credentials tab every day for each shared data source. This problem never occurred before I installed SQL Server 2005 SP3, and now my co-workers are afraid to install SP3 on their machines. The server already has SP3 installed. Details (expand) Product Language English Version SQL Server 2005 SP3 Category Rep

Concatenating several rows data into one field Visual Studio 2008


Below is my a example of my table and data.  I am using Visual Studio 2008.  I need to concatenate field customer_report with like field ‘number’.  I added a new SQLDataSource and put the query below into it.


Select Main.number,

       Left(Main.CustomerNotes,Len(Main.CustomerNotes)-1) As "CustomerNotes"

From(Select distinct PS2.number, 

           (Select PS1.customer_report + ',' AS [text()]

Visual studio 2010 missing ajax and no web.config when creating new project



when i opened my Visual Studio 2010 i noticed that my ajax tab was missing from my toolbox and ajax control kit too.

Then i noticed even that when i create new website, there is no web.config in it and it should be.


please help, this is urgent (can't do nothing without ajax)

Visual Studio 2010 - Design Mode Error - "Error Creating Control"



I am using Visual Studio 2010.  I was debugging a web application and an exception happened and VS 2010 froze.  I ended the VS 2010 in the task manager and when I went back to developing, I found on every form for every ASP.net control I get:


Error Creating Control -

Error HRESULT E_FAIL has been returned from a call to a COM component.


Also I am unable to edit  the form or add anything from the toolbox.


Any help on this matter will be appreciated.





creating and hosting wcf service without Visual Studio


Hi to all,

   i want to create a wcf service that returns a string say "Hey i m running!" but without using Visual Studio(using comand prompt and notepad). it will help me understand the inner intricacies of WCF. what are the steps involved??



Visual Studio 2008 crashes on SSIS Data Flow Task opening


Visual Studio 2008 crashes on SSIS Data Flow Task opening.
This is a random behavior on random SSIS packages on Data Flow Task opening on packages that I've finished developing last week. The packages does not executes with error.

Error Description from Event Viewer:
Faulting application devenv.exe, version 9.0.30729.1, stamp 488f2b50, faulting module msdds.dll, version 9.0.30729.1, stamp 488f2e31, debug? 0, fault address 0x00012b6a.

I'm runnig SSIS development against SQL SERVER 2008 ENT 64.

There is already a fix for this ?

My environment description:
Microsoft Visual Studio 2008
Version 9.0.30729.1 SP
Microsoft .NET Framework
Version 3.5 SP1
Installed Edition: Professional

Microsoft Visual Basic 2008 91605-270-4167253-60984
Microsoft Visual Basic 2008
Microsoft Visual C# 2008 91605-270-4167253-60984
Microsoft Visual C# 2008
Microsoft Visual Studio 2008 Tools for Office 91605-270-4167253-60984
Microsoft Visual Studio 2008 Tools for Office
Microsoft Visual Web Developer 2008 91605-270-4167253-60984
Microsoft Visual Web Developer 2008
Crystal Reports    AAJ60-G0MSA4K-68000CF
Crystal Reports Basic for Visual Studio 2008
KB944899, KB945282, KB946040, KB946308, KB946344, KB946581, KB947171, KB947173, KB947180, KB947180, KB947180, KB94

Error creating control contentplaceholder1 Visual Studio 2010 design mode


After I imported a VS 2008 web project to VS 2010, I can't view aspx pages that have master pages in design mode. The page design mode displays "error creating control - contentplacehoder1 object reference not set to an instance of an object." The project builds and runs fine though. I have only one master page that all other aspx pages reference and I don't have any nested master pages. Can anybody help me with this? Thanks in advance.

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend