Regular operation of Winform Interactive database

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&LT;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