vs2010 C#连接ACCESS 小寨地铁出口选择助手
来源:互联网 发布:穿越火线a卡优化 编辑:程序博客网 时间:2024/04/29 09:58
1.功能是可以在右侧的文本框进行搜索小寨附近地点和显示小寨地铁出口选择信息
左侧会自动在七个类型的地点及信息切换,button点击后可以手动切换信息
2.界面如下
3.源代码如下:
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.OleDb;
using System.Data.SqlClient;
using System.Data.Sql;
namespace 小寨地铁出口
{
public partial class Form1 : Form
{
OleDbConnection conn;
DataSet myds=new DataSet();
int i=0;
public Form1()
{
InitializeComponent();
linkdb();
}
private void linkdb()
{
string oleDBString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=小寨地铁出口.mdb"; //用的是ACCESS2003的数据库
conn = new OleDbConnection(oleDBString);
conn.Open();
}
private void doSomething(int i)
{
textBox5.Text = "";
textBox6.Text = "";
textBox7.Text = "";
textBox8.Text = "";
button1.BackColor = Color.FromArgb(128, 255, 255);
button2.BackColor = Color.FromArgb(0, 192, 192);
button3.BackColor = Color.Purple;
button4.BackColor = Color.IndianRed;
button5.BackColor = Color.FromArgb(255, 128, 0);
button6.BackColor = Color.LawnGreen;
button7.BackColor = Color.FromArgb(128, 255, 128);
string str = null;
switch (i)
{
case 1: button1.BackColor = Color.Red; str = "医疗教育"; break;
case 2: button2.BackColor = Color.Red; str = "商场百货"; break;
case 3: button3.BackColor = Color.Red; str = "餐饮娱乐"; break;
case 4: button4.BackColor = Color.Red; str = "银行行政"; break;
case 5: button5.BackColor = Color.Red; str = "宾馆通信"; break;
case 6: button6.BackColor = Color.Red; str = "公交街道"; break;
case 7: button7.BackColor = Color.Red; str = "其他"; break;
}
string strSqlA = string.Format("select 地点 from 小寨附近 where (出口 = 'A' AND 分类 = '{0}') ",str);
OleDbCommand cmdA = new OleDbCommand(strSqlA, conn);
OleDbDataReader drA = cmdA.ExecuteReader();
while (drA.Read())
{
this.textBox5.Text += (String)drA[0];
this.textBox5.Text += "\r\n\r\n";
}
string strSqlB = string.Format("select 地点 from 小寨附近 where (出口 = 'B' AND 分类 = '{0}') ",str);
OleDbCommand cmdB = new OleDbCommand(strSqlB, conn);
OleDbDataReader drB = cmdB.ExecuteReader();
while (drB.Read())
{
this.textBox6.Text += (String)drB[0];
this.textBox6.Text += "\r\n\r\n";
}
string strSqlC = string.Format("select 地点 from 小寨附近 where (出口 = 'C' AND 分类 = '{0}') ", str);
OleDbCommand cmdC = new OleDbCommand(strSqlC, conn);
OleDbDataReader drC = cmdC.ExecuteReader();
while (drC.Read())
{
this.textBox7.Text += (String)drC[0];
this.textBox7.Text += "\r\n\r\n";
}
string strSqlD = string.Format("select 地点 from 小寨附近 where (出口 = 'D' AND 分类 = '{0}') ", str);
OleDbCommand cmdD = new OleDbCommand(strSqlD, conn);
OleDbDataReader drD = cmdD.ExecuteReader();
while (drD.Read())
{
this.textBox8.Text += (String)drD[0];
this.textBox8.Text += "\r\n\r\n";
}
}
private void button1_Click(object sender, EventArgs e)
{
doSomething(1);
timer1.Stop();
i = 13;
timer1.Start();
}
private void button2_Click(object sender, EventArgs e)
{
doSomething(2);
timer1.Stop();
i = 13;
timer1.Start();
}
private void button3_Click(object sender, EventArgs e)
{
doSomething(3);
timer1.Stop();
i = 13;
timer1.Start();
}
private void button4_Click(object sender, EventArgs e)
{
doSomething(4);
timer1.Stop();
i = 13;
timer1.Start();
}
private void button5_Click(object sender, EventArgs e)
{
doSomething(5);
timer1.Stop();
i = 13;
timer1.Start();
}
private void button6_Click(object sender, EventArgs e)
{
doSomething(6);
timer1.Stop();
i = 13;
timer1.Start();
}
private void button7_Click(object sender, EventArgs e)
{
doSomething(7);
timer1.Stop();
i = 13;
timer1.Start();
}
private void button8_Click(object sender, EventArgs e)
{
string str = textBox9.Text.ToString();
string strSql = string.Format("select 出口 from 小寨附近 where 地点 = '{0}'",str);
OleDbCommand cmd = new OleDbCommand(strSql, conn);
OleDbDataReader dr = cmd.ExecuteReader();
if (dr.Read())
{
this.textBox10.Text = (String)dr[0];
}
}
private void timer1_Tick(object sender, EventArgs e)
{
switch(i){
case 0: doSomething(1); break;
case 1: doSomething(2); break;
case 2: doSomething(3); break;
case 3: doSomething(4); break;
case 4: doSomething(5); break;
case 5: doSomething(6); break;
case 6: doSomething(7); break;
case 13: break;
}
i++;
i = i % 7;
}
private void Form1_Load(object sender, EventArgs e)
{
timer1.Start();
}
}
}
3.在写程序过程中我学会了
timer控件的用法
在其他函数中调用button_click的用法
4.第一次发博客,程序也简单。
写这个程序的想法来自李晓晨同学
本人水平很菜,感谢郑国敏同学的帮助
- vs2010 C#连接ACCESS 小寨地铁出口选择助手
- c# vs2010 连接access数据库
- VS2010小助手安装
- VS2010 C#串口调试助手
- .net连接ACCESS数据库的助手类
- C#编写串口小助手
- C#连接ACCESS数据库报错问题;微软小BUG
- vs2010 C#链接 ACCESS数据库
- C#连接mysql (vs2010)
- C#连接mysql (vs2010)
- C#连接mysql (vs2010)
- C#连接ACCESS & SQL
- C#连接Access数据库
- C#连接ACCESS
- C#连接access数据库
- c# 连接 access 方法
- C# 连接 Access 操作
- C#连接ACCESS数据库
- Python 3.x与2.x 差异笔记
- ValueStack
- C++经典排序算法全集
- 简易计算器
- WoguValidator1.1
- vs2010 C#连接ACCESS 小寨地铁出口选择助手
- struts2 的ebug标签 以及valustack和stackcontext
- javascript数组的使用
- UTF-8编码规则
- 《叩开C#之门》系列之一
- ARM code for Beginners Part 2
- ARM code for Beginners Part 3
- MFC之CFileDialog文件保存扩展名问题
- 设计模式之--适配器模式(adapter)