OleDbConnection sqlcon = new OleDbConnection(conStr);
sqlcon.Open();
OleDbCommand sqlcom = new OleDbCommand(cmdStr, sqlcon);
OleDbDataReader reader = sqlcom.ExecuteReader();
if (reader.Read())
{
this.txtID.Text = reader["学号"].ToString().Trim();
this.txtName.Text = reader["姓名"].ToString().Trim();
}
reader.Close();
sqlcon.Close();
在button 提交时,把textbox数据更新到数据库的同时,重新绑定到下一条就可以了。
下面这些语句你供参考。
declare @pagesize int//一页多少条
declare @pageindex int//当前页
set nocount on
declare @indextable table(id int identity(1,1),nid int)
declare @PageLowerBound int
declare @PageUpperBound int
set @PageLowerBound=(@pageindex-1)*@pagesize
set @PageUpperBound=@PageLowerBound+@pagesize
set rowcount @PageUpperBound
insert into @indextable(nid) select newsid from wqnews order by addtime desc
select O.newsid,O.source,O.heading,O.addtime from wqnews O,@indextable t where O.newsid=t.nid
and t.id>@PageLowerBound and t.id<=@PageUpperBound order by t.id
set nocount off
GO
<script language="C#" runat="server">
protected void Page_Load(Object Src, EventArgs E)
{
string strConn;
strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" +
"Data Source=C:\\exceltest.xls;" +
"Extended Properties=Excel 8.0;";
//You must use the $ after the object you reference in the spreadsheet
OleDbDataAdapter myCommand = new OleDbDataAdapter("SELECT * FROM [Sheet1$]",strConn);