?? frmdatamanager.cs
字號:
using System;
using System.Data;
using System.Data.SqlClient;
using System.Drawing;
using System.Collections;
using System.ComponentModel;
using System.Windows.Forms;
namespace MPNumberProject
{
/// <summary>
/// frmDataManager 的摘要說明。
/// </summary>
public class frmDataManager : System.Windows.Forms.Form
{
private System.Windows.Forms.Button btnDelete;
private System.Windows.Forms.Button btnSave;
private System.Windows.Forms.Button btnClose;
/// <summary>
/// 必需的設計器變量。
/// </summary>
private System.ComponentModel.Container components = null;
private System.Windows.Forms.DataGrid dbgMessage;
DataAccess access=new DataAccess ();
private DataRow row;
private string connectionString="server=127.0.0.1;database=Mobilephone;uid=tangrong;pwd=716";
private SqlConnection conn;
private SqlDataAdapter adapter;
private System.Windows.Forms.DataGridTableStyle dataGridTableStyle1;
private System.Windows.Forms.DataGridTextBoxColumn dataGridTextBoxColumn1;
private System.Windows.Forms.DataGridTextBoxColumn dataGridTextBoxColumn2;
private System.Windows.Forms.DataGridTextBoxColumn dataGridTextBoxColumn3;
private System.Windows.Forms.DataGridTextBoxColumn dataGridTextBoxColumn4;
private DataSet dataset;
public frmDataManager()
{
//
// Windows 窗體設計器支持所必需的
//
InitializeComponent();
//
// TODO: 在 InitializeComponent 調用后添加任何構造函數代碼
//
if(conn==null)
{
conn=new SqlConnection (connectionString);
}
if(conn.State!=ConnectionState.Open)
{
conn.Open();
}
}
/// <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.dbgMessage = new System.Windows.Forms.DataGrid();
this.dataGridTableStyle1 = new System.Windows.Forms.DataGridTableStyle();
this.dataGridTextBoxColumn1 = new System.Windows.Forms.DataGridTextBoxColumn();
this.dataGridTextBoxColumn2 = new System.Windows.Forms.DataGridTextBoxColumn();
this.dataGridTextBoxColumn3 = new System.Windows.Forms.DataGridTextBoxColumn();
this.dataGridTextBoxColumn4 = new System.Windows.Forms.DataGridTextBoxColumn();
this.btnDelete = new System.Windows.Forms.Button();
this.btnSave = new System.Windows.Forms.Button();
this.btnClose = new System.Windows.Forms.Button();
((System.ComponentModel.ISupportInitialize)(this.dbgMessage)).BeginInit();
this.SuspendLayout();
//
// dbgMessage
//
this.dbgMessage.DataMember = "";
this.dbgMessage.HeaderForeColor = System.Drawing.SystemColors.ControlText;
this.dbgMessage.Location = new System.Drawing.Point(0, 0);
this.dbgMessage.Name = "dbgMessage";
this.dbgMessage.PreferredColumnWidth = 120;
this.dbgMessage.Size = new System.Drawing.Size(576, 336);
this.dbgMessage.TabIndex = 0;
this.dbgMessage.TableStyles.AddRange(new System.Windows.Forms.DataGridTableStyle[] {
this.dataGridTableStyle1});
this.dbgMessage.Click += new System.EventHandler(this.dbgMessage_Click);
//
// dataGridTableStyle1
//
this.dataGridTableStyle1.DataGrid = this.dbgMessage;
this.dataGridTableStyle1.GridColumnStyles.AddRange(new System.Windows.Forms.DataGridColumnStyle[] {
this.dataGridTextBoxColumn1,
this.dataGridTextBoxColumn2,
this.dataGridTextBoxColumn3,
this.dataGridTextBoxColumn4});
this.dataGridTableStyle1.HeaderForeColor = System.Drawing.SystemColors.ControlText;
this.dataGridTableStyle1.MappingName = "MPNumber";
//
// dataGridTextBoxColumn1
//
this.dataGridTextBoxColumn1.Format = "";
this.dataGridTextBoxColumn1.FormatInfo = null;
this.dataGridTextBoxColumn1.MappingName = "Id";
this.dataGridTextBoxColumn1.ReadOnly = true;
this.dataGridTextBoxColumn1.Width = 0;
//
// dataGridTextBoxColumn2
//
this.dataGridTextBoxColumn2.Format = "";
this.dataGridTextBoxColumn2.FormatInfo = null;
this.dataGridTextBoxColumn2.HeaderText = "號段";
this.dataGridTextBoxColumn2.MappingName = "號段";
this.dataGridTextBoxColumn2.Width = 75;
//
// dataGridTextBoxColumn3
//
this.dataGridTextBoxColumn3.Format = "";
this.dataGridTextBoxColumn3.FormatInfo = null;
this.dataGridTextBoxColumn3.HeaderText = "所在省";
this.dataGridTextBoxColumn3.MappingName = "省";
this.dataGridTextBoxColumn3.Width = 75;
//
// dataGridTextBoxColumn4
//
this.dataGridTextBoxColumn4.Format = "";
this.dataGridTextBoxColumn4.FormatInfo = null;
this.dataGridTextBoxColumn4.HeaderText = "所在市";
this.dataGridTextBoxColumn4.MappingName = "市";
this.dataGridTextBoxColumn4.Width = 75;
//
// btnDelete
//
this.btnDelete.Location = new System.Drawing.Point(288, 344);
this.btnDelete.Name = "btnDelete";
this.btnDelete.TabIndex = 1;
this.btnDelete.Text = "刪除";
this.btnDelete.Click += new System.EventHandler(this.btnDelete_Click);
//
// btnSave
//
this.btnSave.Location = new System.Drawing.Point(384, 344);
this.btnSave.Name = "btnSave";
this.btnSave.TabIndex = 2;
this.btnSave.Text = "保存";
this.btnSave.Click += new System.EventHandler(this.btnSave_Click);
//
// btnClose
//
this.btnClose.Location = new System.Drawing.Point(480, 344);
this.btnClose.Name = "btnClose";
this.btnClose.TabIndex = 3;
this.btnClose.Text = "關閉";
this.btnClose.Click += new System.EventHandler(this.btnClose_Click);
//
// frmDataManager
//
this.AutoScaleBaseSize = new System.Drawing.Size(6, 14);
this.ClientSize = new System.Drawing.Size(576, 378);
this.Controls.Add(this.btnClose);
this.Controls.Add(this.btnSave);
this.Controls.Add(this.btnDelete);
this.Controls.Add(this.dbgMessage);
this.Name = "frmDataManager";
this.Text = "手機歸屬地數據管理";
this.Load += new System.EventHandler(this.frmDataManager_Load);
((System.ComponentModel.ISupportInitialize)(this.dbgMessage)).EndInit();
this.ResumeLayout(false);
}
#endregion
private void btnClose_Click(object sender, System.EventArgs e)
{
this.Close();
}
private void frmDataManager_Load(object sender, System.EventArgs e)
{
string sqlString="select Id,Number as 號段 ,Province as 省,City as 市 from MPNumber";
DataTable datatable=access.Query("MPNumber",sqlString);
dataset=datatable.DataSet;
this.dbgMessage.DataSource=datatable;
adapter=new SqlDataAdapter();
}
private void btnSave_Click(object sender, System.EventArgs e)
{
string insertString="insert into MPNumber(Number,Province,City) values(@Number,@Province,@City)";
adapter.InsertCommand=new SqlCommand(insertString,conn);
SqlParameter parms11=adapter.InsertCommand.Parameters.Add(new SqlParameter("@Number",SqlDbType.VarChar,7));
parms11.SourceColumn="號段";
parms11.SourceVersion=DataRowVersion.Current;
SqlParameter parms12=adapter.InsertCommand.Parameters.Add(new SqlParameter("@Province",SqlDbType.VarChar,20));
parms12.SourceColumn="省";
parms12.SourceVersion=DataRowVersion.Current;
SqlParameter parms13=adapter.InsertCommand.Parameters.Add(new SqlParameter("@City",SqlDbType.VarChar,20));
parms13.SourceColumn="市";
parms13.SourceVersion=DataRowVersion.Current;
string updateString="update MPNumber set Number=@Number,Province=@Province,City=@City where Id=@Id";
adapter.UpdateCommand=new SqlCommand(updateString,conn);
SqlParameter parms1=adapter.UpdateCommand.Parameters.Add(new SqlParameter("@Number",SqlDbType.VarChar,7));
parms1.SourceColumn="號段";
parms1.SourceVersion=DataRowVersion.Current;
SqlParameter parms2=adapter.UpdateCommand.Parameters.Add(new SqlParameter("@Province",SqlDbType.VarChar,20));
parms2.SourceColumn="省";
parms2.SourceVersion=DataRowVersion.Current;
SqlParameter parms3=adapter.UpdateCommand.Parameters.Add(new SqlParameter("@City",SqlDbType.VarChar,20));
parms3.SourceColumn="市";
parms3.SourceVersion=DataRowVersion.Current;
SqlParameter parms4=adapter.UpdateCommand.Parameters.Add(new SqlParameter("@Id",SqlDbType.Int));
parms4.SourceColumn="Id";
parms4.SourceVersion=DataRowVersion.Original;
if(dataset.HasChanges())
{
adapter.Update(dataset,"MPNumber");
MessageBox.Show("修改數據成功！！");
}
}
private void dbgMessage_Click(object sender, System.EventArgs e)
{
if(((DataTable)this.dbgMessage.DataSource)!=null)
{
row=((DataTable)this.dbgMessage.DataSource).NewRow();
if(((DataTable)this.dbgMessage.DataSource).Rows.Count>this.dbgMessage.CurrentRowIndex)
{
row=((DataTable)this.dbgMessage.DataSource).Rows[this.dbgMessage.CurrentRowIndex];
}
}
}
private void btnDelete_Click(object sender, System.EventArgs e)
{
dataset=new DataSet();
string sqlString="select * from MPNumber";
adapter=new SqlDataAdapter(sqlString,conn);
adapter.Fill(dataset,"MPNumber");
try
{
string delString="delete from MPNumber where Id=@Id";
adapter.DeleteCommand=new SqlCommand (delString,conn);
SqlParameter parm=adapter.DeleteCommand.Parameters.Add(new SqlParameter("@Id",SqlDbType.Int,4));
parm.SourceColumn="Id";
parm.SourceVersion=DataRowVersion.Original;
dataset.Tables[0].Rows[this.dbgMessage.CurrentRowIndex].Delete();
if(dataset.HasChanges())
{
adapter.Update(dataset,"MPNumber");
MessageBox.Show("刪除記錄成功");
((DataTable)(this.dbgMessage.DataSource)).Rows[this.dbgMessage.CurrentRowIndex].Delete();
}
}
catch(Exception ee)
{
MessageBox.Show(ee.Message);
}
}
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -