Add row below specific column in datatable

Question

I use the following code to load sql table values ​​in datatable

        DataTable dt = new DataTable();
        SqlConnection con = new SqlConnection("Connection String Here");
        con.Open();
        SqlCommand cmd = new SqlCommand("select * from ExportExcel", con);
        dt.Load(cmd.ExecuteReader());
        int total = 0;
        foreach (DataRow row in dt.Rows)
        {
            int salaryvalue = Convert.ToInt32(row["Salary"]);
            total = salaryvalue + total;
        }

        dt.Rows.Add("Salary");
        dt.Rows.Add(total);

And I add salary, dynamically dynamically. But she shows in the first column one by one.

But I need a salary in the Department column, and the total amount in the Salary column. How to do it?

Answer 1

you can use

     dt.rows.add(new object[]{"","Salary",total });

Instead of calculating Total, you can use Datatable.Compute Method

     object total;
      total= dt.Compute("Sum(Salary)", "");

Answer 2

You should write like this after the foreach loop,

DataRow drNew=dt.NewRow();
drNew[0]="";
drNew[1]="Salary";
dtNew[2]=total;
dt.Rows.Add(drNew);

Hope this helps

Answer 3

, .

dt.Rows.Add(string.Empty, "Salary", total);

Answer 4

ADO.NET, , msdn: DataRow. , , excel.

DataRow row = dt.NewRow();

row["Name"] = "Salary";
row["Salary"] = total;
dt.Rows.Add(row);

Answer 5

-, * , . , .

:

// dt.Rows.Add("Salary"); <-- remove
dt.Rows.Add("", "Salary", total);

, , :

int total = dt.AsEnumerable.Sum(r => r.Field<int>("Salary"));