DataTable操作

public DataTable baseData(string sql, ref double total)
       {
           DataTable ds = new DataTable();
           DataTable dt = new DataTable();
           dt= sqlhelper.ExecuteDataTable(sql, CommandType.Text, null).Tables[0];
           ds.Columns.Add("序号", System.Type.GetType("System.String"));
           ds.Columns.Add("表号", System.Type.GetType("System.String"));
           ds.Columns.Add("地址", System.Type.GetType("System.String"));
           ds.Columns.Add("表底数", System.Type.GetType("System.String"));
           ds.Columns.Add("电量", System.Type.GetType("System.String"));
           ds.Columns.Add("抄表日期", System.Type.GetType("System.String"));
           if (dt.Rows.Count>0)
           {
               for (int i = 0; i <dt.Rows.Count; i++)
               {
                   DataRow dr = ds.NewRow();                  
                   //double pvalue=Convert.ToDouble(ds.Rows[i]["表底数"]); 
                   dr["序号"] = dt.Rows[i]["序号"];
                   dr["表号"]=dt.Rows[i]["表号"];
                   dr["地址"] = dt.Rows[i]["地址"];
                   dr["表底数"] = dt.Rows[i]["表底数"];
                   dr["抄表日期"] = dt.Rows[i]["抄表日期"];
                   dr["电量"] = dt.Rows[i]["电量"];
                   ds.Rows.Add(dr);
               }
           }
           return ds;
       }