添加messagebox

详细设计登录模块:界面关键代码:privatevoidenter_Click(objectsender,EventArgse){if(string.
Empty!
=username.
Text.
Trim()){Class1sql_form1=newClass1();sql_form1.
SelectDs("select*fromtb_personwherename='"+username.
Text.
Trim(aa");if(string.
Compare(sql_form1.
ds.
Tables["aa"].
Rows[0][0].
ToString().
Trim(),username.
Text.
Trim())==0&&(sql_form1.
ds.
Tables["aa"].
Rows[0][1].
ToString().
Trim()==password.
Text.
Trim())){this.
Hide();Form2Form2=newForm2();Form2.
str_form2=username.
Text.
Trim();Form2.
Show(}else{MessageBox.
Show("用户名或密码错误!
","错误提示");password.
Clear();}主界面:个人备忘录:关键代码:Class1select1=newClass1();SqlCommandcomm5;comm5=select1.
Select("*","tb_xingcheng","date>=getdate()andpname='"+str_form2+"'");SqlDataReaderdr1=comm5.
ExecuteReader();if(dr1!
=null){dr1.
Read();listBox1.
Items.
Add("行程:"+dr1[1].
ToString());listBox1.
Items.
Add("日期:"+dr1[2].
ToString());listBox1.
Items.
Add("备注:"+dr1[3].
ToString());}dr1.
Close();select1.
con_close();listView3.
Columns[0].
Width=0;Stringconnstr="DataSource=(local);InitialCatalog=db_keshe;IntegratedSecurity=True";SqlConnectionconn=newSqlConnection(connstr);conn.
Open();SqlCommandcomm4=newSqlCommand("selectidfromtb_xingchengwherepname='"+str_form2+"'",conn);SqlDataReaderdr=comm4.
ExecuteReader();if(dr!
=null){while(dr.
Read())listView3.
Items.
Add(dr[0].
ToString());}}dr.
Close();SqlCommandcomm=newSqlCommand("selectxingchengfromtb_xingchengwherepname='"+str_form2+"'",conn);dr=comm.
ExecuteReader();if(dr!
=null){i=0;while(dr.
Read()){listView3.
Items[i++].
SubItems.
Add(dr[0].
ToString());}dr.
Close();SqlCommandcomm2=newSqlCommand("selectdatefromtb_xingchengwherepname='"+str_form2+"'",conn);dr=comm2.
ExecuteReader();if(dr!
=null){i=0;while(dr.
Read()){listView3.
Items[i++].
SubItems.
Add(dr[0].
ToString(}}dr.
Close();SqlCommandcomm3=newSqlCommand("selectbeizhufromtb_xingchengwherepname='"+str_form2+"'",conn);dr=comm3.
ExecuteReader();if(dr!
=null){i=0;while(dr.
Read()){listView3.
Items[i++].
SubItems.
Add(dr[0].
ToString());}}dr.
Close();conn.
Close();行程的添加界面:关键代码:privatevoidbutton1_Click(objectsender,EventArgse){stringxingcheng=textBox1.
Text.
Trim();stringtime=textBox2.
Text.
Trim();stringremark=textBox3.
Text.
Trim();Class1insert=newClass1();if(string.
Empty!
=textBox1.
Text.
Trim()){if(insert.
Insert("tb_xingcheng",xingcheng,time,remark,str_form3)==1){MessageBox.
Show("添加成功!
","提示");textBox1.
Clear();textBox2.
Clear();textBox3.
Clear();this.
Close();}}else{MessageBox.
Show("请输入行程内容!
","提示");}}通讯录界面:关键代码:listView4.
Columns[0].
Width=0;inti=0;Class1select=newClass1();SqlCommandcomm1;comm1=select.
Select("id","tb_phonebook","pname='"+str_form2+"'");SqlDataReaderdr;dr=comm1.
ExecuteReader();if(dr!
=null){i=0;while(dr.
Read()){listView4.
Items.
Add(dr[0].
ToString());}}dr.
Close();SqlCommandcomm2;comm2=select.
Select("name","tb_phonebook","pname='"+str_form2+"'");dr=comm2.
ExecuteReader();if(dr!
=null){i=0;while(dr.
Read()){listView4.
Items[i++].
SubItems.
Add(dr[0].
ToString());}}dr.
Close();SqlCommandcomm3;comm3=select.
Select("phone","tb_phonebook","pname='"+str_form2+"'");dr=comm3.
ExecuteReader();if(dr!
=null){i=0;while(dr.
Read()){listView4.
Items[i++].
SubItems.
Add(dr[0].
ToString());}}dr.
Close();SqlCommandcomm4;comm4=select.
Select("phone2","tb_phonebook","pname='"+str_form2+"'");dr=comm4.
ExecuteReader();if(dr!
=null){i=0;while(dr.
Read()){listView4.
Items[i++].
SubItems.
Add(dr[0].
ToString());}}dr.
Close();SqlCommandcomm5;comm5=select.
Select("address","tb_phonebook","pname='"+str_form2+"'");dr=comm5.
ExecuteReader();if(dr!
=null){i=0;while(dr.
Read()){listView4.
Items[i++].
SubItems.
Add(dr[0].
ToString());}}dr.
Close();select.
con_close();通讯录添加界面关键代码:if(string.
Empty!
=textBox1.
Text.
Trim()&&button1.
Text=="添加"){stringstr1=textBox1.
Text.
Trim();stringstr2=textBox2.
Text.
Trim();stringstr3=textBox3.
Text.
Trim();stringstr4=textBox4.
Text.
Trim();Class1insert=newClass1();if(1==insert.
Insert("insertintotb_phonebook(name,phone,phone2,address,pname)values('"+str1str2str3str4str_form4+"')")){MessageBox.
Show("添加成功!
","提示");insert.
con_close();this.
Close();}else{MessageBox.
Show("添加失败!
","提示");}}7、个人理财界面:关键代码:intsum=0;intsum2=0;listView2.
Columns[0].
Width=0;if(1==sql.
SelectDs("select*fromtb_accountwherepname='"+str_form2+"'","tb_account")){listView2.
Items.
Clear();for(inti=0;i0){sum=sum+(int)(sql.
ds.
Tables["tb_account"].
Rows[i][2]);}else{sum2=sum2+(int)(sql.
ds.
Tables["tb_account"].
Rows[i][2]);}}listView1.
Items[0].
SubItems.
Add(sum.
ToString());listView1.
Items[1].
SubItems.
Add(sum2.
ToString());sum=sum+sum2;listView1.
Items[2].
SubItems.
Add(sum.
ToString());}else{MessageBox.
Show("导入数据出错","提示");}增加账户信息:关键代码:if("添加"==button1.
Text&&string.
Empty!
=textBox1.
Text.
Trim()){str[1]=textBox1.
Text.
Trim();str[2]=textBox2.
Text.
Trim();str[3]=textBox3.
Text.
Trim();str[4]=textBox4.
Text.
Trim();if(1==sql_form5.
Insert("insertintotb_account(account,sum,inout,remarks,pname)values('"+str[1]str[2]str[3]str[4]str_form5+"')")){this.
Close();MessageBox.
Show("添加成功","提示");}else{MessageBox.
Show("添加失败","提示");}}个人信息管理:关键代码:privatevoidbutton1_Click(objectsender,EventArgse){if(string.
Compare(button1.
Text,"修改个人信息")==0){button1.
Text="修改完成";textBox5.
Enabled=true;textBox6.
Enabled=true;textBox4.
Enabled=true;}else{button1.
Text="修改个人信息";sql.
Update("updatetb_personsetp_name='"+textBox5.
Text.
Trim()+"',p_motto='"+textBox4.
Text.
Trim()+"',p_favour='"+textBox6.
Text.
Trim()+"'wherename='"+str_form2+"'");textBox5.
Enabled=false;textBox6.
Enabled=false;textBox4.
Enabled=false;}}