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条回答

    报告相同问题?

    悬赏问题

    • ¥30 这是哪个作者做的宝宝起名网站
    • ¥60 版本过低apk如何修改可以兼容新的安卓系统
    • ¥25 由IPR导致的DRIVER_POWER_STATE_FAILURE蓝屏
    • ¥50 有数据,怎么建立模型求影响全要素生产率的因素
    • ¥50 有数据,怎么用matlab求全要素生产率
    • ¥15 TI的insta-spin例程
    • ¥15 完成下列问题完成下列问题
    • ¥15 C#算法问题, 不知道怎么处理这个数据的转换
    • ¥15 YoloV5 第三方库的版本对照问题
    • ¥15 请完成下列相关问题!