Add Columns to DataGridView Existing Columns

Question

0.00/5 (No votes)

See more:

I Have DataGridView View like this

StudRollNo Name
1 AAA
2 BBB
3 CCC

I want to Add Columns to DataGridView of Subjects Table which is also comes after selecting Standard using Datatable to Existing columns like StudRollNo,Name

I want Like This way

StudRollNo Name English Maths History
1 AAA
2 BBB
3 CCC

Can any one suggest the way....

thx in advance....

Posted 10-Feb-12 19:44pm

Ravi Sargam

Updated 10-Feb-12 19:46pm

v2

Add a Solution

Comments

RDBurmon 11-Feb-12 1:53am

Please share you table structure .

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

RDBurmon · Answer 1 · 2012-02-10T20:04:00

Solution 1

As per my understanding below could be the implementation to achieve this

suppose you have two table as per below

Table1 : Student

RollNumber	Name
1	AAA
2	BBB
3	CCC

Table2 : Subject

RollNumber	English	Maths	History
1	50	60	70
2	40	45	50
3	35	65	38

then you query will be

SQL

SELECT S.Rollnumber,S.Name,Sub.English,Sub.Maths,Sub.History
 FROM Student S inner join Subject Sub On S.RollNumber=Sub.RollNumber

Hope this helps if yes then accept my answer and vote as well otherwise revert back with your queries.
--Rahul D.

Posted 10-Feb-12 20:04pm

RDBurmon

Comments

Ravi Sargam 11-Feb-12 2:27am

I have a table StudentMarks with Subject and StudentName.... columns

jai000 11-Feb-12 3:13am

SubjectMarks table should have StudentID as Foreign Key. Reason is that two or more student can have same name. I would suggest add StudentID/StudRollNo as foreign key in your studentMarks table

Ravi Sargam 11-Feb-12 3:16am

i have foreign key of StudentId and SubjectId

RDBurmon 11-Feb-12 5:41am

Ravi , Could you please how many tables you have with there stucture and foreign keys with them so that I can guide you ?