日期:2014-05-18  浏览次数:20392 次

asp.net中必须声明标量变量
在做注册的时候注册基本信息后 去注册详细信息 在同一个表里 然后执行修改操作 但是总是提示必须声明标量变量@AddDate
从网上找的解决方法 都不行 各位大侠帮帮忙吧 在线等 …………
C# code

    public void Update(Farm.Model.Company model)
        {
            StringBuilder strSql=new StringBuilder();
            strSql.Append("update Company set ");
            strSql.Append("GID=@GID,");
            strSql.Append("CName=@CName,");
            strSql.Append("CPwd=@CPwd,");
            strSql.Append("TrueName=@TrueName,");
            strSql.Append("CEmail=@CEmail,");
            strSql.Append("CMobile=@CMobile,");
            strSql.Append("Ctouch=@Ctouch,");
            strSql.Append("CDes=@CDes,");
            strSql.Append("Area=@Area,");
            strSql.Append("Business=@Business,");
            strSql.Append("IsValid=@IsValid,");
            strSql.Append("AddDate=@AddDate");
            strSql.Append("CType=@CType");
            strSql.Append("CDate=@CDate");
            strSql.Append("Service=@Service");
            strSql.Append("CFace=@CFace");
            strSql.Append(" where CID=@CID ");
            
            SqlParameter[] parameters = {
                    new SqlParameter("@CID", SqlDbType.Int,4),
                    new SqlParameter("@GID", SqlDbType.Int,4),
                    new SqlParameter("@CName", SqlDbType.VarChar,50),
                    new SqlParameter("@CPwd", SqlDbType.VarChar,50),
                    new SqlParameter("@TrueName", SqlDbType.VarChar,50),
                    new SqlParameter("@CEmail", SqlDbType.VarChar,50),
                    new SqlParameter("@CMobile", SqlDbType.VarChar,50),
                    new SqlParameter("@Ctouch", SqlDbType.VarChar,50),
                    new SqlParameter("@CDes", SqlDbType.Text),
                    new SqlParameter("@Area", SqlDbType.VarChar,100),
                    new SqlParameter("@Business", SqlDbType.VarChar,200),
                    new SqlParameter("@IsValid", SqlDbType.Int,4),
                    new SqlParameter("@AddDate", SqlDbType.DateTime),
                    new SqlParameter("@CType",SqlDbType.VarChar,50),
                    new SqlParameter("@CDate",SqlDbType.DateTime),
                    new SqlParameter("@Service",SqlDbType.Text),
                    new SqlParameter("@CFace",SqlDbType.VarChar,50)};
            parameters[0].Value = model.CID;
            parameters[1].Value = model.GID;
            parameters[2].Value = model.CName;
            parameters[3].Value = model.CPwd;
            parameters[4].Value = model.TrueName;
            parameters[5].Value = model.CEmail;
            parameters[6].Value = model.CMobile;
            parameters[7].Value = model.Ctouch;
            parameters[8].Value = model.CDes;
            parameters[9].Value = model.Area;
            parameters[10].Value = model.Business;
            parameters[11].Value = model.IsValid;
            parameters[12].Value = model.AddDate;
            parameters[13].Value = model.Ctype;
            parameters[14].Value = model.Cdate;
            parameters[15].Value = model.Service;
            parameters[16].Value = model.Cface;

            Farm.DBUtility.DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
        }




------解决方案--------------------

strSql.Append("AddDate=@AddDate,");
strSql.Append("CType=@CType,");
strSql.Append("CDate=@CDate,");
strSql.Append("Service=@Service,");
------解决方案-----