.net下用c# 编写成语字典查询工具

呵呵,以前弄的一个成语字典数据库.最近用C#写了个查询工具.

界面:

 

源代码如下:

 

// http://blog.csdn.net/greenerycn
// 请遵守署名非商业的CC版权.

using  System;
using  System.Collections.Generic;
using  System.ComponentModel;
using  System.Data;
using  System.Drawing;
using  System.Text;
using  System.Windows.Forms;
using  System.Data.OleDb;

namespace  CyDict
... {
    public partial class Form1 : Form
    ...{
        public Form1()
        ...{
            InitializeComponent();
        }

        private void Form1_Load(object sender, EventArgs e)
        ...{


            this.reportViewer1.RefreshReport();
        }

        private void button1_Click(object sender, EventArgs e)
        ...{
           //连接数据库
            string con_str = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=cy.mdb";
          //sql语句
            string sql_str = "SELECT * FROM [cy] WHERE ([成语]=@cy_name)";
            OleDbConnection db_conn = new OleDbConnection(con_str);
            db_conn.Open();
            OleDbCommand cm=new OleDbCommand (sql_str,db_conn);
            cm.Parameters.Add(new OleDbParameter("@cy_name",OleDbType.Variant,4));
            cm.Parameters["@cy_name"].Value=txt_input.Text.Trim();
           //查询数据库
            OleDbDataReader reader=cm.ExecuteReader();
            if (reader.Read())
            ...{
                string[] result = new string[9];
                result[0] = "成语: " + reader["成语"].ToString();
                result[2] = "解释: " + reader["解释"].ToString();
                result[1] = "拼音: " + reader["拼音"].ToString();
                result[3] = "近义: " + reader["近义"].ToString();
                result[4] = "反义: " + reader["反义"].ToString();
                result[5] = "出处: " + reader["出处"].ToString();
                result[7] = "示例: " + reader["示例"].ToString();
                result[6] = "典故: " + reader["典故"].ToString();
                txt_Result.Lines = result;
            }
            else
            ...{
                txt_Result.Text = "无此成语,本词典收录数据6000条!";
            }
           //不要忘了关闭.
            reader.Close();
            db_conn.Close();

        }

    }
}