格式化DataSet里的日期类型

1.public static DataTable dataSetDateFormat(DataTable dt,string format)
  {
   string tempStr = "";
   DataTable tempTable = new DataTable();
   DataRow tempRow;
   DataColumn tempColumn;

   //Convert the DateTime type into string
   for(int k = 0;k < dt.Columns.Count;k++)
   {
    tempColumn = new DataColumn();
    tempColumn.Caption = dt.Columns[k].Caption;
    tempColumn.ColumnName = dt.Columns[k].ColumnName;
    if(dt.Columns[k].DataType.ToString() == System.Type.GetType("System.DateTime").ToString())
     tempColumn.DataType = System.Type.GetType("System.String");
    else
     tempColumn.DataType = dt.Columns[k].DataType;

    tempTable.Columns.Add(tempColumn);
   }

   for(int i = 0;i < dt.Rows.Count;i++)
   {
    tempRow = tempTable.NewRow();

    for(int j = 0;j < dt.Columns.Count;j++)
    {
     if(dt.Columns[j].DataType.ToString() == System.Type.GetType("System.DateTime").ToString())
     {
      string str = dt.Rows[i][j].ToString();
      if(str == "" || str.IndexOf("0001")>=0)
      {
       tempRow[j] = "";//str;
      }
      else
      {
       DateTime tempDateTime = new DateTime();
       tempDateTime = Convert.ToDateTime(str);
       tempStr = tempDateTime.ToString(format);
                            tempRow[j] = tempStr;
      }
     }
     else
     {
      tempRow[j] = dt.Rows[i][j];
     }

    }
    tempTable.Rows.Add(tempRow);
   }

   return tempTable;
  }

2.代码中应用:

if(dataSet.Tables[0] != null)
   {
    string format = Application["dateFormat"].ToString();
    DataTable tempTable = DBConvert.dataSetDateFormat(dataSet.Tables[0],format);
    DataSet tempDs = new DataSet();
    tempDs.Tables.Add(tempTable);
    dataSet = tempDs;
   } 

*********************************************************

记忆法大全(数百万字文字，共3张音频、视频教学光盘)

http://shop33212326.taobao.com/

*********************************************************