/*以下是我在自己三层项目改过来的，先在设计模式下拉一dataGridView控件，名称叫dataGridView1，添加一属性text值为“修改”属性name值为“btnUpdate”的button控件，还有一个属性name值为btnCancel的取消控件。以下是cs代码，把整个复制过去，改下空间名，和类名（这里指窗体名字），就行了*/usingSystem;usingSystem.Collections.Generic;usingSystem.ComponentModel;usingSystem.Data;usingSystem.Drawing;usingSystem.Text;usingSystem.Windows.Forms;usingSystem.Data.SqlClient;namespaceLDZ.HMISAUX{publicpartialclassfrmUsersEdit:Form{publicfrmUsersEdit(){InitializeComponent();}//////构造一个方法，并绑定数据到dataGridView控件中//////privatevoidGetUsers(){try{SqlConnectionconn=newSqlConnection("server=localhost;database=test;uid=abc;pwd=abc");conn.Open();stringsql=string.Format("Selectall*fromtestTable");SqldataAdapterSDA=newSqldataAdapter(sql,conn);DataSetDS=ShowUsers.GetUsers();SDA.Fill(DS,"testTable");this.dataGridView1.DataSource=DS.Tables[0].DefaultView;}catch(Exceptionex){MessageBox.Show(ex.Message);}}privateintAid;privatestringALoginId;privatestringAUserName;privatevoidbtnUpdate_Click(objectsender,EventArgse){try{SqlConnectionconn=newSqlConnection("server=localhost;database=test;uid=abc;pwd=abc");conn.Open();stringsql=string.Format("updatetestTablesetLoginId='"+ALoginId+"',UserName='"+AUserName;+"'whereid='"+Aid+"'");SqldataAdapterSDA=newSqldataAdapter(sql,conn);DataSetDS=ShowUsers.GetUsers();SDA.Fill(DS,"testTable");this.dataGridView1.DataSource=DS.Tables[0].DefaultView;MessageBox.Show("修改记录成功");}catch(Exceptionex){MessageBox.Show(ex.Message);}}privatevoidbtnCancel_Click(objectsender,EventArgse){this.Close();}privatevoiddataGridView1_CellEndEdit(objectsender,DataGridViewCellEventArgse){try{if(dataGridView1.Rows.Count>0){Aid=int.Parse(this.dataGridView1.Rows[e.RowIndex].Cells[0].Value.ToString());ALoginId=this.dataGridView1.Rows[e.RowIndex].Cells[1].Value.ToString();AUserName=this.dataGridView1.Rows[e.RowIndex].Cells[2].Value.ToString();AUserpwd=this.dataGridView1.Rows[e.RowIndex].Cells[3].Value.ToString();AEmail=this.dataGridView1.Rows[e.RowIndex].Cells[4].Value.ToString();AUserGroup=int.Parse(this.dataGridView1.Rows[e.RowIndex].Cells[5].Value.ToString());AUserType=int.Parse(this.dataGridView1.Rows[e.RowIndex].Cells[6].Value.ToString());}}catch(Exceptionex){MessageBox.Show(ex.Message);}}privatevoidUpdateUsers_Load(objectsender,EventArgse){GetUsers();}}}}
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024