void sqlread(Listview lvv)
{string selStr="select autoId,myDate from fix_Assetregister";
SqlCommand cmd=new SqlCommand(selStr,cn);
SqlDataReader dr=cmd.ExecuteReader();
while(dr.Read())
{
ListViewItem lvv=new ListViewItem(dr[0].ToString())
lvv.SubItems.Add(dr[1].ToString("yyyy-MM-dd"));//这里怎么会错呢?
//我想把日期字段以如2005-08-09的格式输出,后面没有时间;
liv.Items.Insert(this.Listview1.Items.Count,lvv);
}
}
{string selStr="select autoId,myDate from fix_Assetregister";
SqlCommand cmd=new SqlCommand(selStr,cn);
SqlDataReader dr=cmd.ExecuteReader();
while(dr.Read())
{
ListViewItem lvv=new ListViewItem(dr[0].ToString())
lvv.SubItems.Add(dr[1].ToString("yyyy-MM-dd"));//这里怎么会错呢?
//我想把日期字段以如2005-08-09的格式输出,后面没有时间;
liv.Items.Insert(this.Listview1.Items.Count,lvv);
}
}
只对时间类型有效,所以要把x转换成时间类型
if(dr.IsDBNull(1) == false)lvv.SubItems.Add(dr.GetDateTime(1).ToString("yyyy-MM-dd"));