public DataTable fenye(int yd)
{
return Class1.ExecuteDataSet("select top 10 * from leave where id not in(select top 10*(" + yd+ "-1) from leave order by id ) ").Tables[0];
}
protected void Button3_Click(object sender, EventArgs e)
{
Repeater1.DataSource = dsds.fenye(1);
Repeater1.DataBind(); }
为什么我调试的时候会显示'(' 附近有语法错误 我根本就没用过单引号 怎么会单引号有错误 纳闷
{
return Class1.ExecuteDataSet("select top 10 * from leave where id not in(select top 10*(" + yd+ "-1) from leave order by id ) ").Tables[0];
}
protected void Button3_Click(object sender, EventArgs e)
{
Repeater1.DataSource = dsds.fenye(1);
Repeater1.DataBind(); }
为什么我调试的时候会显示'(' 附近有语法错误 我根本就没用过单引号 怎么会单引号有错误 纳闷
解决方案 »
- 求思路(抓取网页信息)
- 好奇怪,为什么这样的正则无法匹配?
- 求用c#开发wm客户端,用java开发服务端简单的结构说明,最好能给点关键的代码示例
- datetimepicker点击showupdown按钮焦点在分上时,每次在分上加30分,而不是默认的点击加1分
- 程序随机启动时,提示无法识别datetime字符串的错误
- winform 下datagridview 如何合并表头?
- C# 画面需要点击2下才起作用
- 源代码管理中获取的项目出错:从默认区域性的资源文件中读取资源时出错: 无效的 ResX 输入,求救!!!!!
- 急:如何实现C#应用程序在TREEVIEW上单击某个结点触发一个事件(在线等)
- 关于js拓扑图插件javascript mindmap 的动态数据怎么绑定
- 如何显示程序运行开始和结束的时间
- 如何将图形绕中心点旋转
===============
int i= 10*yd;
return Class1.ExecuteDataSet("select top 10 * from leave where id not in(select top "+ yd+ " * from leave order by id ) ").Tables[0];
return Class1.ExecuteDataSet("select top 10 * from leave where id not in(select top "+ i+ " * from leave order by id ) ").Tables[0]; //更正
select top 10*(" + yd+ "-1) from leave order by id
percent * from (select top ''+cast(@rnum as varchar)+'' * from '+@tablename+' where '+@strwhere+'
order by '+@orderfield+' asc) as b order by '+@orderfield+' desc) as a order by '+@orderfield+' desc '';'