.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

Data Sources Tab not showing Data Set

Posted By:      Posted Date: September 19, 2010    Points: 0   Category :WPF

I am using Vb 2008 & Access Databases.

I am getting following Error while viewing Data Sets in data sources window

Object reference not set to an instance of an object.

1.   Hide Call Stack
at Microsoft.VisualStudio.DataTools.Providers.OleDB.OleDBUtilities.GetRegisteredProviders()
at Microsoft.VisualStudio.DataTools.Providers.OleDB.OleDBUtilities.ExpandProvider(String provider)
at Microsoft.VisualStudio.DataTools.Providers.OleDB.OleDBUtilities.GetDataSource(String provider)
at Microsoft.VisualStudio.DataTools.Providers.OleDB.OleDBDataSourceSpecializer.DeriveDataSource(String connectionString)
at Microsoft.VisualStudio.Data.Compatibility.NewSourceSpecializer.DeriveSource(String connectionString)
at Microsoft.VisualStudio.Data.Compatibility.NewProviderObjectFactory.DeriveSource(String connectionString)
at Microsoft.VisualStudio.Data.Package.DataProvider.DeriveSource(String connectionString)
at Microsoft.VSDesigner.Data.ProviderManager.GetVsDataSource(String invariantName, String connectionString, Boolean encrypted)

View Complete Post

More Related Resource Links

Dynamic Data Entities Modal GridViewPager not showing


I am using the ModalEF template, converted to a web application.

The GridViewPager is not showing up, though everything else works fine (filters, updates, etc).

I have tried several things in the last two weeks, to no avail.

Any assistance would be greatly appreciated.

The GridViewPager.ascx.cs Page_Load fires, but the Page_PreRender does not.




<%@ Page Title="" Language="C#" MasterPageFile="~/DefaultMaster.master" AutoEventWireup="True" CodeBehind="ListDetailsModal.aspx.cs" Inherits="DATTWeb.DynamicData.PageTemplates.ListDetailsModal" %>

<%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="ajaxToolKit" %>
<%@ Register Assembly="System.Web.Entity, Version=, Culture=neutral, PublicKeyToken=b77a5c561934e089" Namespace="System.Web.UI.WebControls" tagprefix="asp" %>

<%@ Register src="~/DynamicData/Content/GridViewPager.ascx" tagname="GridViewPager" tagprefix="asp" %>
<%@ Register src="~/DynamicData/Content/FilterUserControl.ascx" tagname="DynamicFilter" tagprefix="asp" %>

<asp:Content ID="Content2&quo

How do you create an association between two different data sources in BDC web parts?



I have a SQL Server database with the customer details and an authenticated web service providing contact details of the selected customer.  How do i connect them using web part connections to retrieve and display the data.

Or is it possible to create a Primary key-Foreign Key relationship between two tables in different databases with a common column?



wss2.0 Infopath 2007 'This form requires connections to data sources when it is loaded. At least on


Hi all

I have a user who receives the error 'This form requires connections to data sources when it is loaded. At least one of these connections is not available. As specified by the form designer, this form will not open' when trying to Submit an infopath form located on a WSS2.0 site.

The user has been having this issue since upgrading to Office 2007 and IE7. I have had the user run an Office Diagnostics but this has not resolved the issue.

I am not aware of any other users experiencing this issue.

Any ideas please?

asp.net VS-2005 Website Data Sources is empty



When I create a rdlc file(Report) the dialog box : "Website Data Sources" is empty, I can add a typed dataset, but the buisness objects (Classes) I created sometime disappear and sometime shown,

When I click/ remove some references it show and hide.

I would really appriciate some help,

thanks in advance,


I followed:


It works fine but after a while, it disappears again.

I tried it on several computers(which means it's not a problem of my machine), and tried it on several projects, all behave the same.


Using the single *.rpt file with multiple data sources


I've created a set of CrystalReports (*.rpt files) for an ASP.NET web app on a development server. I call each report using the following code:

protected void BTN_RunReport_Click(object sender, ImageClickEventArgs e)
CrystalReportViewer_ClientLetter.Visible = true;

ConnectionInfo con = new ConnectionInfo();
con.ServerName = Constants.ServerIP;
con.DatabaseName = Constants.DatabaseName;
con.UserID = Constants.UserID;
con.Password = Constants.Password;

CrystalReportViewer_ClientLetter.ReportSource = Server.MapPath(Constants.ClientLetters);
ParameterFields parameter = CrystalReportViewer_ClientLetter.ParameterFieldInfo;
ParameterField batchdate = new ParameterField();
batchdate.Name = "@BatchDate";
ParameterDiscreteValue batchdate_value = new ParameterDiscreteValue();
batchdate_value.Value = Convert.ToDateTime(txtBatchDate.Text);

foreach (TableLogOnInfo tlf in CrystalReportViewer_ClientLetter.LogOnInfo)
tlf.ConnectionInfo = con;

Custom SSIS Data Flow Component Not Showing in Toolbox or GAC

Hello - I have created a very simple data flow component for SSIS (Actually, I am following this example:  http://www.microsoft.com/downloads/details.aspx?familyid=1C2A7DD2-3EC3-4641-9407-A5A337BEA7D3&displaylang=en).  However, when I register the DLL to the GAC, I am unable to find the assembly in C:\Windows\Assembly - even though the GACUTIL says "Assembly Registered Successfully".  Furthermore, after copying the DLL to the PipelineComponents folder for SSIS (C:\Program Files (x86)\Microsoft SQL Server\100\DTS\PipelineComponents), it does not show in the "Choose Items . . ." dialog box of SSIS.   I am running SQL Server 2008 Dev edition, Visual Studio 2010 with .NET 4.0, and Windows 7 Enterprise 64-bit edition.  Any assistance/thoughts would be appreciated. Thanks!

Report Builder Report manage data sources - relink programmatically

As part of a site definition solution several report builder report rdl files are uploaded to a report folder.  After a site is created with the defintion, the reports must be manually re-linked to the data source through the UI context menu ("Manage Data Sources").  I have been trying to figure out how to do the re-linking programmatically without luck.  Any ideas? ( Reporting Services is configured as integrated with sharepoint)

showing modalpopup and saving data to database simultaneously using ajaxtoolkit and javascript

hi,i have a button ,i want that when i click on that button the data should be saved in the database as well as at the same time a modal popup should display the customerid .i have written the code as <asp:button id="save1" runat="server" onclick="Button4_Click" style=""z-index:" mode="hold" xmlns:asp="#unknown" /> left: 740px; position: absolute; top: 304px" Text="save"/> <asp:panel id="panel" runat="server" xmlns:asp="#unknown">  /asp:Panel> <ajaxtoolkit:modalpopupextender id="MPE" runat="server" targetcontrolid="save1" xmlns:ajaxtoolkit="#unknown"> PopupControlID="panel" DropShadow="true" BackgroundCssClass="modalBackground/> protected void Button4_Click(object sender, EventArgs e) { string id = TextBox1.Text; string name = TextBox2.Text; string cn = "Data Source=hcl;Initial Catalog=mydata;Integrated Security=True"; SqlConnection con = new SqlConnection(cn); SqlCommand cmd = new SqlCommand("insert into customer values (@id,@name)", con); con.Open(); cmd.CommandType = CommandType.Text; cmd.Parameters.Add("@id", id); cmd.Parameters.Add("@name",name); cmd.ExecuteNonQuery(); con.Close(); CUSTID.Text = id.ToString(); MPE.Show(); }

Report with two data sources

Hello, I have two data sources: an Oracle table and a SSAS cube. I need to make a report with some information from the table and some from the cube. Example:   Oracle table ID, Comment SSAS ID, Value, Description Report ID (the join key); Value; Description; Comment.   Is it possible to do that? Many thanks  

Parallel Groupings are not showing the data in Reporting Service 2008.

Hi All, My main goal is to show rows under two adjecent groups (say A another one is B) which have one parent group lat call it as AB (all are row sections) and i have one column group for "months".The details inside the group A under the "months" group is not showing any values or expressions it returing me blank. Adjacent groups in SSRS 2008 still shows blank lines for invisible rows (why?). Any ideas.Please let me know. Veeren.

What are my options when I need to create a report with data from multiple sources?

Hello all,  What are my options when I want to create a report that will get records from multiple data sources based on data from a parameter? The user will enter the customer ID, I have to check that ID against 5 different data sources. Have you guys done anything similar? Should I leverage SSIS on this request, adding an extra layer of complexity? Should I do this all from SSRS? What are my options?

model report from two different data sources SQL server and access DB

Can we merge two model reports into one . One model report is from SQL server and another one from Access DB. How is that possible. Can you please give a idea how to do that. I need to display data from sql server as well as access DB using model report.  I need to get data from two different sources like sql and oracle or SQL and access db. So can combine tables from these data sources into the DSV or model. I need to use it in a report   Thanks Madhavi

External Lists and Infopath forms issue with Secondary Data Sources

I've followed this tutorial for creating and customising forms for external data (http://blogs.msdn.com/infopath/archive/2010/03/11/customize-an-external-list-form-in-infopath-2010.aspx).  The only difference being that my seconday data source is not an XML file (I've tried database connection and existing sharepoint lists both internal and external) When running the design checker I get the message "Additional Data connections not supported" and my form won't publish.  Any ideas?

ReportViewer Not showing all data from table

Hello all,I am new to the forum and have done a search but can't seem to find anyone who has the same problem I do.  I am using ReportViewer with Visual Web Developer Express, I am doing a very simple query which should return two rows in the report.  Testing the query using query builder does return the two rows, but when I build and run the report it only shows the one row.  Hide duplicates is not turned on.  I can create a gridview not using the reportviewer and both rows appear after the build and run.The query:SELECT     defect_seq, ticket_numFROM         def2ticWHERE     (defect_seq = 15190002)ORDER BY defect_seqThis will return two rows when it is run against the database...Any ideas?  I have been killing myself trying different options..  Is there something built in to not show duplicates?  Am I enetering the fields wrong in the matrix?Also is there any good documentation on the ReportViewer for Visual Web express, besides the walkthrough?Thanks!!!!John

while changingMode page_load data not showing....

Hi... i am having insertpage.aspx where i am fetching systemdate but when i am changingMode in for data Insert, systemdate not showing that time and same as EditMode also. I am sending codebehind code .....please help me out..... /*********************************************************/ using System; using System.Collections; using System.Configuration; using System.Data; using System.Linq; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.HtmlControls; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Xml.Linq; using VehicleApp.library; public partial class InsertPage : System.Web.UI.Page {     library lib = new library();     protected void Page_Load(object sender, EventArgs e)     {         if (!IsPostBack)         {             BindFormView();             Label mydate = (Label)VehicleFormView.Row.FindControl("dateLabel");             mydate.Text = DateTime.Now.Date.ToShortDateString();         }     }     private void BindFormView()     {         if (Session["strTemp"] != null)  &nb

Adding a column from another List to a Dataview? Must I link sources or can I just add a new data so

Using Designer, I added a dataview to a webpart page and dragged in a single list source. It works as expected. I now want a column from another list in my view. Must I link in another datasource, or can i just insert the data source for the second list into my datasources? The new datasource is there in the code and I see the caml select for it. but my XSL still does not find data: <xsl:value-of select="/dsQueryResponse/Master/Rows/Row[@ID = current()/@Key]/@Lastname" /> I noticed my new columns are not in the <datafields> tag, I tried adding them but it did not help. If Master is my lookup list , @Key is the dataview I will match with and @ID is the column in Master, and @Lastname column I want to return, is the above syntax correct? Many Thanks.    

report generate vwd 2008 - website data sources window empty

I need to create report in asp.net web application, I'm working on vwd 2008 express, installed report add-on i have create dataset file xxx.xsd and use storder procedure for data adapter. when I am trying to add columns into report body I cannot see dataset in website data sources window. when i right click on window it just show refresh option. how can I get my data set into window. and add columns in to report? please help... 
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