how to add values into a table which is calculated from other table

Question

1.00/5 (1 vote)

See more:

VS2008

How to add entries to a table by calculating the entries in other table. I have marks got in every subject for a student in table1 respectiveley. I have another table table2 in which i want to calculate the average marks of the student and view it. How can I do it, I am coding using c# in visual studio.

[EDIT]Added table from comment

Table 1

studentnumber subjectcode marks
1             2           75
1             3           65
2             2           50
2             3           75
1             1           65

Posted 2-Sep-15 20:15pm

Member 11949886

Updated 3-Sep-15 5:14am

George Jonsson

v2

Add a Solution

Comments

Sarath kumar.N 3-Sep-15 2:27am

Once you got the values from one table try create data table. After creating data table you can use use it anywhere.

Member 11949886 3-Sep-15 2:29am

Thank u sarath bhai.. but can u please tell what is the command I can write?? I am stuck in this from 2 days

Sarath kumar.N 3-Sep-15 3:05am

without knowing the structure how can I write the code for you? You have to mention structure of 1st table. Then what do you want display in a second table. that will be easier to help you even others.

Member 11949886 3-Sep-15 7:56am

Sarath sir, I have given structure of the table... Please have a look at it

Sarath kumar.N 3-Sep-15 8:56am

Give 10 min. I will be with solution.Thanks!

Sinisa Hajnal 3-Sep-15 2:59am

This is not free code service. Create datatable object and its columns and calculate what you need to do.

George Jonsson 3-Sep-15 3:01am

What is the structure of your two tables?

Member 11949886 3-Sep-15 7:55am

George I have given structure of the table... Please have a look at it

Member 11949886 3-Sep-15 3:28am

Table 1
studentnumber subjectcode marks
1 2 75
1 3 65
2 2 50
2 3 75
1 1 65

The second table has
studentnumber average(%)

These are my tables... I need to take the average marks got by a specific student in second table by adding his marks and deviding it by number of subject he appeared for a specifif student. Please help doing it

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)

Sarath kumar.N · Answer 1 · 2015-09-03T03:30:00

Consider you already have table(DataGridview) with students marks. You need read those marks and calculate average marks. Then display the average in different table.

Reading students marks from table(Datagridview):

C#

string studentName = "";
  int english, maths, science, average;
  BindingSource bs = (BindingSource) dataGridView1.DataSource;
      // Converting datagridview datasource to data table
  DataTable dataTable = (DataTable) bs.DataSource;

  //Creating datatable for 2nd table
  DataTable dt = new DataTable();
  dt.Columns.Add("Student_Name");
  dt.Columns.Add("Average");

  foreach (DataRow dr in dataTable.Rows) // reading each row from datatable
  {
      studentName = dr["studentName"].ToString();
      english = Convert.ToInt32(dr["English"]);
      maths = Convert.ToInt32(dr["Maths"]);
      science = Convert.ToInt32(dr["Science"]);

      //Calculating AVERAGE
      average = (english + maths + science)/3;

      //Adding students average in datatable
      DataRow row = dt.NewRow();
      row["Student_Name"] = studentName;
      row["average"] = average;
      dt.Rows.Add(row);
  }

  //bind datatable with the 2nd table(datagridview)
  dataGridView2.DataSource = dt;