Hello.
Is there any container on VB.NET 2008, so I can drop queries & tables
objects on it?

Thanks

Try a Dataset. You can select it from the Add menu under "Dataset"
(.xsd file) or create it in code

Dim ds As New Dataset

Rich

*** Sent via Developersdex http://www.developersdex.com ***

Can I drop mySqlConnection or other connection objects to such a container,
or similar ?

Thanks

"Rich P" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Try a Dataset. You can select it from the Add menu under "Dataset"
> (.xsd file) or create it in code
>
> Dim ds As New Dataset
>
> Rich
>
> *** Sent via Developersdex http://www.developersdex.com ***

I you select a Dataset (.xsd) from the Add menu, then in the Server
Explorer (View menu) you can connect to whichever database and drag a
table or tables into the Dataset window. I think another option to
right-click in the Dataset window and select Add TableDataAdapter which
will bring up a wizard that you can click through.

Rich

*** Sent via Developersdex http://www.developersdex.com ***

What I see is only few components I can drop on dataset.
TableAdapter, Query, DataTable, Relation.
I didn't see a way dropping connection.
(The specified connection is : mySqlConnection).

I want to drop the connection on design time.
Can I see more elements than the above four.

Thanks

"Rich P" <(E-Mail Removed)> wrote in message
news:#(E-Mail Removed)...
> I you select a Dataset (.xsd) from the Add menu, then in the Server
> Explorer (View menu) you can connect to whichever database and drag a
> table or tables into the Dataset window. I think another option to
> right-click in the Dataset window and select Add TableDataAdapter which
> will bring up a wizard that you can click through.
>
> Rich
>
> *** Sent via Developersdex http://www.developersdex.com ***

Am 31.03.2010 10:54, schrieb Mr. X.:
> What I see is only few components I can drop on dataset.
> TableAdapter, Query, DataTable, Relation.
> I didn't see a way dropping connection.
> (The specified connection is : mySqlConnection).
>
> I want to drop the connection on design time.
> Can I see more elements than the above four.

You could drop several things on a Form - but what are you trying to do?


--
Armin

I want to drop elements on a dataset.
As far as I remember, Delphi IDE, i.e , has dataset, which I can drop also a
connections on it.
I don't understand why connections and other elements cannot be dropped to
dataset
(Or should I declare the connection somehow on the toolbox).

Thanks

"Armin Zingler" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Am 31.03.2010 10:54, schrieb Mr. X.:
>> What I see is only few components I can drop on dataset.
>> TableAdapter, Query, DataTable, Relation.
>> I didn't see a way dropping connection.
>> (The specified connection is : mySqlConnection).
>>
>> I want to drop the connection on design time.
>> Can I see more elements than the above four.
>
> You could drop several things on a Form - but what are you trying to do?
>
>
> --
> Armin

Am 31.03.2010 18:21, schrieb Mr. X.:
> I want to drop elements on a dataset.
> As far as I remember, Delphi IDE, i.e , has dataset, which I can drop also a
> connections on it.
> I don't understand why connections and other elements cannot be dropped to
> dataset
> (Or should I declare the connection somehow on the toolbox).

Connections are not part of a DataSet. A Dataset is a container for
DataTables (containing datarows) and DataRelations.

Documentation on Datasets:
http://msdn.microsoft.com/en-us/library/ss7fbaez.aspx

--
Armin

(Now I see that your email is nospam too).

I see that on windows-form I can drop mySqlConnection object (under
toolbox -> dataset -> mySqlConnection).
Other objects are not seen on toolbox -> dataset, when windows-form is
active.
On dataset - the other objects I have mentioned are visible (except
mySqlConnection).

It is no obvious, since I want a visual tool that is dedicated to databases.

Is there any other visual tool I can drop mySqlConnection.
If not - where it is preferred to be dropped to.

Thanks

"Armin Zingler" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Am 31.03.2010 18:21, schrieb Mr. X.:
>> I want to drop elements on a dataset.
>> As far as I remember, Delphi IDE, i.e , has dataset, which I can drop
>> also a
>> connections on it.
>> I don't understand why connections and other elements cannot be dropped
>> to
>> dataset
>> (Or should I declare the connection somehow on the toolbox).
>
> Connections are not part of a DataSet. A Dataset is a container for
> DataTables (containing datarows) and DataRelations.
>
> Documentation on Datasets:
> http://msdn.microsoft.com/en-us/library/ss7fbaez.aspx
>
> --
> Armin

When I put on the dataset a query - It should be referred to a connection,
and it is build with a wizard.
But what if I want to refer to an existing connection object (the connection
is known before using the query on the dataset), or know what is behind the
query and resolve the connection object from it ?

Thanks

"Mr. X." <nospam@nospam_please.com> wrote in message
news:#(E-Mail Removed)...
> (Now I see that your email is nospam too).
>
> I see that on windows-form I can drop mySqlConnection object (under
> toolbox -> dataset -> mySqlConnection).
> Other objects are not seen on toolbox -> dataset, when windows-form is
> active.
> On dataset - the other objects I have mentioned are visible (except
> mySqlConnection).
>
> It is no obvious, since I want a visual tool that is dedicated to
> databases.
>
> Is there any other visual tool I can drop mySqlConnection.
> If not - where it is preferred to be dropped to.
>
> Thanks
>
> "Armin Zingler" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> Am 31.03.2010 18:21, schrieb Mr. X.:
>>> I want to drop elements on a dataset.
>>> As far as I remember, Delphi IDE, i.e , has dataset, which I can drop
>>> also a
>>> connections on it.
>>> I don't understand why connections and other elements cannot be dropped
>>> to
>>> dataset
>>> (Or should I declare the connection somehow on the toolbox).
>>
>> Connections are not part of a DataSet. A Dataset is a container for
>> DataTables (containing datarows) and DataRelations.
>>
>> Documentation on Datasets:
>> http://msdn.microsoft.com/en-us/library/ss7fbaez.aspx
>>
>> --
>> Armin
>