109809 2014-01-01 02:29
浏览 949

求注释程序!!!最好一段一注释!!!,不行一行也行!!!!

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)
    {

    }
}

}

  • 写回答

0条回答

    报告相同问题?

    悬赏问题

    • ¥20 有关区间dp的问题求解
    • ¥15 多电路系统共用电源的串扰问题
    • ¥15 slam rangenet++配置
    • ¥15 有没有研究水声通信方面的帮我改俩matlab代码
    • ¥15 对于相关问题的求解与代码
    • ¥15 ubuntu子系统密码忘记
    • ¥15 信号傅里叶变换在matlab上遇到的小问题请求帮助
    • ¥15 保护模式-系统加载-段寄存器
    • ¥15 电脑桌面设定一个区域禁止鼠标操作
    • ¥15 求NPF226060磁芯的详细资料