VS2005 Beta2 "Preview Data" Window Returns Query Results, but my code does not return results

Hot Topic

[I] keyword modifier: superstatic
Why can't I see all the components from GAC in the "Choose Toolbox Items dialog / .NET Framework components tab" of Visual c# 20
Unable to update the dependencies of the project
Can Tablet PC SDK add wacom support to my app
how long a string can be??
How can I create a working splash screen?
DataSet Encoding
Converting Small endian to Big Endian using C#(long value)
Casting an arraylist as a class
Unhandled error

Visual C#

Ldapconnection (CredentialCache.DefaultCredentials to NetworkCredentials)
Arraylist of Arrays
Performance Counter Question
How to dynamic load ASP.NET User Controls in Visual Studio 2005
VS2005 flickering problem on mouse leave
Problem loading web forms
The IDE often automatically changes the file subtype from "Form" to "Code" in the .csproj file
Shared Memory: Another problem
System.Web.UI namesspace compile time error
Passing array into Constructor

VS2005 Beta2 "Preview Data" Window Returns Query Results, but my code does not return results

I'm stumped...

I'm using the Beta2 of Visual Studio 2005

When I run a query in "Preview Data" by right clicking on the BindingSource or the dataTableAdapter i get results returned from the query, but when I use the following code in a dataGridView, my code (I'm using the same dataTableAdapter, dataSet, DataTable and FillBy method as in the "Preview Data" window) tells me that no records were returned.

dataGridView.DataSource = dataTableAdapter.FillBy(dataSet.DataTable);

Has anyone else had this happen   Any suggestions as to what I am doing wrong

Thanks for you help,

Paul


Answer this question

VS2005 Beta2 "Preview Data" Window Returns Query Results, but my code does not return results

  • Juice Johnson

    Michael:

    Your re-write worked fine.

    Thanks so much for taking the time to catch my mistake Big Smile

    Paul

  • AJMurray

    I'm not sure if I'm following you here, but a quick check tells me that you need to first fill your datatable, then set the datasource of the gridview to the datatable, like this:


    dataTableAdapter.FillBy(dataSet.DataTable);
    dataGridView.DataSource = dataSet.DataTable;

     


    Or you could use the TableAdapter.GetData() method to return a datatable to your datasource.
  • VS2005 Beta2 "Preview Data" Window Returns Query Results, but my code does not return results
Answer this question