How to datatable row and columns settings in C#?

Question

1.00/5 (1 vote)

See more:

I want to:

Counts Result
Count: 5

But this code result:

I want to title and count:5 --->rows

Row1: CountResult //TİTLE
Row2: Count:5

What I have tried:

public DataTale Count()
{
var t=MyStudentEntities.Where(x=>x.ID=10).Count();  ---> result:5

var dataTable=new System.Data.DataTable();
dataTable.Columns.Add("Count");
var newRow=dataTable.NewRow();
newRow[]=t;

dataTable.Row.Add(newRow);

}<

Posted 14-Jan-20 7:43am

Member 14169626

Updated 14-Jan-20 20:38pm

Add a Solution

2 solutions

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)

Maciej Los · Answer 1 · 2020-01-14T20:38:00

Your question is NOT clear. I'm guessing that you want to create new datatable. Then you want to add a number of rows depending on result of EF query.

C#

using System.Data;

public static DataTale CountResult(int _id)
{
var t=MyStudentEntities.Where(x=>x.ID=_id).Count();  //result:5

DataTable dt = new DataTable();
dt.Columns.Add(new DataColumn("CountResult", typeof(int)));
for(int i=0; i<=t; i++)
    dataTable.Row.Add(new object[]{i});

return dt;
}

Richard MacCutchan · Answer 2 · 2020-01-14T08:00:00

Solution 1

C#

newRow[]=t;

You need to specify which column to store the data:

C#

newRow[0]=t; // store value in the first column

Posted 14-Jan-20 8:00am

Richard MacCutchan

Comments

Member 14169626 14-Jan-20 14:35pm

But not 0. I want to first row title.Second row column 1 is count: column2 is 5

Richard MacCutchan 14-Jan-20 15:21pm

Sorry that is not very clear. What is in the three columns of Row1, and the first two columns of Row 2?

Row1:  ?    :   ?    :   ?
Row2:  ?    :   ?    :   5

Member 14169626 14-Jan-20 23:10pm

I want to count:5

Richard MacCutchan 15-Jan-20 3:40am

Sorry, but that means nothing.

Maciej Los 15-Jan-20 2:18am

5!

Richard MacCutchan 15-Jan-20 3:40am

:)

Member 14169626 15-Jan-20 13:27pm

Col 1 Col2

Row 1 Tshirt 5

Row 2 Short 10

Row 3

.
.
.

Row 8 Shoes 6