如何向Data表添加新列？ [英] How to add new column to Data table?

问题描述

我有一个GridView，用于显示利润金额的报告。在这里我使用DataTable从backent绑定GridView我的代码是这样的

 SqlCommand cmd =  new  SqlCommand（）; 
 cmd.CommandText =   GetProfitAmount; 
 cmd.Connection = _sConn; 
 cmd.CommandType = CommandType.StoredProcedure; 
  if （shareHolderId！=  0 ）
 {
 cmd。 Parameters.Add（  @ ShareHolderId，SqlDbType.Int）.Value = shareHolderId; 
} 
  else  
 {
 cmd.Parameters.Add（   @ ShareHolderId，SqlDbType.Int）.Value = DBNull.Value; 
} 
 SqlDataAdapter adp =  new  SqlDataAdapter（cmd）; 
 DataTable dt =  new  DataTable（）; 
 adp.Fill（dt）; 

这里我直接从代码后面绑定。我有两个列，分别是ActualPaid和PaidAmount现在我想再添加一列到现有DataTable，列名为TotalProfit，值将为ActualPaid - PaidAmount。



所以任何人都可以帮助我



感谢@ dv @ nce

解决方案

< blockquote>



尝试如下：

 dt.Columns.Add（  TotalProfit，类型（System。 Double ））; 
 dt.AcceptChanges（）; 
 
  foreach （DataRow row  in  dt.Rows）
 { 
 row [  TotalProfit] = Convert.ToDouble（row [  ActualPaid]。ToString（）） -  Convert.ToDouble（row [   PaidAmount]。ToString（））; 
} 
 dt.AcceptChanges（）; 

你必须注意投射和默认值。



希望它有所帮助。

I have a GridView which is used to display report of Profit Amount. Here i'm binding GridView from backent using DataTable my code is like this

SqlCommand cmd = new SqlCommand();
cmd.CommandText = "GetProfitAmount";
cmd.Connection = _sConn;
cmd.CommandType = CommandType.StoredProcedure;
if (shareHolderId != 0)
{
    cmd.Parameters.Add("@ShareHolderId", SqlDbType.Int).Value = shareHolderId;
}
else
{
    cmd.Parameters.Add("@ShareHolderId", SqlDbType.Int).Value = DBNull.Value;
}
SqlDataAdapter adp = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
adp.Fill(dt);

here i'm binding directly from code behind. There I've two columns, which are "ActualPaid and PaidAmount" Now I want to add one more column to existing DataTable with the column name TotalProfit and value will be like "ActualPaid - PaidAmount".

So can anyone help me please

Thanks in @dv@nce

解决方案

Hi,

try like below:

dt.Columns.Add("TotalProfit", type(System.Double));
dt.AcceptChanges();

foreach(DataRow row in dt.Rows)
{
    row["TotalProfit"] = Convert.ToDouble(row["ActualPaid"].ToString()) - Convert.ToDouble(row["PaidAmount"].ToString());
}
dt.AcceptChanges();

you must take care of casting and default values.

hope it helps.

这篇关于如何向Data表添加新列？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！