.NET Framework - QueriesTableAdapter

Asked By peterg1234 on 02-Mar-08 10:27 PM
Newbie question:

I have created a custom query using the Query Builder, and it shows up
as a QueriesTableAdapter entry in the .xsd file. Now, how do I make
the results of this query available to a grid object on my form? IOW,
how do I make it a data source?


TIA




Cor Ligthert[MVP] replied on 03-Mar-08 12:36 AM
Peter-

Set the XSD file in DataSet mode on your designer(left bellow)
right click and tell to generate a dataset

-Cor
peterg1234 replied on 05-Mar-08 05:13 AM
I don't mean to sound stupid, but could you clarify the steps I need
to take. Right now, I am looking at a dataset.xsd file which has a
QueriesTableAdapter object containing my SQL -- qryIssuesList().

How do I set the xsd file into dataset mode? How do I tell it to
generate a dataset?

TIA,
Pete



On Mar 2, 9:36 pm, "Cor Ligthert[MVP]" <notmyfirstn...@planet.nl>
Rich P replied on 03-Mar-08 04:40 PM
Using the wizards will restrict your objects considerably.  You are
better off doing this in code as follows (I am using Windows
Authentication in this sample if you are using Sql Server):

--------------------------------------------
Imports System
Imports System.Data.SqlClient

Dim conn As SqlConnection, da As SqlDataAdapter
Dim ds As Dataset

Private Sub Form1_Load(...) Handles MyBase.Load
conn1 = New SqlConnection
conn1.ConnectionString = "Data Source=yourSvr;Initial
Catalog=yourDB;Integrated Security=True"

ds = New Dataset
da = New SqlDataAdapter
da.SelectCommand = New SqlCommand
da.SelectCommand.Connection = conn
da.SelectCommand = "Select * From yourTbl"
da.Fill(ds, "tblSteve")

datagridview1.DataSource = ds.Tables("tblSteve")
End Sub
----------------------------------------------

Just create a new form and drop a datagridview control on it.  Then copy
and paste the code above into your new form.  Replace yourTbl with the
name of an actual table on your server DB.  Now load the project and you
will see the data in your form's datagridview control.

Rich

*** Sent via Developersdex http://www.developersdex.com ***
peterg1234 replied on 03-Mar-08 06:56 PM
Thanks Rich - that is what I was looking for.
Cor Ligthert[MVP] replied on 03-Mar-08 11:50 PM
Rich,

This is a complete different result then using the designer.

Be aware that you are now using a non strongly typed dataset, which is in
fact complete different (less stable) then a strongly typed dataset created
using an XSD file.

Cor
Cor Ligthert[MVP] replied on 03-Mar-08 11:53 PM
Pete-

I don't mean to sound stupid, but could you clarify the result you want to
get.
Right now, I am looking at a solution for a non strongly typed dataset which
does not have a
QueriesTableAdapter object containing your SQL -- qryIssuesList().

What has this to do with a xsd file into?

TIA,
Cor