SQLDataReader获取日期时间格式
本文关键字:格式 时间 取日期 获取 SQLDataReader | 更新日期: 2023-09-27 18:11:37
查看下面的代码:
HTML页面:
<table width="100%" align="right" cellpadding="2" cellspacing="2" border="0" bgcolor="#EAEAEA">
<tr align="center" style="background-color: yellow; color: black;">
<th colspan="2">Fauzan</th>
<th colspan="2">Febri</th>
</tr>
<tr align="left" style="background-color: gray; color: black;">
<td>ID</td>
<td>Number01</td>
<td>TheDate</td>
<td>Number02</td>
</tr>
<%=getWhileLoopData()%>
</table>
背后的代码:
public string getWhileLoopData()
{
string htmlStr = "";
SqlConnection thisConnection = new SqlConnection(ConfigurationManager.ConnectionStrings["MyConnectionString"].ConnectionString);
SqlCommand thisCommand = thisConnection.CreateCommand();
thisCommand.CommandText = "SELECT * FROM MyTable WHERE TheDate = @TheDate";
thisCommand.Parameters.AddWithValue("@TheDate", txtDate.Text);
thisConnection.Open();
SqlDataReader reader = thisCommand.ExecuteReader();
while (reader.Read()) {
int id = reader.GetInt32(0);
int Number01 = reader.GetInt32(1);
DateTime TheDate = reader.GetDateTime(2);
Decimal Number02 = reader.GetDecimal(3);
//string Pass = reader.GetString(2);
htmlStr += "<tr><td>" + id + "</td><td>" + Number01 + "</td><td>" + TheDate + "</td><td>" + Number02 + "</td></tr>";
}
thisConnection.Close();
return htmlStr;
}
问题是,我如何格式化数据阅读器?比如,"TheDate"字段,从'6/18/2014 12:00:00 AM'到'18/june/2014'。也为'Number02'字段,我怎么能格式化它?从"0.829",成为"0.83"。
您可以使用ToString()使用自定义日期和时间格式字符串来格式化datetime
string strDate = TheDate.ToString("dd/MMM/yyyy");
你可以用Math。四舍五入格式化数字
Number02 = Math.Round(Number02, 2);
你可以直接在你正在制作的html字符串中格式化日期和数字
htmlStr += "<tr><td>" + id + "</td><td>" + Number01 + "</td><td>" +
TheDate.ToString("dd/MMM/yyyy") + "</td><td>" + Math.Round(Number02, 2) + "</td></tr>";