《个人理财系统》由会员分享,可在线阅读,更多相关《个人理财系统(17页珍藏版)》请在金锄头文库上搜索。
1、-. z.-privatevoid btlogin_Click(object sender, EventArgs e)string username = null;string password = null ;if (tbusername.Te*t = ) MessageBo*.Show(你没有输入用户名!,错误提示); return; if (tbmima.Te*t = ) MessageBo*.Show(你没有输入密码!,错误提示);return; DataSet dst = newDataSet();string connstr = Data Source=(local);Initia
2、l Catalog=Message;Integrated Security=True;SqlConnection con = newSqlConnection(connstr);con.Open();string str = select * from 登录;SqlDataAdapter sda = newSqlDataAdapter(str, con);SqlCommandBuilder scd = newSqlCommandBuilder(sda);sda.Fill(dst, tong);dataGridView1.DataSource = dst.Tablestong.DefaultVi
3、ew;username = dataGridView1.Rows0.Cells0.Value.ToString().Trim();password = dataGridView1.Rows0.Cells1.Value.ToString().Trim();if (tbusername.Te*t.Equals(username) & tbmima.Te*t.Equals(password) Form2 f2 = newForm2(); f2.Visible = true;this.Visible = false;elseMessageBo*.Show(你输入的用户名或密码错误,错误提示); tbu
4、sername.Clear(); tbmima.Clear(); con.Close();privatevoid btcancel_Click(object sender, EventArgs e)if (MessageBo*.Show(你是否真的想退出系统?, 提示, MessageBo*Buttons.YesNo) != DialogResult.No) this.Close(); privatevoid button1_Click(object sender, EventArgs e)string username = null;string password = null;if (tb
5、username.Te*t = ) MessageBo*.Show(你没有输入用户名!, 错误提示); return;if (tbmima.Te*t = )MessageBo*.Show(你没有输入密码!, 错误提示); return;DataSet dst = newDataSet();string connstr = Data Source=(local);Initial Catalog=Message;Integrated Security=True;SqlConnection con = newSqlConnection(connstr);con.Open(); string str
6、= select * from 登录;SqlDataAdapter sda = newSqlDataAdapter(str, con);SqlCommandBuilder scd = newSqlCommandBuilder(sda);sda.Fill(dst, tong);dataGridView1.DataSource = dst.Tablestong.DefaultView;username = dataGridView1.Rows0.Cells0.Value.ToString().Trim();password = dataGridView1.Rows0.Cells1.Value.To
7、String().Trim();if (tbusername.Te*t.Equals(username) & tbmima.Te*t.Equals(password)if (MessageBo*.Show(你确定要修改密码吗?, 提示, MessageBo*Buttons.YesNo) = DialogResult.Yes) 修改密码 mima = new修改密码(); mima.Visible = true; elseMessageBo*.Show(你输入的用户名或密码错误, 错误提示); tbusername.Clear(); tbmima.Clear(); con.Close();. z
8、.-. z.-privatevoid button1_Click(object sender, EventArgs e)string username = null;string password = null;if (te*tBo*1.Te*t = ) MessageBo*.Show(你没有输入密码!, 错误提示);return; if (te*tBo*2.Te*t = )MessageBo*.Show(你没有输入更改密码!, 错误提示); return;if (te*tBo*3.Te*t = )MessageBo*.Show(你没有再次输入更改密码!, 错误提示);return;strin
9、g b = te*tBo*2.Te*t.ToString().Trim();string a = te*tBo*3.Te*t.ToString().Trim();if (b.Equals(a)=false)MessageBo*.Show(你两次输入的密码不一样!,错误提示); return;DataSet dst = newDataSet();string connstr = Data Source=(local);Initial Catalog=Message;Integrated Security=True;SqlConnection con = newSqlConnection(conn
10、str);con.Open();string str = select * from 登录;SqlDataAdapter sda = newSqlDataAdapter(str, con);SqlCommandBuilder scd = newSqlCommandBuilder(sda);sda.Fill(dst, tong);dataGridView1.DataSource = dst.Tablestong.DefaultView;username = dataGridView1.Rows0.Cells0.Value.ToString().Trim();password = dataGrid
11、View1.Rows0.Cells1.Value.ToString().Trim();if (te*tBo*1.Te*t.Equals(password)String sql = update 登录 set mima=+te*tBo*2.Te*t.Trim()+where username=+username+;TrySqlCommand comm = newSqlCommand(sql, con); comm.E*ecuteNonQuery();catch(E*ception es)MessageBo*.Show(修改密码失败!,提示);return; elseMessageBo*.Show
12、(你输入的密码错误, 错误提示); te*tBo*1.Clear();return;MessageBo*.Show(密码更改成功!);te*tBo*1.Clear();te*tBo*2.Clear();te*tBo*3.Clear();con.Close();privatevoid button2_Click(object sender, EventArgs e) this.Close(); . z.-. z.-实现代码如下:privatevoid button6_Click(object sender, EventArgs e)/实现备忘录的查询string str = null;if (t
13、e*tBo*6.Te*t != ) str = select * from 备忘录 where 备忘标题= + te*tBo*6.Te*t + ; te*tBo*6.Clear(); elseif (comboBo*1.Te*t != )string lei = comboBo*1.Te*t;if (lei.Equals(日程表) = false & lei.Equals(纪念日) = false & lei.Equals(记事本) = false & lei.Equals(节日) = false & lei.Equals(备忘录) = false) MessageBo*.Show(你输入的类别不正确,请重新输入!, 错误提示);return;