資源簡介
自己寫的ATM取款機,帶有數(shù)據(jù)庫SQL
詳細的代碼解釋。希望能夠幫助到需要的朋友

代碼片段和文件信息
using?System;
using?System.Collections.Generic;
using?System.ComponentModel;
using?System.Data;
using?System.Drawing;
using?System.Linq;
using?System.Text;
using?System.Windows.Forms;
using?System.Data.SqlClient;
namespace?ATM取款機
{
????public?partial?class?chack?:?Form
????{
????????public?chack()
????????{
????????????InitializeComponent();
????????}
????????private?void?button2_Click(object?sender?EventArgs?e)
????????{
????????????this.Close();
????????}
????????private?void?button1_Click(object?sender?EventArgs?e)
????????{
????????????//創(chuàng)建連接對象
????????????SqlConnection?con?=?new?SqlConnection();
????????????con.ConnectionString?=?“server=.;database=ATM;uid=shuquan;pwd=123“;
????????????con.Open();
????????????/*
????????????if?(con.State?==?ConnectionState.Open)
????????????{
????????????????MessageBox.Show(“成功“);
????????????}
????????????else?{?MessageBox.Show(“失敗“);?}
?????????????*/
????????????if?(con.State?==?ConnectionState.Open)
????????????{
?????????????????//創(chuàng)建命令對象
????????????????SqlCommand?cmd?=?new?SqlCommand();
???????????????//給命令對象設(shè)置連接對象
????????????????cmd.Connection?=?con;
????????????????//給命令對象設(shè)置命令文本
????????????????cmd.CommandText?=?“select?*?from?ye?where?id=“+Class1.id;
????????????????//執(zhí)行查詢
????????????????SqlDataReader?reader?=?cmd.ExecuteReader();
????????????????string?id?=?null;
????????????????string?ye?=?null;
????????????????string?time?=?null;
????????????????//向listbox里面添加一個文本
????????????????this.listBox1.Items.Add(“ID\t余額\t交易時間“);
????????????????while?(reader.Read())?//循環(huán)讀取數(shù)據(jù)
????????????????{
????????????????????id?=?reader[0].ToString();
????????????????????ye?=?reader[1].ToString();
????????????????????time=reader[2].ToString();
????????????????????string?temp?=?id+“\t“+ye?+?“\t“?+?time;
????????????????????this.listBox1.Items.Add(temp);
????????????????}
????????????????reader.Close();
????????????}
????????}
????}
}
?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????文件????????926??2010-12-10?11:52??ATM取款機\ATM取款機.sln
????..A..H.?????19968??2011-02-21?23:52??ATM取款機\ATM取款機.suo
?????文件???????6124??2010-12-10?11:52??ATM取款機\UpgradeLog.xm
?????文件???????5312??2010-12-10?11:51??ATM取款機\ATM取款機\ATM取款機.csproj
?????文件???????2123??2010-11-20?10:59??ATM取款機\ATM取款機\chack.cs
?????文件???????4060??2010-11-19?23:10??ATM取款機\ATM取款機\chack.Designer.cs
?????文件???????5814??2010-11-19?23:10??ATM取款機\ATM取款機\chack.resx
?????文件????????195??2010-11-20?10:51??ATM取款機\ATM取款機\Class1.cs
?????文件???????2056??2010-11-20?11:11??ATM取款機\ATM取款機\Form1.cs
?????文件???????5583??2010-11-20?11:03??ATM取款機\ATM取款機\Form1.Designer.cs
?????文件???????5814??2010-11-20?11:03??ATM取款機\ATM取款機\Form1.resx
?????文件????????922??2010-11-19?21:47??ATM取款機\ATM取款機\Form2.cs
?????文件???????5524??2010-11-19?21:47??ATM取款機\ATM取款機\Form2.Designer.cs
?????文件???????5814??2010-11-19?21:47??ATM取款機\ATM取款機\Form2.resx
?????文件???????2914??2010-11-20?12:25??ATM取款機\ATM取款機\money.cs
?????文件???????4825??2010-11-20?11:21??ATM取款機\ATM取款機\money.Designer.cs
?????文件???????5814??2010-11-20?11:21??ATM取款機\ATM取款機\money.resx
?????文件????????493??2010-11-20?11:43??ATM取款機\ATM取款機\Program.cs
?????文件???????2158??2010-11-20?11:20??ATM取款機\ATM取款機\xiugai.cs
?????文件???????6661??2010-11-20?11:20??ATM取款機\ATM取款機\xiugai.Designer.cs
?????文件???????5814??2010-11-20?11:20??ATM取款機\ATM取款機\xiugai.resx
?????文件??????18944??2011-02-21?23:50??ATM取款機\ATM取款機\bin\Debug\ATM取款機.exe
?????文件??????56832??2011-02-21?23:50??ATM取款機\ATM取款機\bin\Debug\ATM取款機.pdb
?????文件??????11608??2011-02-21?23:49??ATM取款機\ATM取款機\bin\Debug\ATM取款機.vshost.exe
?????文件????????490??2010-03-17?22:39??ATM取款機\ATM取款機\bin\Debug\ATM取款機.vshost.exe.manifest
?????文件????????180??2011-02-21?23:50??ATM取款機\ATM取款機\obj\Debug\ATM取款機.chack.resources
?????文件???????2094??2011-02-21?23:50??ATM取款機\ATM取款機\obj\Debug\ATM取款機.csproj.FileListAbsolute.txt
?????文件???????1080??2010-11-20?11:21??ATM取款機\ATM取款機\obj\Debug\ATM取款機.csproj.GenerateResource.Cache
?????文件??????18944??2011-02-21?23:50??ATM取款機\ATM取款機\obj\Debug\ATM取款機.exe
?????文件????????180??2011-02-21?23:50??ATM取款機\ATM取款機\obj\Debug\ATM取款機.Form1.resources
............此處省略61個文件信息
- 上一篇:c# 精密星歷內(nèi)插計算
- 下一篇:WPF翻轉(zhuǎn)動畫
評論
共有 條評論