数据集的使用实例
using System;
using System.Drawing;
using System.Collections;
using System.ComponentModel;
using System.Windows.Forms;
using System.Data;
using System.Data.SqlClient;
namespace HomeWorkTwoPrj
{
public class Form1 : System.Windows.Forms.Form
{
private System.Windows.Forms.Label label1;
private System.Windows.Forms.Label label2;
private System.Windows.Forms.Label label3;
private System.Windows.Forms.Label label4;
private System.Windows.Forms.Label label5;
private System.Windows.Forms.Label label6;
private System.Windows.Forms.TextBox textBox1;
private System.Windows.Forms.TextBox textBox2;
private System.Windows.Forms.TextBox textBox3;
private System.Windows.Forms.TextBox textBox4;
private System.Windows.Forms.TextBox textBox5;
private System.Windows.Forms.Button btnFirst;
private System.Windows.Forms.Button btnLast;
private System.Windows.Forms.Button btnUp;
private System.Windows.Forms.Button btnDown;
private System.ComponentModel.Container components = null;
//
SqlConnection cn = null;
DataSet ds = null;
int temp = 0;
public Form1()
{
InitializeComponent();
//
// TODO: 在 InitializeComponent 调用后添加任何构造函数代码
//
}
/// <summary>
/// 清理所有正在使用的资源。
/// </summary>
protected override void Dispose(bool disposing)
{
if (disposing)
{
if (components != null)
{
components.Dispose();
}
}
base.Dispose(disposing);
}
#region Windows 窗体代码
// </summary>
private void InitializeComponent()
{
this.label1 = new System.Windows.Forms.Label();
this.label2 = new System.Windows.Forms.Label();
this.label3 = new System.Windows.Forms.Label();
this.label4 = new System.Windows.Forms.Label();
this.label5 = new System.Windows.Forms.Label();
this.label6 = new System.Windows.Forms.Label();
this.textBox1 = new System.Windows.Forms.TextBox();
this.textBox2 = new System.Windows.Forms.TextBox();
this.textBox3 = new System.Windows.Forms.TextBox();
this.textBox4 = new System.Windows.Forms.TextBox();
this.textBox5 = new System.Windows.Forms.TextBox();
this.btnFirst = new System.Windows.Forms.Button();
this.btnDown = new System.Windows.Forms.Button();
this.btnLast = new System.Windows.Forms.Button();
this.btnUp = new System.Windows.Forms.Button();
this.SuspendLayout();
//
// label1
//
this.label1.Font = new System.Drawing.Font("宋体", 14.25F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134)));
this.label1.Location = new System.Drawing.Point(72, 32);
this.label1.Name = "label1";
this.label1.Size = new System.Drawing.Size(184, 23);
this.label1.TabIndex = 0;
this.label1.Text = "显示员工信息";
this.label1.TextAlign = System.Drawing.ContentAlignment.MiddleCenter;
//
// label2
//
this.label2.Location = new System.Drawing.Point(24, 72);
this.label2.Name = "label2";
this.label2.TabIndex = 1;
this.label2.Text = "员工编号：";
this.label2.TextAlign = System.Drawing.ContentAlignment.MiddleCenter;
//
// label3
//
this.label3.Location = new System.Drawing.Point(24, 112);
this.label3.Name = "label3";
this.label3.TabIndex = 2;
this.label3.Text = "员工姓名：";
this.label3.TextAlign = System.Drawing.ContentAlignment.MiddleCenter;
//
// label4
//
this.label4.Location = new System.Drawing.Point(24, 152);
this.label4.Name = "label4";
this.label4.TabIndex = 3;
this.label4.Text = "员工性别：";
this.label4.TextAlign = System.Drawing.ContentAlignment.MiddleCenter;
//
// label5
//
this.label5.Location = new System.Drawing.Point(24, 192);
this.label5.Name = "label5";
this.label5.TabIndex = 4;
this.label5.Text = "公司名称：";
this.label5.TextAlign = System.Drawing.ContentAlignment.MiddleCenter;
//
// label6
//
this.label6.Location = new System.Drawing.Point(24, 232);
this.label6.Name = "label6";
this.label6.TabIndex = 5;
this.label6.Text = "联系地址：";
this.label6.TextAlign = System.Drawing.ContentAlignment.MiddleCenter;
//
// textBox1
//
this.textBox1.Location = new System.Drawing.Point(128, 72);
this.textBox1.Name = "textBox1";
this.textBox1.Size = new System.Drawing.Size(144, 21);
this.textBox1.TabIndex = 6;
this.textBox1.Text = "";
//
// textBox2
//
this.textBox2.Location = new System.Drawing.Point(128, 112);
this.textBox2.Name = "textBox2";
this.textBox2.Size = new System.Drawing.Size(144, 21);
this.textBox2.TabIndex = 7;
this.textBox2.Text = "";
//
// textBox3
//
this.textBox3.Location = new System.Drawing.Point(128, 152);
this.textBox3.Name = "textBox3";
this.textBox3.Size = new System.Drawing.Size(144, 21);
this.textBox3.TabIndex = 8;
this.textBox3.Text = "";
//
// textBox4
//
this.textBox4.Location = new System.Drawing.Point(128, 192);
this.textBox4.Name = "textBox4";
this.textBox4.Size = new System.Drawing.Size(144, 21);
this.textBox4.TabIndex = 9;
this.textBox4.Text = "";
//
// textBox5
//
this.textBox5.Location = new System.Drawing.Point(128, 232);
this.textBox5.Name = "textBox5";
this.textBox5.Size = new System.Drawing.Size(144, 21);
this.textBox5.TabIndex = 10;
this.textBox5.Text = "";
//
// btnFirst
//
this.btnFirst.Location = new System.Drawing.Point(40, 272);
this.btnFirst.Name = "btnFirst";
this.btnFirst.TabIndex = 11;
this.btnFirst.Text = "首条数据";
this.btnFirst.Click += new System.EventHandler(this.btnFirst_Click);
//
// btnDown
//
this.btnDown.Location = new System.Drawing.Point(200, 272);
this.btnDown.Name = "btnDown";
this.btnDown.TabIndex = 12;
this.btnDown.Text = "下一条";
this.btnDown.Click += new System.EventHandler(this.btnDown_Click);
//
// btnLast
//
this.btnLast.Location = new System.Drawing.Point(40, 312);
this.btnLast.Name = "btnLast";
this.btnLast.TabIndex = 11;
this.btnLast.Text = "末条数据";
this.btnLast.Click += new System.EventHandler(this.btnLast_Click);
//
// btnUp
//
this.btnUp.Location = new System.Drawing.Point(200, 312);
this.btnUp.Name = "btnUp";
this.btnUp.TabIndex = 12;
this.btnUp.Text = "上一条";
this.btnUp.Click += new System.EventHandler(this.btnUp_Click);
//
// Form1
//
this.AutoScaleBaseSize = new System.Drawing.Size(6, 14);
this.ClientSize = new System.Drawing.Size(328, 358);
this.Controls.Add(this.btnDown);
this.Controls.Add(this.btnFirst);
this.Controls.Add(this.textBox5);
this.Controls.Add(this.textBox4);
this.Controls.Add(this.textBox3);
this.Controls.Add(this.textBox2);
this.Controls.Add(this.textBox1);
this.Controls.Add(this.label6);
this.Controls.Add(this.label5);
this.Controls.Add(this.label4);
this.Controls.Add(this.label3);
this.Controls.Add(this.label2);
this.Controls.Add(this.label1);
this.Controls.Add(this.btnLast);
this.Controls.Add(this.btnUp);
this.Name = "Form1";
this.Text = "随风飘逸";
this.Load += new System.EventHandler(this.Form1_Load);
this.ResumeLayout(false);
}
#endregion
/// <summary>
/// 应用程序的主入口点。
/// </summary>
[STAThread]
static void Main()
{
Application.Run(new Form1());
}
private void Form1_Load(object sender, System.EventArgs e)
{
//禁用文本框
this.textBox1.ReadOnly = true;
this.textBox2.ReadOnly = true;
this.textBox3.ReadOnly = true;
this.textBox4.ReadOnly = true;
this.textBox5.ReadOnly = true;
//初始化连接
cn = new SqlConnection("server = localhost;database = StudentDB;uid = sa;pwd =");
//
ds = new DataSet();
//
SqlDataAdapter sda = new SqlDataAdapter("select * from student", cn);
//填充数据集
sda.Fill(ds, "stu");
}
//首条数据按钮的事件
private void btnFirst_Click(object sender, System.EventArgs e)
{
//清空
this.textBox1.Clear();
this.textBox2.Clear();
this.textBox3.Clear();
this.textBox4.Clear();
this.textBox5.Clear();
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
if (i == 0)
{
//绑定数据集
this.textBox1.Text = ds.Tables[0].Rows[i][0].ToString();
this.textBox2.Text = ds.Tables[0].Rows[i][1].ToString();
this.textBox3.Text = ds.Tables[0].Rows[i][2].ToString();
this.textBox4.Text = ds.Tables[0].Rows[i][3].ToString();
this.textBox5.Text = ds.Tables[0].Rows[i][4].ToString();
}
}
}
//末条数据按钮的事件
private void btnLast_Click(object sender, System.EventArgs e)
{
//清空
this.textBox1.Clear();
this.textBox2.Clear();
this.textBox3.Clear();
this.textBox4.Clear();
this.textBox5.Clear();
for (int i = 0; i <= ds.Tables[0].Rows.Count; i++)
{
if (i == ds.Tables[0].Rows.Count - 1)
{
//绑定数据集
this.textBox1.Text = ds.Tables[0].Rows[i][0].ToString();
this.textBox2.Text = ds.Tables[0].Rows[i][1].ToString();
this.textBox3.Text = ds.Tables[0].Rows[i][2].ToString();
this.textBox4.Text = ds.Tables[0].Rows[i][3].ToString();
this.textBox5.Text = ds.Tables[0].Rows[i][4].ToString();
}
}
}
//下一条记录按钮的事件
private void btnDown_Click(object sender, System.EventArgs e)
{
//通过下标做相应的判断
if (this.temp < ds.Tables[0].Rows.Count - 1)
{
this.temp++;
}
else
{
// MessageBox.Show("数据集内已经没有数据拉！");
// //如果已经把数据读完，将给下标服赋初值，从头开始
// this.temp = 0;
return;
}
//清空
this.textBox1.Clear();
this.textBox2.Clear();
this.textBox3.Clear();
this.textBox4.Clear();
this.textBox5.Clear();
//绑定数据集
this.textBox1.Text = ds.Tables[0].Rows[temp][0].ToString();
this.textBox2.Text = ds.Tables[0].Rows[temp][1].ToString();
this.textBox3.Text = ds.Tables[0].Rows[temp][2].ToString();
this.textBox4.Text = ds.Tables[0].Rows[temp][3].ToString();
this.textBox5.Text = ds.Tables[0].Rows[temp][4].ToString();
}
//上条数据按钮的事件
private void btnUp_Click(object sender, System.EventArgs e)
{
//判断
if (this.temp > 0)
{
this.temp--;
}
//清空
this.textBox1.Clear();
this.textBox2.Clear();
this.textBox3.Clear();
this.textBox4.Clear();
this.textBox5.Clear();
//绑定数据集
this.textBox1.Text = ds.Tables[0].Rows[temp][0].ToString();
this.textBox2.Text = ds.Tables[0].Rows[temp][1].ToString();
this.textBox3.Text = ds.Tables[0].Rows[temp][2].ToString();
this.textBox4.Text = ds.Tables[0].Rows[temp][3].ToString();
this.textBox5.Text = ds.Tables[0].Rows[temp][4].ToString();
}
}
}
