namespace SoccerVIP
{
public partial class Form2 : Form{
DataSet myDataSet;//存放从数据库取来的数据的。
OleDbConnection myOleConn;//连接对象,建立本程序和数据库的连接
OleDbDataAdapter myDataAdapter;//用来执行SQL命令 public Form2()
{
InitializeComponent();
}
public void RefreshDG()
{
//移除旧的数据
if (myDataSet.Tables.Contains("SoccerClub"))
{
myDataSet.Tables.Remove("SoccerClub");
}
//读取所有的SocerClub数据,并绑定到dataGridView1上
string sql = "select * from SoccerClub";
myDataAdapter = new OleDbDataAdapter(sql, myOleConn);
myDataAdapter.Fill(myDataSet, "SoccerClub");
dataGridView1.DataSource = myDataSet.Tables["SoccerClub"];
} private void Form2_Load(object sender, EventArgs e)
{
comboBox1.Items.Clear();
comboBox1.Items.Add("tID");
comboBox1.Items.Add("firstname");
comboBox1.Items.Add("lastname");
comboBox1.Items.Add("tel");
comboBox1.Items.Add("address");
comboBox1.Items.Add("favoriteTeam");
comboBox1.Items.Add("rentTime");
comboBox1.Items.Add("coach"); try
{
//链接数据库
string ConStr = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source="
+ System.Environment.CurrentDirectory + @"/dbSoccer.mdb";
myOleConn = new OleDbConnection(ConStr);
myOleConn.Open();
//读取数据
myDataSet = new DataSet();
RefreshDG(); } catch
{
MessageBox.Show("连接数据库有问题,未连接成功。");
}
} private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
{
comboBox2.Items.Clear();
comboBox2.Items.Add("=");
if ((comboBox1.Text == "tID") ||
(comboBox1.Text == "tel") ||
(comboBox1.Text == "coach"))
{
comboBox2.Items.Add(">");
comboBox2.Items.Add(">=");
comboBox2.Items.Add("<");
comboBox2.Items.Add("<="); }
} private void button1_Click(object sender, EventArgs e)
{
if ((textBox1.Text == "") || (comboBox1.Text == "") || (comboBox2.Text == ""))
{
MessageBox.Show("查询条件不能为空");
return;
} string sql = "select * from SoccerClub where ";
string str = "";
if ((comboBox1.Text == "tID") ||
(comboBox1.Text == "tel") ||
(comboBox1.Text == "coach"))
{
str = comboBox1.Text + comboBox2.Text + textBox1.Text;
}
else
{
str = comboBox1.Text + comboBox2.Text + "'" + textBox1.Text + "'";
} sql += str; if (myDataSet.Tables.Contains("SoccerClub"))
{
myDataSet.Tables.Remove("SoccerClub"); }
//根据条件查询
myDataAdapter = new OleDbDataAdapter(sql, myOleConn);
myDataAdapter.Fill(myDataSet, "SoccerClub");
dataGridView1.DataSource = myDataSet.Tables["SoccerClub"];
} private void linkLabel1_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
{
//打开某个链接
System.Diagnostics.Process.Start(linkLabel1.Text);
} private void label1_Click(object sender, EventArgs e)
{ }
}
}
解决方案 »
- C#中,在界面产生后和事件触发之前,需要执行一些操作,这程序怎么设计才好
- c#怎么操作sqlite数据库select,insert等~~在线等
- 如何显示一个数的01码啊??
- 如何将参数保存下来,以便下次调用时,从中取出参数来
- 关于监控硬盘 只需提示一下即可!
- 如何把所需要的dll文件打包成一个exe文件,这样在任何没有安装.net的环境下都能运行。
- 求教dll中的控件,如何引用到样式?
- 利用arcengine10.0在arcengine中实现点(二维坐标数据)的shp文件与面的shp文件相交intersect,然后计算出各个区域内点的个数
- 熟悉Remoting的请进
- 2个白痴问题,请高手解惑!!!
- 求助遍历文件夹的问题
- c#求助
//namespace SoccerVIP
//{
// public partial class Form2 : Form
// {
// DataSet myDataSet;//存放从数据库取来的数据的。
// OleDbConnection myOleConn;//连接对象,建立本程序和数据库的连接
// OleDbDataAdapter myDataAdapter;//用来执行SQL命令// public Form2()
// {
// InitializeComponent();
// }
// public void RefreshDG()
// {
// if (myDataSet.Tables.Contains("SoccerClub"))
// {
// myDataSet.Tables.Remove("SoccerClub");
// }
// string sql = "select * from SoccerClub";
// myDataAdapter = new OleDbDataAdapter(sql, myOleConn);
// myDataAdapter.Fill(myDataSet, "SoccerClub");
// dataGridView1.DataSource = myDataSet.Tables["SoccerClub"];
// }// private void Form2_Load(object sender, EventArgs e)
// {
// comboBox1.Items.Clear();
// comboBox1.Items.Add("tID");
// comboBox1.Items.Add("firstname");
// comboBox1.Items.Add("lastname");
// comboBox1.Items.Add("tel");
// comboBox1.Items.Add("address");
// comboBox1.Items.Add("favoriteTeam");
// comboBox1.Items.Add("rentTime");
// comboBox1.Items.Add("coach");// try
// {
// string ConStr = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source="
// + System.Environment.CurrentDirectory + @"/dbSoccer.mdb";
// myOleConn = new OleDbConnection(ConStr);
// myOleConn.Open();// myDataSet = new DataSet();
// RefreshDG();// }// catch
// {
// MessageBox.Show("连接数据库有问题,未连接成功。");
// }
// }// private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
// {
// comboBox2.Items.Clear();
// comboBox2.Items.Add("=");
// if ((comboBox1.Text == "tID") ||
// (comboBox1.Text == "tel") ||
// (comboBox1.Text == "coach"))
// {
// comboBox2.Items.Add(">");
// comboBox2.Items.Add(">=");
// comboBox2.Items.Add("<");
// comboBox2.Items.Add("<=");// }
// }// private void button1_Click(object sender, EventArgs e)
// {
// if ((textBox1.Text == "") || (comboBox1.Text == "") || (comboBox2.Text == ""))
// {
// MessageBox.Show("查询条件不能为空");
// return;
// }// string sql = "select * from SoccerClub where ";
// string str = "";
// if ((comboBox1.Text == "tID") ||
// (comboBox1.Text == "tel") ||
// (comboBox1.Text == "coach"))
// {
// str = comboBox1.Text + comboBox2.Text + textBox1.Text;
// }
// else
// {
// str = comboBox1.Text + comboBox2.Text + "'" + textBox1.Text + "'";
// }// sql += str;// if (myDataSet.Tables.Contains("SoccerClub"))
// {
// myDataSet.Tables.Remove("SoccerClub");// }// myDataAdapter = new OleDbDataAdapter(sql, myOleConn);
// myDataAdapter.Fill(myDataSet, "SoccerClub");
// dataGridView1.DataSource = myDataSet.Tables["SoccerClub"];
// }// private void linkLabel1_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
// {
// System.Diagnostics.Process.Start(linkLabel1.Text);
// }// private void label1_Click(object sender, EventArgs e)
// {// }
// }
//}
全部帮你注释了。
{
public partial class Form2 : Form{
DataSet myDataSet;//存放从数据库取来的数据的。
OleDbConnection myOleConn;//连接对象,建立本程序和数据库的连接
OleDbDataAdapter myDataAdapter;//用来执行SQL命令 public Form2()
{
InitializeComponent();
}
//方法用来判断myDataSet里面是否包含"SoccerClub"是就移除,下面就是绑定数据了SoccerClub表里的数据绑定到dataGridView1中
public void RefreshDG()
{
if (myDataSet.Tables.Contains("SoccerClub"))
{
myDataSet.Tables.Remove("SoccerClub");
}
string sql = "select * from SoccerClub";
myDataAdapter = new OleDbDataAdapter(sql, myOleConn);
myDataAdapter.Fill(myDataSet, "SoccerClub");
dataGridView1.DataSource = myDataSet.Tables["SoccerClub"];
}
//这是form2窗体加载时候comboBox1控件加载item
private void Form2_Load(object sender, EventArgs e)
{
comboBox1.Items.Clear();
comboBox1.Items.Add("tID");
comboBox1.Items.Add("firstname");
comboBox1.Items.Add("lastname");
comboBox1.Items.Add("tel");
comboBox1.Items.Add("address");
comboBox1.Items.Add("favoriteTeam");
comboBox1.Items.Add("rentTime");
comboBox1.Items.Add("coach");
//链接数据库语句,下面有异常就捕获
try
{
string ConStr = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source="
+ System.Environment.CurrentDirectory + @"/dbSoccer.mdb";
myOleConn = new OleDbConnection(ConStr);
myOleConn.Open(); myDataSet = new DataSet();
RefreshDG(); } catch
{
MessageBox.Show("连接数据库有问题,未连接成功。");
}
}
//这里是触发comboBox1的SelectedIndexChanged事件,判断选择的是哪个,有对应的操作
private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
{
comboBox2.Items.Clear();
comboBox2.Items.Add("=");
if ((comboBox1.Text == "tID") ||
(comboBox1.Text == "tel") ||
(comboBox1.Text == "coach"))
{
comboBox2.Items.Add(">");
comboBox2.Items.Add(">=");
comboBox2.Items.Add("<");
comboBox2.Items.Add("<="); }
}
//这个是button1的点击事件,判断输入,接下来就是sql语句选择你comboBox选中的条件进行数据绑定再显示在dataGridView1控件中
private void button1_Click(object sender, EventArgs e)
{
if ((textBox1.Text == "") || (comboBox1.Text == "") || (comboBox2.Text == ""))
{
MessageBox.Show("查询条件不能为空");
return;
} string sql = "select * from SoccerClub where ";
string str = "";
if ((comboBox1.Text == "tID") ||
(comboBox1.Text == "tel") ||
(comboBox1.Text == "coach"))
{
str = comboBox1.Text + comboBox2.Text + textBox1.Text;
}
else
{
str = comboBox1.Text + comboBox2.Text + "'" + textBox1.Text + "'";
} sql += str; if (myDataSet.Tables.Contains("SoccerClub"))
{
myDataSet.Tables.Remove("SoccerClub"); } myDataAdapter = new OleDbDataAdapter(sql, myOleConn);
myDataAdapter.Fill(myDataSet, "SoccerClub");
dataGridView1.DataSource = myDataSet.Tables["SoccerClub"];
}
//这个是点击linkLabel1控件触发的事件启动进程
private void linkLabel1_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
{
System.Diagnostics.Process.Start(linkLabel1.Text);
}
//这个估计是你自己点了label1控件才多出来的
private void label1_Click(object sender, EventArgs e)
{ }
}
}
新年第一天帮你注释下
{
InitializeComponent();
}
public void RefreshDG()
{
//判断dataset里面是否包含了SoccerClub表名,存在则删除否则下面查询出来追加
if (myDataSet.Tables.Contains("SoccerClub"))
{
myDataSet.Tables.Remove("SoccerClub");
}
string sql = "select * from SoccerClub";
myDataAdapter = new OleDbDataAdapter(sql, myOleConn);//执行查询
myDataAdapter.Fill(myDataSet, "SoccerClub");
dataGridView1.DataSource = myDataSet.Tables["SoccerClub"];//查出的数据绑定GridView
}//窗体初始化加载combox1数据。
private void Form2_Load(object sender, EventArgs e)
{
comboBox1.Items.Clear();
comboBox1.Items.Add("tID");
comboBox1.Items.Add("firstname");
comboBox1.Items.Add("lastname");
comboBox1.Items.Add("tel");
comboBox1.Items.Add("address");
comboBox1.Items.Add("favoriteTeam");
comboBox1.Items.Add("rentTime");
comboBox1.Items.Add("coach"); try
{
//连接数据字符串
string ConStr = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source="
+ System.Environment.CurrentDirectory + @"/dbSoccer.mdb";
myOleConn = new OleDbConnection(ConStr);
myOleConn.Open();
myDataSet = new DataSet();
RefreshDG();//绑定数据 } catch
{
MessageBox.Show("连接数据库有问题,未连接成功。");
}
}//combox 选择事件
private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
{
comboBox2.Items.Clear();
comboBox2.Items.Add("=");
//一些判断
if ((comboBox1.Text == "tID") ||
(comboBox1.Text == "tel") ||
(comboBox1.Text == "coach"))
{
//上面清除combox后在追加进去
comboBox2.Items.Add(">");
comboBox2.Items.Add(">=");
comboBox2.Items.Add("<");
comboBox2.Items.Add("<="); }
}
// button事件
private void button1_Click(object sender, EventArgs e)
{
//判断条件是否为空
if ((textBox1.Text == "") || (comboBox1.Text == "") || (comboBox2.Text == ""))
{
MessageBox.Show("查询条件不能为空");
return;
}
//sql数据
string sql = "select * from SoccerClub where ";
string str = "";
if ((comboBox1.Text == "tID") ||
(comboBox1.Text == "tel") ||
(comboBox1.Text == "coach"))
{
//查询条件
str = comboBox1.Text + comboBox2.Text + textBox1.Text;
}
else
{//查询条件
str = comboBox1.Text + comboBox2.Text + "'" + textBox1.Text + "'";
} sql += str;//拼接sql
//判断dataset里面是否包含了SoccerClub表名,存在则删除否则下面查询出来追加
if (myDataSet.Tables.Contains("SoccerClub"))
{
myDataSet.Tables.Remove("SoccerClub"); } myDataAdapter = new OleDbDataAdapter(sql, myOleConn);//执行查询
myDataAdapter.Fill(myDataSet, "SoccerClub");
dataGridView1.DataSource = myDataSet.Tables["SoccerClub"];//查出的数据绑定GridView
}
//执行打开文本事件
private void linkLabel1_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
{
System.Diagnostics.Process.Start(linkLabel1.Text);
} private void label1_Click(object sender, EventArgs e)
{ }
}
{
public partial class Form2 : Form
{
DataSet myDataSet;//存放从数据库取来的数据的。
OleDbConnection myOleConn;//连接对象,建立本程序和数据库的连接
OleDbDataAdapter myDataAdapter;//用来执行SQL命令
public Form2()
{
InitializeComponent();
}
public void RefreshDG()
{
//移除旧的数据
if (myDataSet.Tables.Contains("SoccerClub"))
{
myDataSet.Tables.Remove("SoccerClub");
}
//读取所有的SocerClub数据,并绑定到dataGridView1上
string sql = "select * from SoccerClub";
myDataAdapter = new OleDbDataAdapter(sql, myOleConn); //执行sql
myDataAdapter.Fill(myDataSet, "SoccerClub"); //填充dataset
dataGridView1.DataSource = myDataSet.Tables["SoccerClub"]; //绑定数据源
}
private void Form2_Load(object sender, EventArgs e)
{
//设置下拉框选项
comboBox1.Items.Clear();
comboBox1.Items.Add("tID");
comboBox1.Items.Add("firstname");
comboBox1.Items.Add("lastname");
comboBox1.Items.Add("tel");
comboBox1.Items.Add("address");
comboBox1.Items.Add("favoriteTeam");
comboBox1.Items.Add("rentTime");
comboBox1.Items.Add("coach");
try//异常处理
{
//链接数据库
string ConStr = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source="
+ System.Environment.CurrentDirectory + @"/dbSoccer.mdb";
myOleConn = new OleDbConnection(ConStr);
myOleConn.Open();
//读取数据
myDataSet = new DataSet();
RefreshDG();
}
catch
{
MessageBox.Show("连接数据库有问题,未连接成功。");
}
}
private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
{
//根据comboBox1选择内容,设置comboBox2的选项
comboBox2.Items.Clear();
comboBox2.Items.Add("=");
if ((comboBox1.Text == "tID") ||
(comboBox1.Text == "tel") ||
(comboBox1.Text == "coach"))
{
comboBox2.Items.Add(">");
comboBox2.Items.Add(">=");
comboBox2.Items.Add("<");
comboBox2.Items.Add("<=");
}
}
private void button1_Click(object sender, EventArgs e)
{
if ((textBox1.Text == "") || (comboBox1.Text == "") || (comboBox2.Text == ""))
{
MessageBox.Show("查询条件不能为空");
return;
}
string sql = "select * from SoccerClub where ";
string str = "";
if ((comboBox1.Text == "tID") ||
(comboBox1.Text == "tel") ||
(comboBox1.Text == "coach"))
{
str = comboBox1.Text + comboBox2.Text + textBox1.Text;
}
else
{
str = comboBox1.Text + comboBox2.Text + "'" + textBox1.Text + "'";
}
sql += str; //拼sql
if (myDataSet.Tables.Contains("SoccerClub"))
{
myDataSet.Tables.Remove("SoccerClub");
}
//根据条件查询
myDataAdapter = new OleDbDataAdapter(sql, myOleConn);
myDataAdapter.Fill(myDataSet, "SoccerClub");
dataGridView1.DataSource = myDataSet.Tables["SoccerClub"];
}
private void linkLabel1_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
{
//打开某个链接
System.Diagnostics.Process.Start(linkLabel1.Text);
}
private void label1_Click(object sender, EventArgs e)
{
}
}
}
{
public partial class Form2 : Form{
DataSet myDataSet;//存放从数据库取来的数据的。
OleDbConnection myOleConn;//连接对象,建立本程序和数据库的连接
OleDbDataAdapter myDataAdapter;//用来执行SQL命令 public Form2()
{
InitializeComponent();
}
public void RefreshDG()
{
if (myDataSet.Tables.Contains("SoccerClub"))//如果取来的数据是SoccerClub,那么就移除SoccerClub
{
myDataSet.Tables.Remove("SoccerClub");
}
string sql = "select * from SoccerClub";//查出所有SoccerClub的数据
myDataAdapter = new OleDbDataAdapter(sql, myOleConn);
myDataAdapter.Fill(myDataSet, "SoccerClub");
dataGridView1.DataSource = myDataSet.Tables["SoccerClub"];//dataGridView1绑定数据源
} private void Form2_Load(object sender, EventArgs e)
{
comboBox1.Items.Clear();//清空comboBox1的值
comboBox1.Items.Add("tID");//comboBox1的集合中添加下面的属性
comboBox1.Items.Add("firstname");
comboBox1.Items.Add("lastname");
comboBox1.Items.Add("tel");
comboBox1.Items.Add("address");
comboBox1.Items.Add("favoriteTeam");
comboBox1.Items.Add("rentTime");
comboBox1.Items.Add("coach"); try//判断异常处理
{
string ConStr = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source="
+ System.Environment.CurrentDirectory + @"/dbSoccer.mdb";
myOleConn = new OleDbConnection(ConStr);
myOleConn.Open(); myDataSet = new DataSet();
RefreshDG(); } catch
{
MessageBox.Show("连接数据库有问题,未连接成功。");
}
} private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
{
comboBox2.Items.Clear();//清空comboBox2集合内容
comboBox2.Items.Add("=");//comboBox2集合增加等号
if ((comboBox1.Text == "tID") ||
(comboBox1.Text == "tel") ||
(comboBox1.Text == "coach"))//如果comboBox1的text内容等于tID,并且等于tel,并且等于coach,那么comboBox2的集合增加下面内容
{
comboBox2.Items.Add(">");
comboBox2.Items.Add(">=");
comboBox2.Items.Add("<");
comboBox2.Items.Add("<="); }
} private void button1_Click(object sender, EventArgs e)
{
if ((textBox1.Text == "") || (comboBox1.Text == "") || (comboBox2.Text == ""))//如果textBox1,comboBox1,comboBox2为空,那么输出查询条件不能为空。
{
MessageBox.Show("查询条件不能为空");
return;
} string sql = "select * from SoccerClub where ";//
string str = "";
if ((comboBox1.Text == "tID") ||
(comboBox1.Text == "tel") ||
(comboBox1.Text == "coach"))//如果上述条件成立,那么下面三个控件的内容相加,else comboBox1.Text内容加两个引号
{
str = comboBox1.Text + comboBox2.Text + textBox1.Text;
}
else
{
str = comboBox1.Text + comboBox2.Text + "'" + textBox1.Text + "'";
} sql += str; if (myDataSet.Tables.Contains("SoccerClub"))
{
myDataSet.Tables.Remove("SoccerClub"); } myDataAdapter = new OleDbDataAdapter(sql, myOleConn);
myDataAdapter.Fill(myDataSet, "SoccerClub");
dataGridView1.DataSource = myDataSet.Tables["SoccerClub"];
} private void linkLabel1_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
{
System.Diagnostics.Process.Start(linkLabel1.Text);
} private void label1_Click(object sender, EventArgs e)
{ }
}
}
//名称空间 为SoccerVIP
namespace SoccerVIP
{
//类名为Form2
public partial class Form2 : Form {
DataSet myDataSet;//存放从数据库取来的数据的。
OleDbConnection myOleConn;//连接对象,建立本程序和数据库的连接
OleDbDataAdapter myDataAdapter;//用来执行SQL命令 public Form2()
{
//初始化界面
InitializeComponent();
}
public void RefreshDG()
{
//如果myData数据库的数据表中含有SoccerClub表
if (myDataSet.Tables.Contains("SoccerClub"))
{
//移除SoccerClub表
myDataSet.Tables.Remove("SoccerClub");
}
//sql读取表SoccerClub所有结果集
string sql = "select * from SoccerClub";
//实例化一个myDataAdapter对象
myDataAdapter = new OleDbDataAdapter(sql, myOleConn);
//填充myDataSet里面的数据
myDataAdapter.Fill(myDataSet, "SoccerClub");
//将dataGridView1的数据源设置为表SoccerClub ,这样可以显示
dataGridView1.DataSource = myDataSet.Tables["SoccerClub"];
} private void Form2_Load(object sender, EventArgs e)
{
//combox1控件先清除所有项
comboBox1.Items.Clear();
//combox1控件添加ID行
comboBox1.Items.Add("tID");
//combox1控件添加firstname行
comboBox1.Items.Add("firstname");
//combox1控件添加lastname行
comboBox1.Items.Add("lastname");
//combox1控件添加tel行
comboBox1.Items.Add("tel");
//combox1控件添加address行
comboBox1.Items.Add("address");
//combox1控件添加favoriteTeam行
comboBox1.Items.Add("favoriteTeam");
//combox1控件添加rentTime行
comboBox1.Items.Add("rentTime");
//combox1控件添加coach行
comboBox1.Items.Add("coach"); try
{
//声明连接字符串,可以在数据源管理器里面获取该字符串
string ConStr = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source="
+ System.Environment.CurrentDirectory + @"/dbSoccer.mdb";
//连接类 实例化
myOleConn = new OleDbConnection(ConStr);
//打开连接
myOleConn.Open(); //实例化一个 数据集用来存储数据
myDataSet = new DataSet();
//调用RefreshDG函数
RefreshDG(); } catch
{
//当上面操作异常时弹出 连接数据库有问题,未连接成功 的提示
MessageBox.Show("连接数据库有问题,未连接成功。");
}
} private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
{ //comboBox2控件先清除所有项
comboBox2.Items.Clear();
//combox1控件添加"="行
comboBox2.Items.Add("="); //加入combox1 的选项包含 tID 或tel 或coach
if ((comboBox1.Text == "tID") ||
(comboBox1.Text == "tel") ||
(comboBox1.Text == "coach"))
{
//combox2 就添加">"行
comboBox2.Items.Add(">");
//combox2 就添加">="行
comboBox2.Items.Add(">=");
//combox2 就添加"<"行
comboBox2.Items.Add("<");
//combox2 就添加"<="行
comboBox2.Items.Add("<="); }
} private void button1_Click(object sender, EventArgs e)
{
//假如数据为空
if ((textBox1.Text == "") || (comboBox1.Text == "") || (comboBox2.Text == ""))
{
//弹出 查询条件不能为空 提示
MessageBox.Show("查询条件不能为空");
return;
} string sql = "select * from SoccerClub where ";
string str = "";
if ((comboBox1.Text == "tID") ||
(comboBox1.Text == "tel") ||
(comboBox1.Text == "coach"))
{
str = comboBox1.Text + comboBox2.Text + textBox1.Text;
}
else
{
str = comboBox1.Text + comboBox2.Text + "'" + textBox1.Text + "'";
} sql += str; //如果myData数据库的数据表中含有SoccerClub表
if (myDataSet.Tables.Contains("SoccerClub"))
{
//移除SoccerClub表
myDataSet.Tables.Remove("SoccerClub");
} //实例化一个myDataAdapter对象
myDataAdapter = new OleDbDataAdapter(sql, myOleConn);
//填充myDataSet里面的数据
myDataAdapter.Fill(myDataSet, "SoccerClub");
//将dataGridView1的数据源设置为表SoccerClub ,这样可以显示
dataGridView1.DataSource = myDataSet.Tables["SoccerClub"];
} private void linkLabel1_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
{
//启动一个进程名为linkLabel1.Text的连接
System.Diagnostics.Process.Start(linkLabel1.Text);
} private void label1_Click(object sender, EventArgs e)
{ }
}
}
{
/// <summary>
/// 我看不懂,但他确实实现了XXXX功能
/// </summary>
public partial class Form2 : Form
{
DataSet myDataSet;
OleDbConnection myOleConn;
OleDbDataAdapter myDataAdapter; public Form2()
{
InitializeComponent();
}
public void RefreshDG()
{
if (myDataSet.Tables.Contains("SoccerClub"))
{
myDataSet.Tables.Remove("SoccerClub");
}
string sql = "select * from SoccerClub";
myDataAdapter = new OleDbDataAdapter(sql, myOleConn);
myDataAdapter.Fill(myDataSet, "SoccerClub");
dataGridView1.DataSource = myDataSet.Tables["SoccerClub"];
} private void Form2_Load(object sender, EventArgs e)
{
comboBox1.Items.Clear();
comboBox1.Items.Add("tID");
comboBox1.Items.Add("firstname");
comboBox1.Items.Add("lastname");
comboBox1.Items.Add("tel");
comboBox1.Items.Add("address");
comboBox1.Items.Add("favoriteTeam");
comboBox1.Items.Add("rentTime");
comboBox1.Items.Add("coach"); try
{
string ConStr = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source="
+ System.Environment.CurrentDirectory + @"/dbSoccer.mdb";
myOleConn = new OleDbConnection(ConStr);
myOleConn.Open(); myDataSet = new DataSet();
RefreshDG(); } catch
{
MessageBox.Show("连接数据库有问题,未连接成功。");
}
} private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
{
comboBox2.Items.Clear();
comboBox2.Items.Add("=");
if ((comboBox1.Text == "tID") ||
(comboBox1.Text == "tel") ||
(comboBox1.Text == "coach"))
{
comboBox2.Items.Add(">");
comboBox2.Items.Add(">=");
comboBox2.Items.Add("<");
comboBox2.Items.Add("<="); }
} private void button1_Click(object sender, EventArgs e)
{
if ((textBox1.Text == "") || (comboBox1.Text == "") || (comboBox2.Text == ""))
{
MessageBox.Show("查询条件不能为空");
return;
} string sql = "select * from SoccerClub where ";
string str = "";
if ((comboBox1.Text == "tID") ||
(comboBox1.Text == "tel") ||
(comboBox1.Text == "coach"))
{
str = comboBox1.Text + comboBox2.Text + textBox1.Text;
}
else
{
str = comboBox1.Text + comboBox2.Text + "'" + textBox1.Text + "'";
} sql += str; if (myDataSet.Tables.Contains("SoccerClub"))
{
myDataSet.Tables.Remove("SoccerClub"); } myDataAdapter = new OleDbDataAdapter(sql, myOleConn);
myDataAdapter.Fill(myDataSet, "SoccerClub");
dataGridView1.DataSource = myDataSet.Tables["SoccerClub"];
} private void linkLabel1_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
{
System.Diagnostics.Process.Start(linkLabel1.Text);
} private void label1_Click(object sender, EventArgs e)
{ }
}
}我觉得你这样就够了
namespace SoccerVIP
{
public partial class Form2 : Form
{
......
}
}
老实的懒汉:
namespace SoccerVIP
{
/// <summary>
/// 创 建 者:u013342695
/// 我看不懂,但他确实实现了XXXX功能
/// </summary>
public partial class Form2 : Form
{
......
}
}
装X的懒汉:
namespace SoccerVIP
{
/// <summary>
/// 创 建 者:u013342695
/// 实现XXXX功能
/// </summary>
public partial class Form2 : Form
{
......
}
}