必须声明标量变量@

njnuxj 2010-09-21 03:37:24

                SqlString = "SELECT Pub_Users.LogId,Obj_staff.StaffId,Obj_staff.StaffName,Pub_Roles.RoleName"

                                    + " FROM Pub_Users,Obj_staff,Pub_UserRole,Pub_Roles"

                                    + " WHERE Pub_Users.StaffId=Obj_staff.StaffId"

                                    + " and Pub_Users.LogId=Pub_UserRole.LogId"

                                    + " and Pub_UserRole.RoleId=Pub_Roles.RoleId"

                                    + " and Pub_Roles.RoleName LIKE '%'+@rrr+'%'";

                SqlParameter myParameter = new SqlParameter("@rrr", SqlDbType.VarChar);

                myParameter.Value = role;

                bh.AddParameter(myParameter);

                ds = bh.GetDataSet(SqlString);

总是报这样的错，role是函数的参数，肯定有值

...全文

239 15 打赏收藏转发到动态举报

写回复

用AI写文章

15 条回复

切换为时间正序

请发表友善的回复…

发表回复

O15013245O 2010-09-21

打赏
举报

select * from tb WHERE Name LIKE @Name

parm.Value = "%"+name+"%";

jack15850798154 2010-09-21

打赏
举报

SqlConnection con = new SqlConnection("Data Source=28678E561BFF4F2\\JINZHIYUAN;Initial Catalog=master;uid=sa;pwd=sql");
SqlCommand cmd = new SqlCommand("select * from city where city_name like '%'+@city_id+'%'", con);
SqlParameter[] param = { new SqlParameter("@city_id", "江苏") };
cmd.Parameters.AddRange(param);
SqlDataAdapter adapter = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
adapter.Fill(dt);
GridView1.DataSource = dt;
GridView1.DataBind();

测试通过。

newdigitime 2010-09-21

打赏
举报



修改两处:

+ " and Pub_Roles.RoleName LIKE @rrr";

myParameter.Value = "%"+role+"%";

njnuxj 2010-09-21

打赏
举报

不行哦，还是那样的错[Quote=引用 6 楼 newdigitime 的回复:]

SQL code

+ " and Pub_Roles.RoleName LIKE '%'+@rrr+'%'";
换成
+ " and Pub_Roles.RoleName LIKE '%"+@rrr+"%'";
[/Quote]

myjavamosquito 2010-09-21

打赏
举报

+ " and Pub_Roles.RoleName LIKE '%"+@rrr+"%'";

苏州牛恋歌 2010-09-21

打赏
举报

+ " and Pub_Roles.RoleName LIKE like "+"'%"+@rrr+"%'"
应这样写

cqdyh 2010-09-21

打赏
举报

SqlString = "SELECT Pub_Users.LogId,Obj_staff.StaffId,Obj_staff.StaffName,Pub_Roles.RoleName"

                                    + " FROM Pub_Users,Obj_staff,Pub_UserRole,Pub_Roles"

                                    + " WHERE Pub_Users.StaffId=Obj_staff.StaffId"

                                    + " and Pub_Users.LogId=Pub_UserRole.LogId"

                                    + " and Pub_UserRole.RoleId=Pub_Roles.RoleId"

                                    + " and Pub_Roles.RoleName LIKE @rrr";

                SqlParameter myParameter = new SqlParameter("@rrr", SqlDbType.VarChar);

                myParameter.Value = "%"+ role +"%";

                bh.AddParameter(myParameter);

                ds = bh.GetDataSet(SqlString);

majic2008 2010-09-21

打赏
举报

又来个粗心的lz

jack15850798154 2010-09-21

打赏
举报

'+@rrr+' 换成 "+@rrr+"

newdigitime 2010-09-21

打赏
举报



+ " and Pub_Roles.RoleName LIKE '%'+@rrr+'%'";

换成

+ " and Pub_Roles.RoleName LIKE '%"+@rrr+"%'";

wuyq11 2010-09-21

打赏
举报

sqlparameter
select * from tb WHERE Name LIKE '%'+@Name+'%'
看看role值和SQL语句
或parm.Value = "%"+name+"%";

叶子 2010-09-21

打赏
举报

myParameter[0].Value = role;

你调试一下SqlString有错误吗？

你现在的问题明显是@rrr被当成字段串了，没有得到外面传进来的值！

丰云 2010-09-21

打赏
举报

改成
+ " and Pub_Roles.RoleName LIKE '%@rrr%'";
试下看看

丰云 2010-09-21

打赏
举报

+ " and Pub_Roles.RoleName LIKE '%'+@rrr+'%'";

这句是这样拼写吗？

lchy110 2010-09-21

打赏
举报



SqlParameter[] parms = new SqlParameter[] {

                                            new SqlParameter("@rrr",SqlDbType.Char,10)}

            parms[0].Value = 'ddd';