ado.net c#.net2005 From第一讲（BindingDemoForm3）

最新推荐文章于 2007-08-09 21:25:00 发布

zhaoxiaoyang5156

最新推荐文章于 2007-08-09 21:25:00 发布

阅读量498

点赞数

文章标签：工作 textbox object byte string dataset

本文链接：https://blog.csdn.net/zhaoxiaoyang5156/article/details/1723235

版权

创建数据库：

请见：ado.net c#.net2005 From第一讲（BindingDemoForm2）

运行界面：

BindingDemoForm3.cs

using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.Text;

using System.Windows.Forms;

using System.Data.SqlClient;

namespace ch1

{

public partial class BindingDemoForm3 : Form

{

public BindingDemoForm3()

{

InitializeComponent();

}

DataSet ds = new DataSet();

private void BindingDemoForm3_Load(object sender, EventArgs e)

{

// 設定表單的最小大小

this.MinimumSize = new Size(512, 542);

// 建立一個連接字串

string strConnection = "Server=(local);Database=ch1;uid=sa;pwd=";

// 建立一個查詢命令字串

string strSql = "SELECT 身份證字號,姓名,員工性別,住家地址,出生日期,目前薪資,部門,自傳 FROM 飛狐工作室";

// 建立一個資料連接

SqlConnection myConnection = new SqlConnection(strConnection);

// 建立一個資料配接器以便針對資料來源執行 SELECT 陳述式來提取出要填入資料集的資料記錄

SqlDataAdapter myCommand = new SqlDataAdapter(strSql, myConnection);

// 將資料填入資料集

myCommand.Fill(ds, "飛狐工作室");

// 將 TextBox 控制項的 Text 屬性繫結至資料集 ds 內之「飛狐工作室」資料表的「身份證字號」欄位

TextBoxID.DataBindings.Add("Text", ds, "飛狐工作室.身份證字號");

// 將 TextBox 控制項的 Text 屬性繫結至資料集 ds 內之「飛狐工作室」資料表的「姓名」欄位

TextBoxName.DataBindings.Add("Text", ds, "飛狐工作室.姓名");

// 將 CheckBox 控制項的 Checked 屬性繫結至資料集 ds 內之「飛狐工作室」資料表的「員工性別」欄位

CheckBoxGender.DataBindings.Add("Checked", ds, "飛狐工作室.員工性別");

// 將 TextBox 控制項的 Text 屬性繫結至資料集 ds 內之「飛狐工作室」資料表的「住家地址」欄位

TextBoxAddress.DataBindings.Add("Text", ds, "飛狐工作室.住家地址");

// 將 DateTimePicker 控制項的 Value 屬性繫結至資料集 ds 內之「飛狐工作室」資料表的「出生日期」欄位

DateTimePickerBirthday.DataBindings.Add("Value", ds, "飛狐工作室.出生日期");

// 將 NumericUpDown 控制項的 Value 屬性繫結至資料集 ds 內之「飛狐工作室」資料表的「目前薪資」欄位

NumericUpDownSalary.DataBindings.Add("Value", ds, "飛狐工作室.目前薪資");

// 將 TextBox 控制項的 Text 屬性繫結至資料集 ds 內之「飛狐工作室」資料表的「部門」欄位

TextBoxDepartment.DataBindings.Add("Text", ds, "飛狐工作室.部門");

// 將 TextBox 控制項的 Text 屬性繫結至資料集 ds 內之「飛狐工作室」資料表的「自傳」欄位

TextBoxContent.DataBindings.Add("Text", ds, "飛狐工作室.自傳");

// 設定當引發 PositionChanged 事件時便執行事件處理常式飛狐工作室_PositionChanged

this.BindingContext[ds, "飛狐工作室"].PositionChanged += 飛狐工作室_PositionChanged;

// 設定資料記錄目前位置訊息的初值

TextBoxPosition.Text = string.Format("資料記錄:目前位置 {0} 總數 {1}", this.BindingContext[ds, "飛狐工作室"].Position + 1, this.BindingContext[ds, "飛狐工作室"].Count);

// 關閉對資料庫的連接

myConnection.Close();

}

protected void 飛狐工作室_PositionChanged(object sender, System.EventArgs e)

{

TextBoxPosition.Text = string.Format("資料記錄:目前位置 {0} 總數 {1}", this.BindingContext[ds, "飛狐工作室"].Position + 1, this.BindingContext[ds, "飛狐工作室"].Count);

}

// 按下「第一筆」按鈕

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

{

// 將 Position 屬性設定成 0

this.BindingContext[ds, "飛狐工作室"].Position = 0;

}

// 按下「上一筆」按鈕

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

{

if (this.BindingContext[ds, "飛狐工作室"].Position > 0)

{

// 將 Position 屬性遞減 1

this.BindingContext[ds, "飛狐工作室"].Position -= 1;

}

// 按下「下一筆」按鈕

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

{

if (this.BindingContext[ds, "飛狐工作室"].Position < this.BindingContext[ds, "飛狐工作室"].Count - 1)

{

// 將 Position 屬性遞增 1

this.BindingContext[ds, "飛狐工作室"].Position += 1;

}

// 按下「最後一筆」按鈕

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

{

this.BindingContext[ds, "飛狐工作室"].Position = this.BindingContext[ds, "飛狐工作室"].Count - 1;

}

BindingDemoForm3.Designer.cs

namespace ch1

{

partial class BindingDemoForm3

{

/// <summary>

/// 必需的设计器变量。

/// </summary>

private System.ComponentModel.IContainer components = null;

/// <summary>

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

/// </summary>

/// <param name="disposing">如果应释放托管资源，为 true；否则为 false。</param>

protected override void Dispose(bool disposing)

{

if (disposing && (components != null))

{

components.Dispose();

}

base.Dispose(disposing);

}

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

/// <summary>

/// 设计器支持所需的方法 - 不要

/// 使用代码编辑器修改此方法的内容。

/// </summary>

private void InitializeComponent()

{

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

this.btnEnd = new System.Windows.Forms.Button();

this.btnNext = new System.Windows.Forms.Button();

this.btnBack = new System.Windows.Forms.Button();

this.btnFirst = new System.Windows.Forms.Button();

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

this.NumericUpDownSalary = new System.Windows.Forms.NumericUpDown();

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

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

this.DateTimePickerBirthday = new System.Windows.Forms.DateTimePicker();

this.CheckBoxGender = new System.Windows.Forms.CheckBox();

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

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

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

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

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

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

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

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

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

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

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

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

this.SuspendLayout();

// lblHeader

this.lblHeader.AutoSize = true;

this.lblHeader.Font = new System.Drawing.Font("PMingLiU", 12F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(136)));

this.lblHeader.ForeColor = System.Drawing.Color.Red;

this.lblHeader.Location = new System.Drawing.Point(109, 14);

this.lblHeader.Name = "lblHeader";

this.lblHeader.Size = new System.Drawing.Size(183, 16);

this.lblHeader.TabIndex = 59;

this.lblHeader.Text = "資料導覽介面---逐筆檢視";

// btnEnd

this.btnEnd.Location = new System.Drawing.Point(315, 368);

this.btnEnd.Name = "btnEnd";

this.btnEnd.Size = new System.Drawing.Size(75, 21);

this.btnEnd.TabIndex = 58;

this.btnEnd.Text = "最後一筆";

this.btnEnd.Click += new System.EventHandler(this.btnEnd_Click);

// btnNext

this.btnNext.Location = new System.Drawing.Point(226, 368);

this.btnNext.Name = "btnNext";

this.btnNext.Size = new System.Drawing.Size(75, 21);

this.btnNext.TabIndex = 57;

this.btnNext.Text = "下一筆";

this.btnNext.Click += new System.EventHandler(this.btnNext_Click);

// btnBack

this.btnBack.Location = new System.Drawing.Point(137, 368);

this.btnBack.Name = "btnBack";

this.btnBack.Size = new System.Drawing.Size(75, 21);

this.btnBack.TabIndex = 56;

this.btnBack.Text = "上一筆";

this.btnBack.Click += new System.EventHandler(this.btnBack_Click);

// btnFirst

this.btnFirst.Location = new System.Drawing.Point(48, 368);

this.btnFirst.Name = "btnFirst";

this.btnFirst.Size = new System.Drawing.Size(75, 21);

this.btnFirst.TabIndex = 55;

this.btnFirst.Text = "第一筆";

this.btnFirst.Click += new System.EventHandler(this.btnFirst_Click);

// TextBoxPosition

this.TextBoxPosition.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(255)))), ((int)(((byte)(255)))), ((int)(((byte)(192)))));

this.TextBoxPosition.ForeColor = System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(192)))));

this.TextBoxPosition.Location = new System.Drawing.Point(54, 333);

this.TextBoxPosition.Name = "TextBoxPosition";

this.TextBoxPosition.Size = new System.Drawing.Size(333, 21);

this.TextBoxPosition.TabIndex = 54;

this.TextBoxPosition.TextAlign = System.Windows.Forms.HorizontalAlignment.Center;

// NumericUpDownSalary

this.NumericUpDownSalary.DecimalPlaces = 2;

this.NumericUpDownSalary.Location = new System.Drawing.Point(105, 174);

this.NumericUpDownSalary.Maximum = new decimal(new int[] {

300000,

0});

this.NumericUpDownSalary.Name = "NumericUpDownSalary";

this.NumericUpDownSalary.Size = new System.Drawing.Size(120, 21);

this.NumericUpDownSalary.TabIndex = 49;

this.NumericUpDownSalary.ThousandsSeparator = true;

// lblContent

this.lblContent.AutoSize = true;

this.lblContent.Location = new System.Drawing.Point(57, 230);

this.lblContent.Name = "lblContent";

this.lblContent.Size = new System.Drawing.Size(35, 12);

this.lblContent.TabIndex = 52;

this.lblContent.Text = "自傳:";

// TextBoxContent

this.TextBoxContent.ForeColor = System.Drawing.Color.Blue;

this.TextBoxContent.Location = new System.Drawing.Point(105, 230);

this.TextBoxContent.Multiline = true;

this.TextBoxContent.Name = "TextBoxContent";

this.TextBoxContent.ScrollBars = System.Windows.Forms.ScrollBars.Both;

this.TextBoxContent.Size = new System.Drawing.Size(349, 88);

this.TextBoxContent.TabIndex = 53;

// DateTimePickerBirthday

this.DateTimePickerBirthday.Location = new System.Drawing.Point(105, 149);

this.DateTimePickerBirthday.Name = "DateTimePickerBirthday";

this.DateTimePickerBirthday.Size = new System.Drawing.Size(200, 21);

this.DateTimePickerBirthday.TabIndex = 47;

// CheckBoxGender

this.CheckBoxGender.Location = new System.Drawing.Point(105, 99);

this.CheckBoxGender.Name = "CheckBoxGender";

this.CheckBoxGender.Size = new System.Drawing.Size(16, 19);

this.CheckBoxGender.TabIndex = 43;

// lblDepartment

this.lblDepartment.AutoSize = true;

this.lblDepartment.Location = new System.Drawing.Point(57, 199);

this.lblDepartment.Name = "lblDepartment";

this.lblDepartment.Size = new System.Drawing.Size(35, 12);

this.lblDepartment.TabIndex = 50;

this.lblDepartment.Text = "部門:";

// lblSalary

this.lblSalary.AutoSize = true;

this.lblSalary.Location = new System.Drawing.Point(33, 174);

this.lblSalary.Name = "lblSalary";

this.lblSalary.Size = new System.Drawing.Size(59, 12);

this.lblSalary.TabIndex = 48;

this.lblSalary.Text = "目前薪資:";

// lblBirthday

this.lblBirthday.AutoSize = true;

this.lblBirthday.Location = new System.Drawing.Point(33, 149);

this.lblBirthday.Name = "lblBirthday";

this.lblBirthday.Size = new System.Drawing.Size(59, 12);

this.lblBirthday.TabIndex = 46;

this.lblBirthday.Text = "出生日期:";

// lblAddress

this.lblAddress.AutoSize = true;

this.lblAddress.Location = new System.Drawing.Point(57, 124);

this.lblAddress.Name = "lblAddress";

this.lblAddress.Size = new System.Drawing.Size(35, 12);

this.lblAddress.TabIndex = 44;

this.lblAddress.Text = "地址:";

// Label1

this.Label1.AutoSize = true;

this.Label1.Location = new System.Drawing.Point(57, 99);

this.Label1.Name = "Label1";

this.Label1.Size = new System.Drawing.Size(35, 12);

this.Label1.TabIndex = 42;

this.Label1.Text = "性別:";

// lblName

this.lblName.AutoSize = true;

this.lblName.Location = new System.Drawing.Point(57, 74);

this.lblName.Name = "lblName";

this.lblName.Size = new System.Drawing.Size(35, 12);

this.lblName.TabIndex = 40;

this.lblName.Text = "姓名:";

// lblID

this.lblID.AutoSize = true;

this.lblID.Location = new System.Drawing.Point(21, 49);

this.lblID.Name = "lblID";

this.lblID.Size = new System.Drawing.Size(71, 12);

this.lblID.TabIndex = 38;

this.lblID.Text = "身份證字號:";

// TextBoxDepartment

this.TextBoxDepartment.Location = new System.Drawing.Point(105, 199);

this.TextBoxDepartment.Name = "TextBoxDepartment";

this.TextBoxDepartment.Size = new System.Drawing.Size(100, 21);

this.TextBoxDepartment.TabIndex = 51;

// TextBoxAddress

this.TextBoxAddress.Location = new System.Drawing.Point(105, 124);

this.TextBoxAddress.Name = "TextBoxAddress";

this.TextBoxAddress.Size = new System.Drawing.Size(344, 21);

this.TextBoxAddress.TabIndex = 45;

// TextBoxName

this.TextBoxName.Location = new System.Drawing.Point(105, 74);

this.TextBoxName.Name = "TextBoxName";

this.TextBoxName.Size = new System.Drawing.Size(100, 21);

this.TextBoxName.TabIndex = 41;

// TextBoxID

this.TextBoxID.Location = new System.Drawing.Point(105, 49);

this.TextBoxID.Name = "TextBoxID";

this.TextBoxID.Size = new System.Drawing.Size(100, 21);

this.TextBoxID.TabIndex = 39;

// BindingDemoForm3

this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 12F);

this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font;

this.ClientSize = new System.Drawing.Size(485, 432);

this.Controls.Add(this.lblHeader);

this.Controls.Add(this.btnEnd);

this.Controls.Add(this.btnNext);

this.Controls.Add(this.btnBack);

this.Controls.Add(this.btnFirst);

this.Controls.Add(this.TextBoxPosition);

this.Controls.Add(this.NumericUpDownSalary);

this.Controls.Add(this.lblContent);

this.Controls.Add(this.TextBoxContent);

this.Controls.Add(this.DateTimePickerBirthday);

this.Controls.Add(this.CheckBoxGender);

this.Controls.Add(this.lblDepartment);

this.Controls.Add(this.lblSalary);

this.Controls.Add(this.lblBirthday);

this.Controls.Add(this.lblAddress);

this.Controls.Add(this.Label1);

this.Controls.Add(this.lblName);

this.Controls.Add(this.lblID);

this.Controls.Add(this.TextBoxDepartment);

this.Controls.Add(this.TextBoxAddress);

this.Controls.Add(this.TextBoxName);

this.Controls.Add(this.TextBoxID);

this.Name = "BindingDemoForm3";

this.Text = "BindingDemoForm3";

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

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

this.ResumeLayout(false);

this.PerformLayout();

}

#endregion

internal System.Windows.Forms.Label lblHeader;

internal System.Windows.Forms.Button btnEnd;

internal System.Windows.Forms.Button btnNext;

internal System.Windows.Forms.Button btnBack;

internal System.Windows.Forms.Button btnFirst;

internal System.Windows.Forms.TextBox TextBoxPosition;

internal System.Windows.Forms.NumericUpDown NumericUpDownSalary;

internal System.Windows.Forms.Label lblContent;

internal System.Windows.Forms.TextBox TextBoxContent;

internal System.Windows.Forms.DateTimePicker DateTimePickerBirthday;

internal System.Windows.Forms.CheckBox CheckBoxGender;

internal System.Windows.Forms.Label lblDepartment;

internal System.Windows.Forms.Label lblSalary;

internal System.Windows.Forms.Label lblBirthday;

internal System.Windows.Forms.Label lblAddress;

internal System.Windows.Forms.Label Label1;

internal System.Windows.Forms.Label lblName;

internal System.Windows.Forms.Label lblID;

internal System.Windows.Forms.TextBox TextBoxDepartment;

internal System.Windows.Forms.TextBox TextBoxAddress;

internal System.Windows.Forms.TextBox TextBoxName;

internal System.Windows.Forms.TextBox TextBoxID;

}

zhaoxiaoyang5156

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
ado.net c#.net2005 From第一讲（BindingDemoForm3）

创建数据库：请见：ado.net c#.net2005 From第一讲（BindingDemoForm2）运行界面： BindingDemoForm3.cs using System;using System.Collections.Generic;using System.ComponentModel;using System.Data;using System.Dr
复制链接

扫一扫