«

Hi. I'm rather new to vs.net so explaining things in detail would be
of great help to me. I'm working on a WebForms Project.

Basically I have a datagrid I need to populate. I have it set up so
that it will connect to my database (did not use the wizard btw) and
I can make it display things. However I've run into a problem.

I have 8 columns I need to populate but each one is from a different
table. The auto populate at runtime does not do what I need it to do.
Given any 8 tables (table1 through table located in Database1, how
would I set up my 8 columns and populate each one from a different
table? In addition, how would I populate them with conditions, i.e.
fill this table with values only when in the january through june
months.

Thank you.


Posted Via Usenet.com Premium Usenet Newsgroup Services
----------------------------------------------------------
** SPEED ** RETENTION ** COMPLETION ** ANONYMITY **
----------------------------------------------------------
http://www.usenet.com

Your query needs to have a join between all tables involved and select the
appropriate column from each table. This is really more of a SQL issue,
then anything to do with .NET.

"strongmace" <> wrote in message
news:40eab143$...
> Hi. I'm rather new to vs.net so explaining things in detail would be
> of great help to me. I'm working on a WebForms Project.
>
> Basically I have a datagrid I need to populate. I have it set up so
> that it will connect to my database (did not use the wizard btw) and
> I can make it display things. However I've run into a problem.
>
> I have 8 columns I need to populate but each one is from a different
> table. The auto populate at runtime does not do what I need it to do.
> Given any 8 tables (table1 through table located in Database1, how
> would I set up my 8 columns and populate each one from a different
> table? In addition, how would I populate them with conditions, i.e.
> fill this table with values only when in the january through june
> months.
>
> Thank you.
>
>
> Posted Via Usenet.com Premium Usenet Newsgroup Services
> ----------------------------------------------------------
> ** SPEED ** RETENTION ** COMPLETION ** ANONYMITY **
> ----------------------------------------------------------
> http://www.usenet.com

If I remember right though, a join requires that the tables have some
sort of matching element. These tables have nothing in common and I
cannot edit them or reorganize them so that they do, which is dont
think a join would work (although I could be wrong). Is there some
way to set up a column manually and linke it directly to a specific
table?


Posted Via Usenet.com Premium Usenet Newsgroup Services
----------------------------------------------------------
** SPEED ** RETENTION ** COMPLETION ** ANONYMITY **
----------------------------------------------------------
http://www.usenet.com