我用dataGridView1 连接数据库 然后 出现列表加了四个选项 首 上一个 下一个 尾 怎么实现呢。。就是让他 选择dataGridView1中列表的上下我感觉我描述的不太清楚
不知道怎么说
不过大大们应该明白!
不知道怎么说
不过大大们应该明白!
解决方案 »
- 正则表达式求解
- VS自带的MDF数据库在服务器上无法连接
- 在用tcpclient 和tcplistener 做个东西,客户端用streamreader.readline 总会造成卡死状态,请教下高手
- 求助!!!!!!请问哪个大哥有权限管理的组件啊 CG.security
- String or binary data would be truncated.
- 遇到个棘手问题,请大家帮忙解决!!!
- C#中WINFORM中DataGrid中添加ComboBOx控件怎么实现?要源程序
- 解析E2BA8465....
- 关于WinForm的问题
- c#中有没有Documents&View结构,在那里设置
- 实现事件的方法可以有返回类型吗?
- C# 数字 分段 取整
上:
if(this.dataGridView1.SelectedIndex!=0)
this.dataGridView1.SelectedIndex -= 1;首:
this.dataGridView1.SelectedIndex = 1其他两个同理
<HeaderStyle CssClass="top" />
<RowStyle HorizontalAlign="Center" />
<PagerStyle CssClass="page" />
<PagerTemplate>
<span style="float:left; margin-left:10px;padding-top:3px;" ID="send">
</span>
<span style="float:left;margin-left:170px;">
<input id="btex" type="button" class="anybutton" runat="server" value="确定打印" onclick="javascript:ToPrint();" />
</span>
<span style="float:right"><asp:Label id="lblPageIndex" runat="server" text='<%# ((GridView)Container.Parent.Parent).PageIndex + 1 %>' />/
<asp:Label id="lblPageCount" runat="server" text='<%# ((GridView)Container.Parent.Parent).PageCount %>' />页
<% if (this.Grids.PageIndex > 0){ %>
<asp:LinkButton ID="linkBtnPrev" runat="server" CommandArgument="Prev" CommandName="Page"
ForeColor ="Black">上一页</asp:LinkButton>
<%} %>
<% if (this.Grids.PageIndex < Grids.PageCount - 1){ %>
<asp:LinkButton ID="linkBtnNext" runat="server" CommandArgument="Next" CommandName="Page"
ForeColor ="Black">下一页</asp:LinkButton>
<% } %>
</span>
</PagerTemplate>
<Columns>
<asp:BoundField DataField="CustomerName" HeaderText="客户" />
<asp:BoundField DataField="FileName" HeaderText="文件名" />
</Columns>
</asp:GridView>
@PageSize int,
@strWhat varchar(50),
@PageCount int,
@strWhere varchar(500),
@sptable varchar(50)
AS
declare @sql varchar(5000)
declare @sqll varchar(5000)
set @sql=' select Top '+cast(@PageSize AS varchar)+' * from '+@sptable+' where ('+@strWhat+' < (select min('+@strWhat+') from (select top '+cast(@PageCount AS varchar)+' '+ @strWhat+' from '+@sptable+' where '+@strWhere+' order by '+@strWhat+' desc) as T )) and '+@strWhere+' order by '+@strWhat+' desc'
set @sqll = ' select Top '+cast(@PageSize AS varchar)+' * from '+@sptable+' where '+@strWhere+' order by '+@strWhat+' desc'
if ((cast(@PageCount AS varchar)) != 0)
exec(@sql)
else
exec(@sqll)
设置datagridview的SelectionMode属性为"FullRowSelect"测试效果比较好。
// 下一个按钮
private void button1_Click(object sender, EventArgs e)
{
if (this.dataGridView1.CurrentCell.RowIndex == this.dataGridView1.Rows.Count - 1)
{
MessageBox.Show("已到尾记录!");
return;
}
this.dataGridView1.CurrentCell = this.dataGridView1.Rows[this.dataGridView1.CurrentCell.RowIndex+1].Cells[0];
} // 首记录按钮
private void button3_Click(object sender, EventArgs e)
{
this.dataGridView1.CurrentCell = this.dataGridView1.Rows[0].Cells[0];
} // 尾记录按钮
private void button4_Click(object sender, EventArgs e)
{
this.dataGridView1.CurrentCell = this.dataGridView1.Rows[this.dataGridView1.Rows.Count-1].Cells[0];
}