请教高手如何在pc机器上显示服务器的系统时间??? 用select getdate();得到系统时间 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 如果服务器是数据库服务器的话,可以使用sql语句如 tuzi98(兔子) 所说的 *功能: 取系统服务器的时间private void GetSystime() { string str_gettime = " select year(getdate()),month(getdate()),day(getdate())"; SqlCommand comm_gettime = new SqlCommand(str_gettime,sqlConnection1); string year =""; string month =""; string day = ""; try { if(sqlConnection1.State!=ConnectionState.Open) { sqlConnection1.Open(); } SqlDataReader read_gettime = comm_gettime.ExecuteReader(); if(read_gettime.Read()) { year = read_gettime[0].ToString(); month = read_gettime[1].ToString(); day = read_gettime[2].ToString(); if(month.Length==1) { month = "0"+month; } if(day.Length==1) { day = "0"+day; } } read_gettime.Close(); } catch(Exception err) { MessageBox.Show(err.Message); } finally { sqlConnection1.Close(); } systime = year.ToString()+ month.ToString() + day.ToString(); } 对不起,上面我是将时间转化成字符串了。这样string str_gettime = " select getdate()"; SqlCommand comm_gettime = new SqlCommand(str_gettime,sqlConnection1);if(sqlConnection1.State!=ConnectionState.Open) { sqlConnection1.Open();//连接要为服务器 }DataTime systime = (DataTime)comm_gettime.ExecuteScalar() 各位大神!关于Box与Unbox .net高手,关于文本框联动的问题,急啊 vs2008跟踪调试 c# windows应用程序做登陆如何判断用户登陆问题 我学C#没多久,一个很简单的问题自己没能力解决,可是现在由于需要,所以向大家请教了。。。。 有关SQL建表问题 关于SqlConnection对象关闭的问题,什么时候关闭最合适。 System.Threading.Timer的计时器,怎么只执行一次呢?? 线程方面的问题..急!!!! 请问一下,在c#中,如果在web模式下无法跟踪调试是为什么!是不是iis上设置有问题? 如何注册C#开发的组件 大虾们!请问这个sql语句怎么写?(请进来谈)
如 tuzi98(兔子) 所说的
private void GetSystime()
{
string str_gettime = " select year(getdate()),month(getdate()),day(getdate())";
SqlCommand comm_gettime = new SqlCommand(str_gettime,sqlConnection1);
string year ="";
string month ="";
string day = "";
try
{
if(sqlConnection1.State!=ConnectionState.Open)
{
sqlConnection1.Open();
}
SqlDataReader read_gettime = comm_gettime.ExecuteReader();
if(read_gettime.Read())
{
year = read_gettime[0].ToString();
month = read_gettime[1].ToString();
day = read_gettime[2].ToString();
if(month.Length==1)
{
month = "0"+month;
}
if(day.Length==1)
{
day = "0"+day;
}
}
read_gettime.Close(); }
catch(Exception err)
{
MessageBox.Show(err.Message);
}
finally
{
sqlConnection1.Close();
} systime = year.ToString()+ month.ToString() + day.ToString(); }
string str_gettime = " select getdate()";
SqlCommand comm_gettime = new SqlCommand(str_gettime,sqlConnection1);if(sqlConnection1.State!=ConnectionState.Open)
{
sqlConnection1.Open();//连接要为服务器
}
DataTime systime = (DataTime)comm_gettime.ExecuteScalar()