資源簡介
關于家庭事務的一款c#小項目,適用于課程設計和參考學習!包含財務,事務,通訊錄,日記本,留言本等功能!簡單,便捷!能實現基本的家庭事務管理功能!

代碼片段和文件信息
using?System;
using?System.Collections.Generic;
using?System.ComponentModel;
using?System.Data;
using?System.Drawing;
using?System.Text;
using?System.Windows.Forms;
using?System.Data.OleDb;
namespace?WindowsApplication3
{
????public?partial?class?adminManager?:?Form
????{
????????string?strUserID=null?;
????????string?strUserPWD?=?null;
????????public?adminManager()
????????{
????????????InitializeComponent();
????????}
????????private?void?button3_Click(object?sender?EventArgs?e)
????????{
????????????this.Dispose();
????????????new?login_frm().Show();
????????}
????????private?void?button2_Click(object?sender?EventArgs?e)
????????{
????????????this.Dispose();
????????????new?userAdd().Show();
????????}
????????private?void?button1_Click(object?sender?EventArgs?e)
????????{
????????????OleDbConnection?aConnection?=?new?OleDbConnection(“Provider=Microsoft.Jet.OLEDB.4.0;Data?Source=?.\\JTSW.mdb“);
????????????try
????????????{
????????????????aConnection.Open();
????????????????string?strsql?=?“select?*?from?use?“;//where?userID=‘“?+?txtbx_name.Text?+?“‘?and?userPWD=‘“?+?txtbx_password.Text?+?“‘;//顯示數據庫
????????????????OleDbCommand?myCmd?=?new?OleDbCommand(strsql?aConnection);
????????????????myCmd.ExecuteNonQuery();
????????????????DataSet?objDataSet?=?new?DataSet();
????????????????OleDbDataAdapter?objAdapter?=?new?OleDbDataAdapter(strsql?aConnection);
????????????????objAdapter.Fill(objDataSet?“use“);
????????????????DataView?objDataView?=?new?DataView(objDataSet.Tables[“use“]);
????????????????dataGridView_user.DataSource?=?objDataView?;
????????????????//dataGridView_user.DataSource?=?objdatagridview;
????????????}
????????????catch
????????????{}
????????????finally
????????????{
????????????????if?(aConnection?!=?null)
????????????????????aConnection.Close();
????????????}
????????}
????????private?void?dataGridView_user_CurrentCellChanged(object?sender?EventArgs?e)
????????{
????????????//textBox1.Text?=?dataGridView2[0?dataGridView2.CurrentCell.RowIndex].Value.ToString();
????????????strUserID?=?dataGridView_user[0?dataGridView_user.CurrentCell.RowIndex].Value.ToString();
????????????strUserPWD?=?dataGridView_user[1?dataGridView_user.CurrentCell.RowIndex].Value.ToString();
????????????//MessageBox.Show(strUserPWD?+?strUserID);
????????????button4.Enabled?=?true;
????????}
????????private?void?button4_Click(object?sender?EventArgs?e)
????????{
????????????string?custM?=?“Provider=Microsoft.Jet.OLEDB.4.0;Data?Source=?.\\JTSW.mdb“;
????????????OleDbConnection?objConnection?=?new?OleDbConnection(custM);
????????????if(strUserID==““||strUserPWD==““)
????????????{
????????????????MessageBox.Show(“請選擇你要刪除的項“);
????????????}
????????????else?
????????????{
????????????????try
????????????{
????????????????objConnection.Open();
????????????????string?strSql?=?“delete?*?From?use?where?userID=‘“?+?strUserID?+?“‘?and?userPWD=‘“+strUserPWD?+“‘“;
????????
?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????文件????????946??2009-06-25?11:52??家庭事務管理\WindowsApplication3.sln
????..A..H.?????46080??2009-07-09?09:03??家庭事務管理\WindowsApplication3.suo
?????文件???????3609??2009-07-01?15:55??家庭事務管理\WindowsApplication3\adminManager.cs
?????文件???????5135??2009-07-01?15:54??家庭事務管理\WindowsApplication3\adminManager.Designer.cs
?????文件???????5814??2009-07-01?15:54??家庭事務管理\WindowsApplication3\adminManager.resx
?????文件????????403??2009-06-23?13:34??家庭事務管理\WindowsApplication3\app.config
?????文件???????1441??2009-06-22?16:57??家庭事務管理\WindowsApplication3\databa
?????文件????????958??2009-06-26?17:24??家庭事務管理\WindowsApplication3\DB.cs
?????文件??????15369??2009-06-23?10:07??家庭事務管理\WindowsApplication3\DBUtility.cs
?????文件???????1890??2009-07-01?17:53??家庭事務管理\WindowsApplication3\frm_alterpwd.cs
?????文件???????6062??2009-07-01?17:53??家庭事務管理\WindowsApplication3\frm_alterpwd.Designer.cs
?????文件?????166107??2009-07-01?17:53??家庭事務管理\WindowsApplication3\frm_alterpwd.resx
?????文件???????2495??2009-07-01?17:53??家庭事務管理\WindowsApplication3\frm_code.cs
?????文件???????7120??2009-07-01?17:53??家庭事務管理\WindowsApplication3\frm_code.Designer.cs
?????文件?????113061??2009-07-01?17:53??家庭事務管理\WindowsApplication3\frm_code.resx
?????文件??????38067??2009-07-01?17:40??家庭事務管理\WindowsApplication3\frm_main.cs
?????文件?????100039??2009-07-01?16:02??家庭事務管理\WindowsApplication3\frm_main.Designer.cs
?????文件?????269904??2009-07-01?16:02??家庭事務管理\WindowsApplication3\frm_main.resx
?????文件???????2557??2009-07-01?17:44??家庭事務管理\WindowsApplication3\login_frm.cs
?????文件???????7434??2009-07-01?17:44??家庭事務管理\WindowsApplication3\login_frm.Designer.cs
?????文件??????10273??2009-07-01?17:44??家庭事務管理\WindowsApplication3\login_frm.resx
?????文件??????21596??2009-06-26?20:03??家庭事務管理\WindowsApplication3\main_frm.cs
?????文件??????32320??2009-06-26?20:00??家庭事務管理\WindowsApplication3\main_frm.Designer.cs
?????文件???????6182??2009-06-26?20:00??家庭事務管理\WindowsApplication3\main_frm.resx
?????文件????????502??2009-07-01?17:19??家庭事務管理\WindowsApplication3\Program.cs
?????文件????????885??2009-06-26?10:58??家庭事務管理\WindowsApplication3\rijiDBcount.cs
?????文件???????1657??2009-06-30?18:17??家庭事務管理\WindowsApplication3\userAdd.cs
?????文件???????4869??2009-06-30?18:07??家庭事務管理\WindowsApplication3\userAdd.Designer.cs
?????文件???????5814??2009-06-30?18:07??家庭事務管理\WindowsApplication3\userAdd.resx
?????文件???????5180??2009-07-01?17:22??家庭事務管理\WindowsApplication3\WindowsApplication3.csproj
............此處省略39個文件信息
評論
共有 條評論