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

zhaoxiaoyang5156

于 2007-08-09 20:39:00 发布

阅读量580

点赞数

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

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

版权

数据库见：ado.net c#.net2005 From第一讲（BindingDemoForm2）

运行界面：

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 BindingDemoForm9 : Form

{

public BindingDemoForm9()

{

InitializeComponent();

}

// 資料集物件的類別層級建立

DataSet ds = new DataSet();

// CurrencyManager 物件的類別層級宣告

BindingManagerBase bmFoxStudio;

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

{

// 設定表單的最小大小

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

// 建立一個連接字串

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

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

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

// 建立一個資料連接

SqlConnection myConnection = new SqlConnection(strConnection);

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

SqlDataAdapter myAD = new SqlDataAdapter(strSql, myConnection);

// 將資料填入資料集

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

// 將 ComboBox 控制項繫結至資料集 ds 中的「飛狐工作室」資料表

ComboBoxName.DataSource = ds.Tables["飛狐工作室"];

ComboBoxName.DisplayMember = "姓名";

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

TextBoxID.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, "飛狐工作室.自傳");

// 取得代表「飛狐工作室」資料表的 CurrencyManager 物件

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

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

bmFoxStudio.PositionChanged += 飛狐工作室_PositionChanged;

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

TextBoxPosition.Text = string.Format("資料記錄:目前位置 {0} 總數 {1}", bmFoxStudio.Position + 1, bmFoxStudio.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 ComboBoxName_SelectedIndexChanged(object sender, System.EventArgs e)

{

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

}

窗体代码：

namespace ch1

{

partial class BindingDemoForm9

{

/// <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.TextBoxPosition = new System.Windows.Forms.TextBox();

this.ComboBoxName = new System.Windows.Forms.ComboBox();

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

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.TextBoxID = new System.Windows.Forms.TextBox();

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

this.SuspendLayout();

// 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(87, 345);

this.TextBoxPosition.Name = "TextBoxPosition";

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

this.TextBoxPosition.TabIndex = 74;

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

// ComboBoxName

this.ComboBoxName.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDownList;

this.ComboBoxName.Items.AddRange(new object[] {

"0"});

this.ComboBoxName.Location = new System.Drawing.Point(292, 58);

this.ComboBoxName.Name = "ComboBoxName";

this.ComboBoxName.Size = new System.Drawing.Size(152, 20);

this.ComboBoxName.TabIndex = 73;

this.ComboBoxName.SelectedIndexChanged += new System.EventHandler(this.ComboBoxName_SelectedIndexChanged);

// 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(86, 21);

this.lblHeader.Name = "lblHeader";

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

this.lblHeader.TabIndex = 72;

this.lblHeader.Text = "使用 ComboBox 控制項導覽資料記錄";

// NumericUpDownSalary

this.NumericUpDownSalary.DecimalPlaces = 2;

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

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 = 67;

this.NumericUpDownSalary.ThousandsSeparator = true;

// lblContent

this.lblContent.AutoSize = true;

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

this.lblContent.Name = "lblContent";

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

this.lblContent.TabIndex = 70;

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

// TextBoxContent

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

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

this.TextBoxContent.Multiline = true;

this.TextBoxContent.Name = "TextBoxContent";

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

this.TextBoxContent.Size = new System.Drawing.Size(429, 89);

this.TextBoxContent.TabIndex = 71;

// DateTimePickerBirthday

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

this.DateTimePickerBirthday.Name = "DateTimePickerBirthday";

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

this.DateTimePickerBirthday.TabIndex = 65;

// CheckBoxGender

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

this.CheckBoxGender.Name = "CheckBoxGender";

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

this.CheckBoxGender.TabIndex = 61;

// lblDepartment

this.lblDepartment.AutoSize = true;

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

this.lblDepartment.Name = "lblDepartment";

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

this.lblDepartment.TabIndex = 68;

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

// lblSalary

this.lblSalary.AutoSize = true;

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

this.lblSalary.Name = "lblSalary";

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

this.lblSalary.TabIndex = 66;

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

// lblBirthday

this.lblBirthday.AutoSize = true;

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

this.lblBirthday.Name = "lblBirthday";

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

this.lblBirthday.TabIndex = 64;

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

// lblAddress

this.lblAddress.AutoSize = true;

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

this.lblAddress.Name = "lblAddress";

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

this.lblAddress.TabIndex = 62;

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

// Label1

this.Label1.AutoSize = true;

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

this.Label1.Name = "Label1";

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

this.Label1.TabIndex = 60;

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

// lblName

this.lblName.AutoSize = true;

this.lblName.Location = new System.Drawing.Point(63, 60);

this.lblName.Name = "lblName";

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

this.lblName.TabIndex = 59;

this.lblName.Text = "請選取您所要檢視之員工的姓名:";

// lblID

this.lblID.AutoSize = true;

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

this.lblID.Name = "lblID";

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

this.lblID.TabIndex = 57;

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

// TextBoxDepartment

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

this.TextBoxDepartment.Name = "TextBoxDepartment";

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

this.TextBoxDepartment.TabIndex = 69;

// TextBoxAddress

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

this.TextBoxAddress.Name = "TextBoxAddress";

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

this.TextBoxAddress.TabIndex = 63;

// TextBoxID

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

this.TextBoxID.Name = "TextBoxID";

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

this.TextBoxID.TabIndex = 58;

// BindingDemoForm9

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

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

this.ClientSize = new System.Drawing.Size(551, 423);

this.Controls.Add(this.TextBoxPosition);

this.Controls.Add(this.ComboBoxName);

this.Controls.Add(this.lblHeader);

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.TextBoxID);

this.Name = "BindingDemoForm9";

this.Text = "BindingDemoForm9";

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

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

this.ResumeLayout(false);

this.PerformLayout();

}

#endregion

internal System.Windows.Forms.TextBox TextBoxPosition;

internal System.Windows.Forms.ComboBox ComboBoxName;

internal System.Windows.Forms.Label lblHeader;

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 TextBoxID;

}

zhaoxiaoyang5156

关注

0
点赞
踩
0

收藏

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

数据库见：ado.net c#.net2005 From第一讲（BindingDemoForm2）运行界面： cs代码：using System;using System.Collections.Generic;using System.ComponentModel;using System.Data;using System.Drawing;using System.Te
复制链接

扫一扫