|
-
Mar 11th, 2003, 10:22 AM
#1
Thread Starter
Addicted Member
How to append fields values and fill Datagrid? [RESOLVED]
I've been requested to show in a VB.net Datagrid both "month" and "year" fields in the DB as only "Date" in the Datagrid.
Example:
Now in the DataBase:
Fields:|Month|Year|
Row: 12 |2002
Row: 11 |2001
Should be in Datagrid:
Fields: |Date |
Row: 12/2002
Row: 11/2001
etc.
Here's my big problem:
I also need to put in the datagrid more fields from different tables, wich means that I can't use the DataGridTableStyle and use the MappingName property, since it would only accept from one table (I may be wrong, of course ). So after I append the month and year into one field, I'm going to add the field "Account" from table "Accounts", wich is different than the "Month" and "Year" fields, since they are from the table "Maps".
I also thought about making the append process in an SQL Query, but my SQL knowledge is quite limited. But I'd like to know your oppinion, and if this is the best process I'd like to know how to call it into my Datagrid.
Thank you for every help you can give me. I really need it.
Last edited by Zealot; Mar 19th, 2003 at 05:50 AM.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|