SqlConnection con = new SqlConnection("server=localhost;database=7daydian;uid=sa;pwd=1234");


        string dia = "dianliang";

        string sql = "select '"+dia+"' from tongji order by shijian";

        SqlCommand com = new SqlCommand(sql, con);

 string sql = 'select "+dia+" from tongji order by shijian';

------解决方案--------------------
探讨


引用:
dia是字段名？
string sql = "select " + dia + " from tongji order by shijian";
这样写

C# code

string sql = "select distinct  [name] as 板块名称 ,[" + mon + "]as [周一]
,[" + thur + "]as [周2]
,[……


------解决方案--------------------
探讨


dia是字段名？
 string sql = "select " + dia + " from tongji order by shijian";
这样写