＋设为首页 ＋添加到收藏夹
我在SQL Query Analyzer中運行select * from atable
時間一橍為，“2005-6-27 下午 07:31:00”或“2005-6-26 上午 08:00:00”
而我WinFrom的DataGird中显示的只有2005-6-27 ，后面的 “下午 07:31:00”都没有显示出来
我的代码為：
SqlConnection sqlcn = new SqlConnection("server=;database=;uid=;pwd=");
SqlDataAdapter sqlad = new SqlDataAdapter("select * from atable", sqlcn);
DataSet ds = new DataSet();
sqlad.Fill(ds, "authors");
dataGrid1.DataSource = ds.Tables["authors"];
但同樣的代碼，我在WebFrom的DataGird中显示出來就是“2005-6-27 下午 07:31:00”或“2005-6-26 上午 08:00:00”對的，
問題：請各位指教為什麼在WinFrom的DataGird中显示的只有2005-6-27。
喔。。。
应该这样写：((DataGridTextBoxColumn)dataGrid1.TableStyles[0].GridColumnStyles["sj"]).Format = "yyyy/MM/dd HH:mm:ss";
void SetDataGridStyle(DataGrid dataGrid1)
{
if (dataGrid1.TableStyles.Count > 0) return;
DataGridTableStyle ts = new DataGridTableStyle();
ts.MappingName = dataGrid1.DataSource.TableName;
DataGridTextBoxColumn dc0 = new DataGridTextBoxColumn();
dc0.Alignment = HorizontalAlignment.Center;
dc0.HeaderText = "时间";
dc0.MappingName = "sj";
dc0.Format = "yyyy/MM/dd HH:mm:ss";
dc0.Width = 70;
ts.GridColumnStyles.Add(dc0);
dc0 = new DataGridTextBoxColumn();
dc0.Alignment = HorizontalAlignment.Right;
dc0.HeaderText = "存入";
dc0.MappingName = "存入";
dc0.Format = "#,##0.00; ";
dc0.Width = 60;
ts.GridColumnStyles.Add(dc0);
dataGrid1.TableStyles.Add(ts);
}
