Click here to Skip to main content
15,915,702 members
Home / Discussions / Visual Basic
   

Visual Basic

 
Generalusing tcpclint Pin
Agbaria Ahmad25-Jan-08 12:15
Agbaria Ahmad25-Jan-08 12:15 
Questioneffective designing Pin
Agbaria Ahmad25-Jan-08 11:54
Agbaria Ahmad25-Jan-08 11:54 
GeneralRe: effective designing Pin
Christian Graus25-Jan-08 12:41
protectorChristian Graus25-Jan-08 12:41 
GeneralRe: effective designing Pin
darkelv26-Jan-08 2:55
darkelv26-Jan-08 2:55 
QuestionWindows Installer CustomActionData parameters Pin
mrgubbels25-Jan-08 11:43
mrgubbels25-Jan-08 11:43 
GeneralDisplaying Rows from a DataTable in a DataGrid Pin
AAGTHosting25-Jan-08 7:35
AAGTHosting25-Jan-08 7:35 
GeneralRe: Displaying Rows from a DataTable in a DataGrid Pin
Kschuler25-Jan-08 8:11
Kschuler25-Jan-08 8:11 
GeneralRe: Displaying Rows from a DataTable in a DataGrid Pin
AAGTHosting25-Jan-08 10:05
AAGTHosting25-Jan-08 10:05 
I am creating a datagrid view from multiple database tables. This is how the dataGrid would be laid out. This same layout would exist for each day of the week that this teacher has a schedule.

Under the Monday column the names come from the students database table. The number of weeks comes from the student payments table. This shows how many weeks the student paid for this month. The note in the notes column comes from the the student payments table if the student had paid. If there is a cancelation or some other problem with the lesson that week then the note comes from the lesson status table. The blank row is a time that the teacher is available, but the time slot is empty.

The x's are times that the teacher is not available

Time | Monday | weeks | notes
12:00|john doe| --4-- | -pd- |
12:30|mary doe| --5-- | -pd- |
1:00-|buck doe| --4-- | ns+c |
1:30-|----x---|---x---|--x---|
2:00-|--------|-------|------|

I am using a tableAdapter for each database table but am used to using joins with php.

I have multiple questions.

1) would it be better for me to just do my own query with a join so that I don't have to use all these tableAdapters?

2) Or would it better for me to create a View in the database and query the view.

3) My original question was how do I assure that each day such as Monday, Tuesday, etc that the teacher has a schedule shows up as a column. Keep in mind that I can't simply show what is in one database table as you have shown above.

This is the line of code that I am not sure how it works. Will it increment through the database table rows and for each column that should have a day of the week displayed in it dispay that day of the week.

Here is the line of code.

lpDataSet.Tables(0).Columns.Add(New DataColumn("lpDataSet.tbl_teach_sched.ts_dayColumn", GetType(String)))

This is the code that pupulates that column with a row from the database such as Monday or Tuesday.

lpDataSet.tbl_teach_sched.ts_dayColumn

Keep in mind that when you query this database table for this column it would look like this. The following example is for a teacher that works on monday, Tuesday, Wednesday and Friday.

ts_id | ts_day | teach_id
| |
1 | Monday | 100
2 | Tuesday | 100
3 | Wednesday | 100
4 | Friday | 100
GeneralRe: Displaying Rows from a DataTable in a DataGrid Pin
Kschuler25-Jan-08 11:07
Kschuler25-Jan-08 11:07 
GeneralRe: Displaying Rows from a DataTable in a DataGrid Pin
AAGTHosting25-Jan-08 14:08
AAGTHosting25-Jan-08 14:08 
GeneralRe: Displaying Rows from a DataTable in a DataGrid Pin
Kschuler28-Jan-08 3:25
Kschuler28-Jan-08 3:25 
GeneralDoes any one know what i have done wrong Pin
solarthur0125-Jan-08 6:04
solarthur0125-Jan-08 6:04 
GeneralRe: Does any one know what i have done wrong Pin
Paul Conrad25-Jan-08 7:24
professionalPaul Conrad25-Jan-08 7:24 
GeneralRe: Does any one know what i have done wrong Pin
solarthur0125-Jan-08 7:45
solarthur0125-Jan-08 7:45 
GeneralRe: Does any one know what i have done wrong Pin
Paul Conrad25-Jan-08 7:48
professionalPaul Conrad25-Jan-08 7:48 
GeneralRe: Does any one know what i have done wrong Pin
solarthur0125-Jan-08 7:50
solarthur0125-Jan-08 7:50 
GeneralRe: Does any one know what i have done wrong Pin
Christian Graus25-Jan-08 12:42
protectorChristian Graus25-Jan-08 12:42 
QuestionHow to read text present on a image Pin
harivinod25-Jan-08 2:39
harivinod25-Jan-08 2:39 
AnswerRe: How to read text present on a image Pin
Justin Perez25-Jan-08 3:02
Justin Perez25-Jan-08 3:02 
AnswerRe: How to read text present on a image Pin
Paul Conrad25-Jan-08 3:48
professionalPaul Conrad25-Jan-08 3:48 
AnswerRe: How to read text present on a image Pin
Steven J Jowett25-Jan-08 5:45
Steven J Jowett25-Jan-08 5:45 
AnswerRe: How to read text present on a image Pin
eyes200729-Jan-08 19:28
eyes200729-Jan-08 19:28 
QuestionHow to get file name from openfiledialog without file path Pin
ejaz_pk25-Jan-08 1:31
ejaz_pk25-Jan-08 1:31 
GeneralRe: How to get file name from openfiledialog without file path Pin
Johan Hakkesteegt25-Jan-08 2:30
Johan Hakkesteegt25-Jan-08 2:30 
AnswerRe: How to get file name from openfiledialog without file path Pin
Ashfield25-Jan-08 2:52
Ashfield25-Jan-08 2:52 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.