62,272
社区成员
发帖
与我相关
我的任务
分享必须声明标量变量@
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是函数的参数，肯定有值
...全文
请发表友善的回复…
发表回复
O15013245O 2010-09-21
- 打赏
- 举报
select * from tb WHERE Name LIKE @Name
parm.Value = "%"+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();
测试通过。
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]
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+"%";
select * from tb WHERE Name LIKE '%'+@Name+'%'
看看role值和SQL语句
或parm.Value = "%"+name+"%";
叶子 2010-09-21
- 打赏
- 举报
myParameter[0].Value = role;
你调试一下SqlString有错误吗？
你现在的问题明显是@rrr被当成字段串了，没有得到外面传进来的值！
你调试一下SqlString有错误吗？
你现在的问题明显是@rrr被当成字段串了，没有得到外面传进来的值！
丰云 2010-09-21
- 打赏
- 举报
改成
+ " and Pub_Roles.RoleName LIKE '%@rrr%'";
试下看看
+ " 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';
