网优图层制作工具报错”Column '' does not belong to table .”的解决办法

一、问题现象

在使用网优小工具的时候,导入工作表之后出现下图错误,从英文理解,大意应该是空列不能从属与一个表,导致图层无法制作。

二、解决方法

核查问题原因,主要是标签名未做选择,这是需要选择原始表里面的一列表头字段作为标签。选择后,问题解决。

阅读更多

服务器人数多的时候出现Column XXXX does not belong to table

02-24

服务器人数多的时候出现Column XXXX does not belong to tablernrn代码没问题,rnrn最主要的是全是查询语句出现的,返回是datetable类型rnrn更奇怪的是Column XXXX does not belong to tablern这个页面执行的时候压根没有这个表,更别说这个字段rn刷新的时候这个页面要不就是出现 rnColumn A does not belong to table1rnColumn A does not belong to table2rnColumn b does not belong to table3rnrn还有Internal connection fatal errorrndoes not contain a property with the namern等等rnrn上传服务器,人多了就会出现,刷新1下,出现不一样的报错rnrnServer Error in '/' Application.rn--------------------------------------------------------------------------------rnrnDataBinding: 'System.Data.DataRowView' does not contain a property with the name 'type'. rnDescription: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. rnrnException Details: System.Web.HttpException: DataBinding: 'System.Data.DataRowView' does not contain a property with the name 'type'.rnrnrn很郁闷啊!!!求大神解决rnrn上传1下DLL,就好啦,过一会又出现这个问题,时好时坏。rnrnrn代码如下:rnrn public static SqlCommand cmd = null;rn public static SqlConnection conn = null;rn public static string connstr = Maticsoft.DBUtility.PubConstant.GetConnectionString("connstr");rn public SQLHelper()rn rn #region 建立数据库连接对象rn /// rn /// 建立数据库连接 rn /// rn /// 返回一个数据库的连接SqlConnection对象 rn public static SqlConnection init()rn rn tryrn rn conn = new SqlConnection(connstr);rn if (conn.State != ConnectionState.Open)rn rn conn.Open();rn rn rn catch (Exception e)rn rn throw new Exception(e.Message.ToString());rn rn return conn;rn rn #endregionrnrn #region 设置SqlCommand对象rn /// rn /// 设置SqlCommand对象 rn /// rn /// SqlCommand对象 rn /// 命令文本 rn /// 命令类型 rn /// 参数集合 rn private static void SetCommand(SqlCommand cmd, string cmdText, CommandType cmdType, SqlParameter[] cmdParms)rn rn cmd.Connection = conn;rn cmd.CommandText = cmdText;rn cmd.CommandType = cmdType;rn if (cmdParms != null)rn rn cmd.Parameters.AddRange(cmdParms);rn rn rn #endregionrn #region 执行不带参数sql语句,返回一个DataTable对象rn /// rn /// 执行不带参数sql语句,返回一个DataTable对象 rn /// rn /// 相应的sql语句 rn /// 返回一个DataTable对象 rn public static DataTable GetDataTable(string cmdText)rn rnrn SqlDataReader reader;rn DataTable dt = new DataTable();rn tryrn rn init();rn cmd = new SqlCommand(cmdText, conn);rn reader = cmd.ExecuteReader(CommandBehavior.CloseConnection);rn dt.Load(reader);rn reader.Close();rn conn.Close();//---rn rn catch (Exception ex)rn rn throw new Exception(ex.Message.ToString());rn rn return dt;rn rn #endregionrnrn #region 执行带参数的sql语句或存储过程,返回一个DataTable对象rn /// rn /// 执行带参数的sql语句或存储过程,返回一个DataTable对象 rn /// rn /// sql语句或存储过程名 rn /// 命令类型 rn /// 参数集合 rn /// 返回一个DataTable对象 rn public static DataTable GetDataTable(string cmdText, CommandType cmdType, SqlParameter[] cmdParms)rn rn SqlDataReader reader;rn DataTable dt = new DataTable();rn tryrn rn init();rn cmd = new SqlCommand();rn SetCommand(cmd, cmdText, cmdType, cmdParms);rn reader = cmd.ExecuteReader(CommandBehavior.CloseConnection);rn dt.Load(reader);rn reader.Close();rn conn.Close();//---rn rn catch (Exception ex)rn rn throw new Exception(ex.Message.ToString());rn rn return dt;rn rn #endregionrnrnrn大家看看那里有问题吗,谢谢大神门rnrn

没有更多推荐了,返回首页