我用一个sql语句联合查询几个表,在navicat上查询输入这个语句可以出现结果,但在代码里用该语句查询时datatable接收完后是个空的,不知道这是为什么。下面是我的数据库查询语句: MySqlConnection conn = new MySqlConnection("Server=localhost;Database=t;port=3306;User Id=root;Password=''");
conn.Open(); MySqlDataAdapter mda = new MySqlDataAdapter(sql, conn);
DataTable dt = new DataTable();
mda.Fill(dt); conn.Close();
return dt;求高人帮忙指点迷津~sql语句没有问题~
conn.Open(); MySqlDataAdapter mda = new MySqlDataAdapter(sql, conn);
DataTable dt = new DataTable();
mda.Fill(dt); conn.Close();
return dt;求高人帮忙指点迷津~sql语句没有问题~
SELECT s.workshop_name,p.title,m.id FROM production_step_schedules m LEFT JOIN production_steps s on m.production_step_id=s.id join productions p on m.production_id=p.id where m.arrange_start>='2013-08-26 08:00:00' and m.arrange_start<'2013-08-26 21:00:00'