using System;
using System.Data;
using System.Data.OleDb;
using System.Data.SqlClient;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
public partial class _Default : System.Web.UI.Page
{ protected void btnname_Click(object sender, EventArgs e)
{ OleDbConnection dbconn = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data source=C:\inetpub\wwwroot\WebSite\pei.mdb");
dbconn.Open();
OleDbCommand cmd=new OleDbCommand("select * from login",dbconn); OleDbDataReader reader = cmd.ExecuteReader(); //表里有id 和 name 2个子段
Response.Write(reader["id"] + "  "+reader["name"]+"<br>");
reader.Read();
}
}我怎么样点击btnname按钮后可以让纪录向下移动一条,谢谢!马上给分!
using System.Data;
using System.Data.OleDb;
using System.Data.SqlClient;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
public partial class _Default : System.Web.UI.Page
{ protected void btnname_Click(object sender, EventArgs e)
{ OleDbConnection dbconn = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data source=C:\inetpub\wwwroot\WebSite\pei.mdb");
dbconn.Open();
OleDbCommand cmd=new OleDbCommand("select * from login",dbconn); OleDbDataReader reader = cmd.ExecuteReader(); //表里有id 和 name 2个子段
Response.Write(reader["id"] + "  "+reader["name"]+"<br>");
reader.Read();
}
}我怎么样点击btnname按钮后可以让纪录向下移动一条,谢谢!马上给分!
解决方案 »
- gridview手动添加列以后,如何将数据放入新添加列?
- 如何取 PlaceHolder内生成的筛选框的值
- CSS Friendly 菜单多余三层时出现的问题,谢谢
- ajax参数传递是否安全
- 用户关闭浏览器怎么办?
- 关于在动态绑定gridview里,怎样取某列的列标题值!!(如vs2003datagrid里的e.item.cells[列号].text!!在vs2005怎样实现在gridview里取
- 新手有疑问
- TreeView使用求助
- 求关于visual studio 7.0 中关于asp.net 运用的书
- 有關aspx.cs的頁面控制問題
- 如何实现网易添加控件的那个功能?苦等!(皆分)
- 什么是元数据 vs2005怎样用元数据
OleDbCommand cmd=new OleDbCommand("select * from login ",dbconn);
select * from login where id=session[]的值。
reader.Read()功能使reader前进到下一条记录
然后再定义的个ViewState["currentRec"] = 0;--当前浏览index
这两个在 page_load事件里面的if(!IsPostBack){这里加}
每次点击按钮就
int cRec = Convert.ToInt32(ViewState["currentRec"].ToString().Trim());
ViewState["currentRec"] = cRec+1;
谢谢,不过数据库中怎么样操作呢,我每点击一次按钮,数据就会next一条!
上面的数据源是dataset!如果是的话,那么你就可以在点击按钮事件里面这样写了
int cRec = Convert.ToInt32(ViewState["currentRec"].ToString().Trim());
ViewState["currentRec"] = cRec+1;
myds = OleDbConnection dbconn = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data source=C:\inetpub\wwwroot\WebSite\pei.mdb");
dbconn.Open();
OleDbCommand cmd=new OleDbCommand("select * from login",dbconn); DataSet myds= cmd.ExecuteDataSet();
TextBox1.Text = myds.Tabels[0].Rows[cRec+1]["ID"].ToString();
....
每次调用一次查询
Select top 1 * from login where id>currentId order by id