C# MYSQL CASE
SELECT A.detect_time, case when Hour (A.detect_time) >= 8 then left(a.detect_time,10) ELSE date_add(left(a.detect_time,10),interval -1 day) end as detect_mfg_day FROM H_LOG_DEFT A;这个SQL在MYSQL运行,可以显示二列,但是在C#里运行后,只显示detect_time,不显示detect_mfg_day,C#\MYSQL都沒有報錯。這是為什麽?謝謝!
綁定這麼寫的:
string Conn = "Data Source='192.168.2.14';Database='his';User Id='query';Password='123456'";
MySqlConnection mycn = new MySqlConnection(Conn);
mycn.Open();
MySqlCommand cmd = new MySqlCommand(sql ,mycn);//sql就是上面的SELECT
cmd.Connection = mycn;
MySqlDataAdapter da = new MySqlDataAdapter(sql ,mycn );
DataSet dsSource = new DataSet(); //这是源数据库记录集,先获取源数据库所有数据在此记录集
da.Fill (dsSource ,"T");
GridView1.DataSource=dsSource ;
GridView1.DataBind();
mycn.Close();