vb.net with mysql
-
I have three tables in the school database: students,exams,subjects. my Problem is how i can take the take the subjects records and admission no from students and use them to create a table call marks at the click of a button. Note: the no of records are unpredictable. Student Table contains fields: admno,name,form exam contains fields: ExamName subjects: SubjectName,SubjectID The Marks table final result should be admno,name,form,ExamName,subject1,subject2,...subjectn(Based on the no of subjects in the subject table) . Am using vb.net with mysql. Kindly assist. it has given me headache for weeks
-
I have three tables in the school database: students,exams,subjects. my Problem is how i can take the take the subjects records and admission no from students and use them to create a table call marks at the click of a button. Note: the no of records are unpredictable. Student Table contains fields: admno,name,form exam contains fields: ExamName subjects: SubjectName,SubjectID The Marks table final result should be admno,name,form,ExamName,subject1,subject2,...subjectn(Based on the no of subjects in the subject table) . Am using vb.net with mysql. Kindly assist. it has given me headache for weeks
KipkoechE wrote:
create a table call marks at the click of a button
I hope you mean inserting records into a table, not creating a table.
-
KipkoechE wrote:
create a table call marks at the click of a button
I hope you mean inserting records into a table, not creating a table.
-
Not a good idea.
-
I have three tables in the school database: students,exams,subjects. my Problem is how i can take the take the subjects records and admission no from students and use them to create a table call marks at the click of a button. Note: the no of records are unpredictable. Student Table contains fields: admno,name,form exam contains fields: ExamName subjects: SubjectName,SubjectID The Marks table final result should be admno,name,form,ExamName,subject1,subject2,...subjectn(Based on the no of subjects in the subject table) . Am using vb.net with mysql. Kindly assist. it has given me headache for weeks
Creating a dynamic table just means you'll have to write code to generate the CREATE TABLE statement and you'll have to do your checking to see how many columns should be included in it. However, why would you want to create a new table? The design sounds like a bad idea.
There are only 10 types of people in the world, those who understand binary and those who don't.
-
Creating a dynamic table just means you'll have to write code to generate the CREATE TABLE statement and you'll have to do your checking to see how many columns should be included in it. However, why would you want to create a new table? The design sounds like a bad idea.
There are only 10 types of people in the world, those who understand binary and those who don't.
The teacher just wants to check off the "Create Table AS SELECT" from his list of thing they should know about.
Wrong is evil and must be defeated. - Jeff Ello
-
I have three tables in the school database: students,exams,subjects. my Problem is how i can take the take the subjects records and admission no from students and use them to create a table call marks at the click of a button. Note: the no of records are unpredictable. Student Table contains fields: admno,name,form exam contains fields: ExamName subjects: SubjectName,SubjectID The Marks table final result should be admno,name,form,ExamName,subject1,subject2,...subjectn(Based on the no of subjects in the subject table) . Am using vb.net with mysql. Kindly assist. it has given me headache for weeks