如何使数据绑定的控件实现“上一条”、“下一条”、“第一条”和“最后一条”的功能？（WinForm, C#）

最新推荐文章于 2021-09-30 19:09:16 发布

MM22GG

最新推荐文章于 2021-09-30 19:09:16 发布

阅读量2.3k

点赞数

分类专栏： c# 文章标签： winform c# datagrid dataset string object

c# 专栏收录该内容

7 篇文章

订阅专栏

本文转载于 http://blog.youkuaiyun.com/orangapple/article/details/1395236

如何使数据绑定的控件实现“上一条”、“下一条”、“第一条”和“最后一条”的功能？（WinForm, C#）

有“类别”表，数据如下：

有“产品”表，数据如下：（只是其中的一部分数据）

在界面上要求显示的效果如下：

单击上一条、下一条、第一条和最后一条的按钮，或者任意输入一个数值，文本框和DataGrid就会显示想应的记录。

怎样实现呢？可以分两步完成：

1. 因为导航条

在每个页面都有，所以先来制作一个自定义控件吧。

2. 将数据绑定到文本框和DataGrid

在解决方案中添加一个windows应用程序，如图所示：

在UserControl.cs中添加控件，如图所示：

在.cs文件中添加各个按钮的委托和事件：

publicdelegate void zuiqian();

public delegate void xiangqian();

public delegate void zuihou();

public delegate void xianghou();

public delegate void total();

public event zuiqian zq;

public event xiangqian xq;

public event zuihou zh;

public event xianghou xh;

publicevent total tl;

privatevoid zuiqianBt_Click(object sender, System.EventArgs e)

{

if(zq!=null)

zq();

}

private void qianBt_Click(object sender, System.EventArgs e)

{

if(xq!=null)

xq();

}

private void houBt_Click(object sender, System.EventArgs e)

{

if(xh!=null)

xh();

}

private void zuihouBt_Click(object sender, System.EventArgs e)

{

if(zh!=null)

zh();

}

private void totalBt_Click(object sender, System.EventArgs e)

{

if(tl!=null)

tl();

}

在解决方案下再添加一个windows应用程序，如图所示：

将zdykj/bin/Debug下的zdykj.dll加入到工具箱中，在把UserControl拖入到SortForm页面中。

SortForm.cs文件的代码如下：（蓝色为重点）

using System;

using System.IO;

using System.Drawing;

using System.Collections;

using System.ComponentModel;

using System.Windows.Forms;

using System.Data;

using System.Data.SqlClient;

namespace SellManage

{

///<summary>

/// SortForm 的摘要说明。

///</summary>

public class SortForm : System.Windows.Forms.Form

{

sqlDB sqldb = new sqlDB();

private DataSet ds;

private System.Windows.Forms.Label lm;

private System.Windows.Forms.Label sm;

private zdykj.UserControl UserCon;

private System.Windows.Forms.DataGrid SortDataGird;

private System.Windows.Forms.DataGridTableStyle dataGridTableStyle1;

private System.Windows.Forms.DataGridTextBoxColumn dataGridTextBoxColumn1;

private System.Windows.Forms.TextBox NameTb;

private System.Windows.Forms.TextBox ExplainTb;

private System.ComponentModel.Container components = null;

public SortForm()

{

InitializeComponent();

}

///<summary>

///清理所有正在使用的资源。

///</summary>

protected override void Dispose( bool disposing )

{

if( disposing )

{

if(components != null)

{

components.Dispose();

}

base.Dispose( disposing );

}

#region Windows 窗体设计器生成的代码

///<summary>

///设计器支持所需的方法 - 不要使用代码编辑器修改

///此方法的内容。

///</summary>

private void InitializeComponent()

{

this.lm = new System.Windows.Forms.Label();

this.sm = new System.Windows.Forms.Label();

this.NameTb = new System.Windows.Forms.TextBox();

this.ExplainTb = new System.Windows.Forms.TextBox();

this.SortDataGird = new System.Windows.Forms.DataGrid();

this.dataGridTableStyle1 = new System.Windows.Forms.DataGridTableStyle();

this.dataGridTextBoxColumn1 = new System.Windows.Forms.DataGridTextBoxColumn();

this.UserCon = new zdykj.UserControl();

((System.ComponentModel.ISupportInitialize)(this.SortDataGird)).BeginInit();

this.SuspendLayout();

// lm

this.lm.Location = new System.Drawing.Point(8, 24);

this.lm.Name = "lm";

this.lm.Size = new System.Drawing.Size(86, 30);

this.lm.TabIndex = 0;

this.lm.Text = "类别名称:";

// sm

this.sm.Location = new System.Drawing.Point(8, 64);

this.sm.Name = "sm";

this.sm.Size = new System.Drawing.Size(86, 29);

this.sm.TabIndex = 2;

this.sm.Text = "说明:";

// NameTb

this.NameTb.Location = new System.Drawing.Point(104, 24);

this.NameTb.Name = "NameTb";

this.NameTb.Size = new System.Drawing.Size(400, 25);

this.NameTb.TabIndex = 4;

this.NameTb.Text = "";

// ExplainTb

this.ExplainTb.Location = new System.Drawing.Point(104, 64);

this.ExplainTb.Multiline = true;

this.ExplainTb.Name = "ExplainTb";

this.ExplainTb.Size = new System.Drawing.Size(400, 41);

this.ExplainTb.TabIndex = 5;

this.ExplainTb.Text = "";

// SortDataGird

this.SortDataGird.AlternatingBackColor = System.Drawing.Color.White;

this.SortDataGird.BackColor = System.Drawing.Color.White;

this.SortDataGird.BackgroundColor = System.Drawing.Color.Gainsboro;

this.SortDataGird.BorderStyle = System.Windows.Forms.BorderStyle.FixedSingle;

this.SortDataGird.CaptionBackColor = System.Drawing.Color.Silver;

this.SortDataGird.CaptionFont = new System.Drawing.Font("Courier New", 10F, System.Drawing.FontStyle.Bold);

this.SortDataGird.CaptionForeColor = System.Drawing.Color.Black;

this.SortDataGird.CaptionText = "类别所对应的产品";

this.SortDataGird.DataMember = "";

this.SortDataGird.FlatMode = true;

this.SortDataGird.Font = new System.Drawing.Font("Courier New", 9F);

this.SortDataGird.ForeColor = System.Drawing.Color.DarkSlateGray;

this.SortDataGird.GridLineColor = System.Drawing.Color.DarkGray;

this.SortDataGird.HeaderBackColor = System.Drawing.Color.DarkGreen;

this.SortDataGird.HeaderFont = new System.Drawing.Font("Courier New", 10F, System.Drawing.FontStyle.Bold);

this.SortDataGird.HeaderForeColor = System.Drawing.Color.White;

this.SortDataGird.LinkColor = System.Drawing.Color.DarkGreen;

this.SortDataGird.Location = new System.Drawing.Point(16, 120);

this.SortDataGird.Name = "SortDataGird";

this.SortDataGird.ParentRowsBackColor = System.Drawing.Color.Gainsboro;

this.SortDataGird.ParentRowsForeColor = System.Drawing.Color.Black;

this.SortDataGird.SelectionBackColor = System.Drawing.Color.DarkSeaGreen;

this.SortDataGird.SelectionForeColor = System.Drawing.Color.Black;

this.SortDataGird.Size = new System.Drawing.Size(488, 360);

this.SortDataGird.TabIndex = 7;

this.SortDataGird.TableStyles.AddRange(new System.Windows.Forms.DataGridTableStyle[] {

this.dataGridTableStyle1});

// dataGridTableStyle1

this.dataGridTableStyle1.DataGrid = this.SortDataGird;

this.dataGridTableStyle1.GridColumnStyles.AddRange(new System.Windows.Forms.DataGridColumnStyle[] {

this.dataGridTextBoxColumn1});

this.dataGridTableStyle1.HeaderForeColor = System.Drawing.SystemColors.ControlText;

this.dataGridTableStyle1.MappingName = "";

// dataGridTextBoxColumn1

this.dataGridTextBoxColumn1.Format = "";

this.dataGridTextBoxColumn1.FormatInfo = null;

this.dataGridTextBoxColumn1.HeaderText = "aaaa";

this.dataGridTextBoxColumn1.MappingName = "";

this.dataGridTextBoxColumn1.Width = 75;

// UserCon

this.UserCon.Location = new System.Drawing.Point(8, 504);

this.UserCon.Name = "UserCon";

this.UserCon.Size = new System.Drawing.Size(544, 52);

this.UserCon.TabIndex = 8;

this.UserCon.Load += new System.EventHandler(this.UserCon_Load);

// SortForm

this.AutoScaleBaseSize = new System.Drawing.Size(8, 18);

this.ClientSize = new System.Drawing.Size(568, 560);

this.Controls.Add(this.UserCon);

this.Controls.Add(this.SortDataGird);

this.Controls.Add(this.ExplainTb);

this.Controls.Add(this.NameTb);

this.Controls.Add(this.sm);

this.Controls.Add(this.lm);

this.Name = "SortForm";

this.Text = "类别";

this.Load += new System.EventHandler(this.SortForm_Load);

((System.ComponentModel.ISupportInitialize)(this.SortDataGird)).EndInit();

this.ResumeLayout(false);

}

#endregion

//页面初始化

private void SortForm_Load(object sender, System.EventArgs e)

{

try

{

string sqlCom = "select * from 类别";

//得到返回的DataSet

ds = sqldb.ds(sqlCom,"sort");

//绑定“类别名称”文本框

NameTb.DataBindings.Add("Text",ds.Tables["sort"],"类别名称");

//绑定“说明”文本框

ExplainTb.DataBindings.Add("Text",ds.Tables["sort"],"说明");

//文本框显示为“1”

UserCon.nuTb.Text = Convert.ToString(1);

//获得总行数

int count = ds.Tables["sort"].Rows.Count;

//显示中行数

UserCon.nulabel.Text = count.ToString();

string liebieName = NameTb.Text.Trim();

//在DataGrid中显示第一条的类别信息

dataGridShou(liebieName);

}

catch(Exception ex)

{

MessageBox.Show(ex.Message);

}

//自定义控件的页面初始化

private void UserCon_Load(object sender, System.EventArgs e)

{

UserCon.zq +=new zdykj.UserControl.zuiqian(this.inzq);

UserCon.xq += new zdykj.UserControl.xiangqian(this.inxq);

UserCon.xh +=new zdykj.UserControl.xianghou(this.inxh);

UserCon.zh +=new zdykj.UserControl.zuihou(this.inzh);

UserCon.tl +=new zdykj.UserControl.total(this.intl);

UserCon.nuTb.Text = Convert.ToString(1);

}

//实现“第一条”功能。

public void inzq()

{

int z = 0;

//文本框显示为“1”

UserCon.nuTb.Text = (z +1).ToString();

//绑定“类别名称”文本框（DataTable中第1行第1列）

NameTb.Text = ds.Tables["sort"].Rows[z][1].ToString();

//绑定“说明”文本框（DataTable中第1行第2列）

ExplainTb.Text = ds.Tables["sort"].Rows[z][2].ToString();

//获得“类别名称”（DataTable中第1行第1列）

string liebieName = NameTb.Text.Trim();

//在DataGrid中显示第1个类别信息

dataGridShou(liebieName);

}

//实现“上一条”功能。

public void inxq()

{

//判断当前条是否是第一条

if(UserCon.nuTb.Text == Convert.ToString(1))

{

MessageBox.Show("已经到最前了");

}

else

{

//获得导航条中文本框中的文本

string nuTb = UserCon.nuTb.Text;

//如果文本框中是“5”，上一条就应该是“4”，在 DataTable中对应的就是“3”了，所以得减2.

int z = Convert.ToInt32(nuTb)-2;

//指向DataTable中第“3”行的数据

this.BindingContext[ds,"sort"].Position = z;

//在文本框中显示“4”

UserCon.nuTb.Text = (z+1).ToString();

//绑定“类别名称”文本框（DataTable中第“3”行第1列）

NameTb.Text = ds.Tables["sort"].Rows[z][1].ToString();

//绑定“说明”文本框（DataTable中第“3”行第2列）

ExplainTb.Text = ds.Tables["sort"].Rows[z][2].ToString();

//获得“类别名称”（DataTable中第“3”行第1列）

string liebieName = NameTb.Text.Trim();

//在DataGrid中显示第3个类别信息

dataGridShou(liebieName);

}

//实现“下一条”功能。

public void inxh()

{

//判断是否是最后一条

if(UserCon.nuTb.Text == this.BindingContext[ds,"sort"].Count.ToString())

{

MessageBox.Show("已经到最后了");

}

else

{

string nuTb = UserCon.nuTb.Text;

//如果文本框中是“5”，下一条就应该是“6”，在 DataTable中对应还是“5”，所以z不用加减。

int z = Convert.ToInt32(nuTb);

this.BindingContext[ds,"sort"].Position = z;

NameTb.Text = ds.Tables["sort"].Rows[z][1].ToString();

ExplainTb.Text = ds.Tables["sort"].Rows[z][2].ToString();

UserCon.nuTb.Text = (z +1).ToString();

string liebieName = NameTb.Text.Trim();

dataGridShou(liebieName);

}

//实现“最后一条”功能。

public void inzh()

{

int z =this.BindingContext[ds,"sort"].Count-1;

UserCon.nuTb.Text = (z +1).ToString();

NameTb.Text = ds.Tables["sort"].Rows[z][1].ToString();

ExplainTb.Text = ds.Tables["sort"].Rows[z][2].ToString();

string liebieName = NameTb.Text.Trim();

dataGridShou(liebieName);

}

//实现跳转功能。

public void intl()

{

string nuTb = UserCon.nuTb.Text;

//如果文本框中是“5”，指向DataTable中第“4”行的数据，所以减1

int z = Convert.ToInt32(nuTb)-1;

this.BindingContext[ds,"sort"].Position = z;

NameTb.Text = ds.Tables["sort"].Rows[z][1].ToString();

ExplainTb.Text = ds.Tables["sort"].Rows[z][2].ToString();

string liebieName = NameTb.Text.Trim();

dataGridShou(liebieName);

}

//在SortDataGird中显示产品的信息，liebieName为类别名称

private void dataGridShou(string liebieName)

{

string sqlCom = "SELECT distinct 产品.产品名称, 产品.单位数量, 产品.单价, case 产品.中止 when 0 then '否' when 1 then '是' end as 中止 FROM 类别,产品 where 产品.类别ID = (select 类别.类别ID from 类别 where 类别名称 = '" + liebieName + "')";

ds = sqldb.ds(sqlCom,"lchanpin");

SortDataGird.DataSource = ds.Tables["lchanpin"];

}

sqlDB.cs文件如下：

using System;

using System.Collections;

using System.Configuration;

using System.Data;

using System.Data.SqlClient;

using System.Text;

using System.Windows.Forms;

namespace SellManage