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条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥15 教务系统账号被盗号如何追溯设备
    • ¥20 delta降尺度方法,未来数据怎么降尺度
    • ¥15 c# 使用NPOI快速将datatable数据导入excel中指定sheet,要求快速高效
    • ¥15 再不同版本的系统上,TCP传输速度不一致
    • ¥15 高德地图点聚合中Marker的位置无法实时更新
    • ¥15 DIFY API Endpoint 问题。
    • ¥20 sub地址DHCP问题
    • ¥15 delta降尺度计算的一些细节,有偿
    • ¥15 Arduino红外遥控代码有问题
    • ¥15 数值计算离散正交多项式