先获取session的 值,然后,sql="select 级别",然后,sql"select * from 表 where 级别<"+????; datagrid.DataSource = ds.Table[0]; datagrid.DataBind();
sql="select 级别 from 用户权限表 where UserName='" &session("UserName") &"'" Dim LoadCommand As OleDbCommandloadcommand=new OleDbCommand(sql,connection )strPurview= LoadCommand.ExecuteScalar() '权限级别,然后,sql="select * from 表 where 级别<" strpurview
我写完SELECT 用户名, 级别 FROM 用户权限 WHERE (用户名 = @用户名) 我怎么把值付给@用户名?
datagrid.DataSource = ds.Table[0];
datagrid.DataBind();
Dim LoadCommand As OleDbCommandloadcommand=new OleDbCommand(sql,connection )strPurview= LoadCommand.ExecuteScalar() '权限级别,然后,sql="select * from 表 where 级别<" strpurview
我怎么把值付给@用户名?