我一个数据库的表名是以字母合时间命名的,格式为 “rw2007_8_30"
请问如果我想查询该表内容,下面的表名该用什么替代。 string strSql = "selcet f,t,p,tot,thetime from 表名 where station=1";
sqlTable = webService.ExcuteSelect(strSql);
请问如果我想查询该表内容,下面的表名该用什么替代。 string strSql = "selcet f,t,p,tot,thetime from 表名 where station=1";
sqlTable = webService.ExcuteSelect(strSql);
string strSql = string.Format("selcet f,t,p,tot,thetime from {0} where station=1",tabName);
sqlTable = webService.ExcuteSelect(strSql);
还是需要加引号之类的?
sqlTable = webService.ExcuteSelect(strSql);
string strSql = string.Format("selcet f,t,p,tot,thetime from {0} where station=1",tabName);
sqlTable = webService.ExcuteSelect(strSql);
这个就行啊
tring fromName="rw"+DateTime.Now.Year.ToString()+"_"+DateTime.Now.Month.ToString()+"_"+DateTime.Now.Day.ToString();
string strSql = "selcet f,t,p,tot,thetime from "+fromName+" where station=1";
sqlTable = webService.ExcuteSelect(strSql);提示无限的SQL语句