DataSource/DataBind

[ThunderMusic]

Hi,
This question probably went back a couple of times, but I didn't find
anything about it on google, so I ask here...

What is the best way to use the DataSource/DataBind pattern in a class? I
would like the user to be able to set a data source and I'd like my class to
be able to use this datasource to build a DataTable I could use for further
processing...

Can it be done? if it can, how?

Thanks

ThunderMusic

[Cor Ligthert [MVP]]

Thundermusic,

What has that class to do?

Cor

"ThunderMus ic" <NO.danlat.at.h otmail.com.SPAM schreef in bericht
news:eU******** ******@TK2MSFTN GP03.phx.gbl...

Hi,
This question probably went back a couple of times, but I didn't find
anything about it on google, so I ask here...

What is the best way to use the DataSource/DataBind pattern in a class? I
would like the user to be able to set a data source and I'd like my class
to be able to use this datasource to build a DataTable I could use for
further processing...

Can it be done? if it can, how?

Thanks

ThunderMusic

[ThunderMusic]

I don't really understand what the purpose of the processing has to do with
how to set a datasource and converting it to a DataTable, but I don't mind
giving a little spoiler on what I'm doing (nobody won't know the overall of
the project just by this tiny bit anyway)

I must itterate in the rows and find some columns (colums names provided by
the user in a property of the object) and display the values of these
columns in graphs and charts...

I know that most bindable controls can receive Arrays, List, SortedList,
Dictionaries, DataTable, DataView, DataSet, et al. All thos controls don't
behave the same at all when it comes to retrieve the data, so I don't want
my objects to always try to find which object I'm working with... If
there's an easy way of doing it, I wanna know... I just don't want to do if
(datasource is DataSet) DoSomething; if (datasource is somethingelse)
DoSomethingElse ; and so on... If I can't do without it, I'll do it, but if I
can do without, I'd prefer to do without... ;) and preferably I don't want
to inherit from DataBoundContro l because I'm not developing a control yet...
the Data-Bound object is only a class that will be used in many of my
controls...

Thanks

ThunderMusic

"Cor Ligthert [MVP]" <no************ @planet.nla écrit dans le message de
news: OR************* *@TK2MSFTNGP06. phx.gbl...

Thundermusic,

What has that class to do?

Cor

"ThunderMus ic" <NO.danlat.at.h otmail.com.SPAM schreef in bericht
news:eU******** ******@TK2MSFTN GP03.phx.gbl...

>Hi,
This question probably went back a couple of times, but I didn't find
anything about it on google, so I ask here...

What is the best way to use the DataSource/DataBind pattern in a class? I
would like the user to be able to set a data source and I'd like my class
to be able to use this datasource to build a DataTable I could use for
further processing...

Can it be done? if it can, how?

Thanks

ThunderMusic

[Cor Ligthert [MVP]]

Thundermusic,

In my idea are there only very few controls in WindowForms that can use the
datasource.

That are the ListControls, the DataGrid and the DataGridView
(complex datacontrols)

And that distinct them from the other controls which all can all however
only be binded using the DataBind.

Cor
"ThunderMus ic" <NO.danlat.at.h otmail.com.SPAM schreef in bericht
news:Oy******** ******@TK2MSFTN GP04.phx.gbl...

>I don't really understand what the purpose of the processing has to do with
how to set a datasource and converting it to a DataTable, but I don't mind
giving a little spoiler on what I'm doing (nobody won't know the overall of
the project just by this tiny bit anyway)

I must itterate in the rows and find some columns (colums names provided
by the user in a property of the object) and display the values of these
columns in graphs and charts...

I know that most bindable controls can receive Arrays, List, SortedList,
Dictionaries, DataTable, DataView, DataSet, et al. All thos controls don't
behave the same at all when it comes to retrieve the data, so I don't want
my objects to always try to find which object I'm working with... If
there's an easy way of doing it, I wanna know... I just don't want to do
if (datasource is DataSet) DoSomething; if (datasource is somethingelse)
DoSomethingElse ; and so on... If I can't do without it, I'll do it, but if
I can do without, I'd prefer to do without... ;) and preferably I don't
want to inherit from DataBoundContro l because I'm not developing a control
yet... the Data-Bound object is only a class that will be used in many of
my controls...

Thanks

ThunderMusic

"Cor Ligthert [MVP]" <no************ @planet.nla écrit dans le message de
news: OR************* *@TK2MSFTNGP06. phx.gbl...

>Thundermusic ,

What has that class to do?

Cor

"ThunderMusi c" <NO.danlat.at.h otmail.com.SPAM schreef in bericht
news:eU******* *******@TK2MSFT NGP03.phx.gbl.. .

>>Hi,
This question probably went back a couple of times, but I didn't find
anything about it on google, so I ask here...

What is the best way to use the DataSource/DataBind pattern in a class?
I would like the user to be able to set a data source and I'd like my
class to be able to use this datasource to build a DataTable I could use
for further processing...

Can it be done? if it can, how?

Thanks

ThunderMusi c

[Miro]

Thunder,

I did something similar along what your looking for - ( I think. )

I have created a Class that has a couple properties:
Private DBName As String
Private TableName As String
Private FieldName As String
Private FieldType As String
Private FieldLength As Integer

and to make a long story short it allows me to call a sub that adds this
into an array of the class.
Setup_AddFields (DBFileName, "VersionTab le", "VersionFie ld", "StringType ", 4)

I then have another sub that loops thru the array and creates the dbfile
name if it doesnt exist,
then it creates the table if it doesnt exist, and then it adds the field,
with the type and length.

Is that something that you are looking for ?

M.


"Cor Ligthert [MVP]" <no************ @planet.nlwrote in message
news:%2******** ********@TK2MSF TNGP06.phx.gbl. ..

Thundermusic,

In my idea are there only very few controls in WindowForms that can use
the datasource.

That are the ListControls, the DataGrid and the DataGridView
(complex datacontrols)

And that distinct them from the other controls which all can all however
only be binded using the DataBind.

Cor
"ThunderMus ic" <NO.danlat.at.h otmail.com.SPAM schreef in bericht
news:Oy******** ******@TK2MSFTN GP04.phx.gbl...

>>I don't really understand what the purpose of the processing has to do
with how to set a datasource and converting it to a DataTable, but I don't
mind giving a little spoiler on what I'm doing (nobody won't know the
overall of the project just by this tiny bit anyway)

I must itterate in the rows and find some columns (colums names provided
by the user in a property of the object) and display the values of these
columns in graphs and charts...

I know that most bindable controls can receive Arrays, List, SortedList,
Dictionaries , DataTable, DataView, DataSet, et al. All thos controls
don't behave the same at all when it comes to retrieve the data, so I
don't want my objects to always try to find which object I'm working
with... If there's an easy way of doing it, I wanna know... I just don't
want to do if (datasource is DataSet) DoSomething; if (datasource is
somethingels e) DoSomethingElse ; and so on... If I can't do without it,
I'll do it, but if I can do without, I'd prefer to do without... ;) and
preferably I don't want to inherit from DataBoundContro l because I'm not
developing a control yet... the Data-Bound object is only a class that
will be used in many of my controls...

Thanks

ThunderMusic

"Cor Ligthert [MVP]" <no************ @planet.nla écrit dans le message
de news: OR************* *@TK2MSFTNGP06. phx.gbl...

>>Thundermusi c,

What has that class to do?

Cor

"ThunderMusic " <NO.danlat.at.h otmail.com.SPAM schreef in bericht
news:eU****** ********@TK2MSF TNGP03.phx.gbl. ..
Hi,
This question probably went back a couple of times, but I didn't find
anything about it on google, so I ask here...

What is the best way to use the DataSource/DataBind pattern in a class?
I would like the user to be able to set a data source and I'd like my
class to be able to use this datasource to build a DataTable I could
use for further processing...

Can it be done? if it can, how?

Thanks

ThunderMus ic

[ThunderMusic]

ok, but this DataBind(), what does it do under the hood? I mean, must it
convert the object datasource into whatever it is in reality? (IEnumerable,
IList, et al.)

thanks

ThunderMusic

"Cor Ligthert [MVP]" <no************ @planet.nla écrit dans le message de
news: %2************* ***@TK2MSFTNGP0 6.phx.gbl...

Thundermusic,

In my idea are there only very few controls in WindowForms that can use
the datasource.

That are the ListControls, the DataGrid and the DataGridView
(complex datacontrols)

And that distinct them from the other controls which all can all however
only be binded using the DataBind.

Cor
"ThunderMus ic" <NO.danlat.at.h otmail.com.SPAM schreef in bericht
news:Oy******** ******@TK2MSFTN GP04.phx.gbl...

>>I don't really understand what the purpose of the processing has to do
with how to set a datasource and converting it to a DataTable, but I don't
mind giving a little spoiler on what I'm doing (nobody won't know the
overall of the project just by this tiny bit anyway)

I must itterate in the rows and find some columns (colums names provided
by the user in a property of the object) and display the values of these
columns in graphs and charts...

I know that most bindable controls can receive Arrays, List, SortedList,
Dictionaries , DataTable, DataView, DataSet, et al. All thos controls
don't behave the same at all when it comes to retrieve the data, so I
don't want my objects to always try to find which object I'm working
with... If there's an easy way of doing it, I wanna know... I just don't
want to do if (datasource is DataSet) DoSomething; if (datasource is
somethingels e) DoSomethingElse ; and so on... If I can't do without it,
I'll do it, but if I can do without, I'd prefer to do without... ;) and
preferably I don't want to inherit from DataBoundContro l because I'm not
developing a control yet... the Data-Bound object is only a class that
will be used in many of my controls...

Thanks

ThunderMusic

"Cor Ligthert [MVP]" <no************ @planet.nla écrit dans le message
de news: OR************* *@TK2MSFTNGP06. phx.gbl...

>>Thundermusi c,

What has that class to do?

Cor

"ThunderMusic " <NO.danlat.at.h otmail.com.SPAM schreef in bericht
news:eU****** ********@TK2MSF TNGP03.phx.gbl. ..
Hi,
This question probably went back a couple of times, but I didn't find
anything about it on google, so I ask here...

What is the best way to use the DataSource/DataBind pattern in a class?
I would like the user to be able to set a data source and I'd like my
class to be able to use this datasource to build a DataTable I could
use for further processing...

Can it be done? if it can, how?

Thanks

ThunderMus ic

[Cor Ligthert [MVP]]

Thundermusic,

Is it this you are after?

http://msdn.microsoft.com/library/de...classtopic.asp

I hope this helps,

Cor

"ThunderMus ic" <NO.danlat.at.h otmail.com.SPAM schreef in bericht
news:eG******** ******@TK2MSFTN GP02.phx.gbl...

ok, but this DataBind(), what does it do under the hood? I mean, must it
convert the object datasource into whatever it is in reality?
(IEnumerable, IList, et al.)

thanks

ThunderMusic

"Cor Ligthert [MVP]" <no************ @planet.nla écrit dans le message de
news: %2************* ***@TK2MSFTNGP0 6.phx.gbl...

>Thundermusic ,

In my idea are there only very few controls in WindowForms that can use
the datasource.

That are the ListControls, the DataGrid and the DataGridView
(complex datacontrols)

And that distinct them from the other controls which all can all however
only be binded using the DataBind.

Cor
"ThunderMusi c" <NO.danlat.at.h otmail.com.SPAM schreef in bericht
news:Oy******* *******@TK2MSFT NGP04.phx.gbl.. .

>>>I don't really understand what the purpose of the processing has to do
with how to set a datasource and converting it to a DataTable, but I
don't mind giving a little spoiler on what I'm doing (nobody won't know
the overall of the project just by this tiny bit anyway)

I must itterate in the rows and find some columns (colums names provided
by the user in a property of the object) and display the values of these
columns in graphs and charts...

I know that most bindable controls can receive Arrays, List, SortedList,
Dictionarie s, DataTable, DataView, DataSet, et al. All thos controls
don't behave the same at all when it comes to retrieve the data, so I
don't want my objects to always try to find which object I'm working
with... If there's an easy way of doing it, I wanna know... I just
don't want to do if (datasource is DataSet) DoSomething; if (datasource
is somethingelse) DoSomethingElse ; and so on... If I can't do without
it, I'll do it, but if I can do without, I'd prefer to do without... ;)
and preferably I don't want to inherit from DataBoundContro l because I'm
not developing a control yet... the Data-Bound object is only a class
that will be used in many of my controls...

Thanks

ThunderMusi c

"Cor Ligthert [MVP]" <no************ @planet.nla écrit dans le message
de news: OR************* *@TK2MSFTNGP06. phx.gbl...
Thundermusic ,

What has that class to do?

Cor

"ThunderMusi c" <NO.danlat.at.h otmail.com.SPAM schreef in bericht
news:eU***** *********@TK2MS FTNGP03.phx.gbl ...
Hi,
This question probably went back a couple of times, but I didn't find
anything about it on google, so I ask here...
>
What is the best way to use the DataSource/DataBind pattern in a
class? I would like the user to be able to set a data source and I'd
like my class to be able to use this datasource to build a DataTable I
could use for further processing...
>
Can it be done? if it can, how?
>
Thanks
>
ThunderMusi c
>

[ThunderMusic]

I dont really see how it can help me, but I'll try to find out...

thanks a lot for your help...

ThunderMusic

"Cor Ligthert [MVP]" <no************ @planet.nla écrit dans le message de
news: e$************* ***@TK2MSFTNGP0 3.phx.gbl...

Thundermusic,

Is it this you are after?

http://msdn.microsoft.com/library/de...classtopic.asp

I hope this helps,

Cor

"ThunderMus ic" <NO.danlat.at.h otmail.com.SPAM schreef in bericht
news:eG******** ******@TK2MSFTN GP02.phx.gbl...

>ok, but this DataBind(), what does it do under the hood? I mean, must it
convert the object datasource into whatever it is in reality?
(IEnumerable , IList, et al.)

thanks

ThunderMusic

"Cor Ligthert [MVP]" <no************ @planet.nla écrit dans le message
de news: %2************* ***@TK2MSFTNGP0 6.phx.gbl...

>>Thundermusi c,

In my idea are there only very few controls in WindowForms that can use
the datasource.

That are the ListControls, the DataGrid and the DataGridView
(complex datacontrols)

And that distinct them from the other controls which all can all however
only be binded using the DataBind.

Cor
"ThunderMusic " <NO.danlat.at.h otmail.com.SPAM schreef in bericht
news:Oy****** ********@TK2MSF TNGP04.phx.gbl. ..
I don't really understand what the purpose of the processing has to do
with how to set a datasource and converting it to a DataTable, but I
don't mind giving a little spoiler on what I'm doing (nobody won't know
the overall of the project just by this tiny bit anyway)

I must itterate in the rows and find some columns (colums names
provided by the user in a property of the object) and display the
values of these columns in graphs and charts...

I know that most bindable controls can receive Arrays, List,
SortedList , Dictionaries, DataTable, DataView, DataSet, et al. All thos
controls don't behave the same at all when it comes to retrieve the
data, so I don't want my objects to always try to find which object I'm
working with... If there's an easy way of doing it, I wanna know... I
just don't want to do if (datasource is DataSet) DoSomething; if
(datasourc e is somethingelse) DoSomethingElse ; and so on... If I can't
do without it, I'll do it, but if I can do without, I'd prefer to do
without... ;) and preferably I don't want to inherit from
DataBoundCon trol because I'm not developing a control yet... the
Data-Bound object is only a class that will be used in many of my
controls.. .

Thanks

ThunderMus ic

"Cor Ligthert [MVP]" <no************ @planet.nla écrit dans le message
de news: OR************* *@TK2MSFTNGP06. phx.gbl...
Thundermusi c,
>
What has that class to do?
>
Cor
>
"ThunderMus ic" <NO.danlat.at.h otmail.com.SPAM schreef in bericht
news:eU**** **********@TK2M SFTNGP03.phx.gb l...
>Hi,
>This question probably went back a couple of times, but I didn't find
>anything about it on google, so I ask here...
>>
>What is the best way to use the DataSource/DataBind pattern in a
>class? I would like the user to be able to set a data source and I'd
>like my class to be able to use this datasource to build a DataTable
>I could use for further processing...
>>
>Can it be done? if it can, how?
>>
>Thanks
>>
>ThunderMus ic
>>
>
>