Winform Connection Database Add and delete change basic Operation new Folder App_Code added two classes: UserDA.cs (The fields in the package table) User.Data.cs (write connection database, add and remove changes to the Operation method)
Using Windowsformsapplication7.app_code;namespace windowsformsapplication7{public partial class Form4:form { Public Form4 () {InitializeComponent (); } private void Button1_Click (object sender, EventArgs e) {Insert F = new Insert (); F.owner = this; F.show (); private void Form4_load (object sender, EventArgs e) {list<userdata> List = new Userda (). Select (); Binddata (list); private void Binddata (list<userdata> List) {//First step: Build ListView "' Listview1.col Umns. Clear (); LISTVIEW1.COLUMNS.ADD ("number"); LISTVIEW1.COLUMNS.ADD ("User name"); LISTVIEW1.COLUMNS.ADD ("password"); ListView1.Items.Clear (); Reading data, building rows in the ListView by data foreach (UserData data in list) {ListViewItem lt = new List ViewItem (); Lt. Text = data. Code.tostring (); Lt. SubItems.Add (data. Uname); Lt. SubItems.Add (data. UPass); LISTVIEW1.ITEMS.ADD (LT); }} private void Button4_Click (object sender, EventArgs e) {list<userdata> Listtiao Jian = new Userda (). Select (TextBox1.Text); Binddata (Listtiaojian); private void Button3_Click (object sender, EventArgs e) {if (ListView1.SelectedItems.Count > 0) {String code = Listview1.selecteditems[0]. Text; New Userda (). Delete (code); rebind data list<userdata> List = new Userda (). Select (); Binddata (list); } else {MessageBox.Show ("Please select, then delete"); }} private void Button2_Click (object sender, EventArgs e) {if (listview1.selecteditems.c Ount > 0) {UserData data = new UserData (); Data. Code = Int. Parse (Listview1.selecteditems[0]. Subitems[0]. Text); Data. Uname = Listview1.selecteditems[0]. SUBITEMS[1]. Text; Data. UPass = Listview1.selecteditems[0]. SUBITEMS[2]. Text; Update f = new update (data); F.show (); } else {MessageBox.Show ("Please select, then Modify"); } } }}
App-code Userdata.cs
namespace windowsformsapplication7.app_code{public class UserData { private int _code; public int Code { get {return _code;} set {_code = value;} } private string _uname; public string Uname { get {return _uname;} set {_uname = value;} } private string _upass; public string UPass { get {return _upass;} set {_upass = value;}}}}
App_code Userda (). CS
Using System.data.sqlclient;namespace windowsformsapplication7.app_code{public class Userda {private Sqlcon Nection _conn; Private SqlCommand _cmd; Public Userda () {_conn = new SqlConnection ("server=.; Database=data1220;user=sa;pwd= "); }//Add method public void Insert (UserData data) {_conn.open (); _cmd = _conn.createcommand (); _cmd.commandtext = "INSERT into users values (@uname, @upass)"; _cmd.parameters.clear (); _cmd.parameters.add ("@uname", data. Uname); _cmd.parameters.add ("@upass", data. UPass); _cmd.executenonquery (); _conn.close (); }//Query method public list<userdata> Select () {list<userdata> List = new List<us Erdata> (); _conn.open (); _cmd = _conn.createcommand (); _cmd.commandtext = "Select *from users"; SqlDataReader dr = _cmd.executEReader (); while (Dr. Read ()) {UserData data = new UserData (); Data. Code = Int. Parse (dr["code"). ToString ()); Data. Uname = dr["Uname"]. ToString (); Data. UPass = dr["UPass"]. ToString (); List. ADD (data); } return list; }///<summary>////</summary>//<returns></returns> Public list<userdata> Select (string uname) {list<userdata> List = new LIST<USERDATA&G t; (); _conn.open (); _cmd = _conn.createcommand (); _cmd.commandtext = "Select *from users where uname like '%" +uname+ "% '"; SqlDataReader dr = _cmd.executereader (); while (Dr. Read ()) {UserData data = new UserData (); Data. Code = Int. Parse (dr["code"). ToString ()); Data. Uname = dr["Uname"]. ToString (); Data. UPass = dr["UPass"]. ToString (); List. ADD (data); } return list; } public void Delete (string code) {_conn.open (); _cmd = _conn.createcommand (); _cmd.commandtext = "Delete from users where code=" +code; _cmd.executenonquery (); _conn.close (); public void Update (UserData data) {_conn.open (); _cmd = _conn.createcommand (); _cmd.commandtext = "Update users set [email protected],[email protected] where [email protected]"; _cmd.parameters.clear (); _cmd.parameters.add ("@code", data. Code); _cmd.parameters.add ("@uname", data. Uname); _cmd.parameters.add ("@upass", data. UPass); _cmd.executenonquery (); _conn.close (); } }}
Regular operation of Winform Interactive database