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/
*********************************************************