contractform.cs

数据库开发房产中介管理系统 VC2005开发环境SQL2005版本

//文件名：ContractForm.cs
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.SqlClient;

namespace MyHouse
{
    public partial class ContractForm : Form
    {
        public ContractForm()
        {
            InitializeComponent();
        }

        private void 租售成交管理BindingNavigatorSaveItem_Click(object sender, EventArgs e)
        {
            this.Validate();
            this.租售成交管理BindingSource.EndEdit();
            this.租售成交管理TableAdapter.Update(this.myHouseDataSet.租售成交管理);

        }

        private void ContractForm_Load(object sender, EventArgs e)
        {
            // TODO: 这行代码将数据加载到表“myHouseDataSet.租售成交管理”中。您可以根据需要移动或移除它。
            this.租售成交管理TableAdapter.Fill(this.myHouseDataSet.租售成交管理);
            String MySQLConnectionString = global::MyHouse.Properties.Settings.Default.MyHouseConnectionString;
            SqlConnection MyConnection = new SqlConnection(MySQLConnectionString);
            MyConnection.Open();            
            String MySQL = "Select * From 公司职员信息";
            DataTable MyPersonnelTable = new DataTable();
            SqlDataAdapter MyAdapter = new SqlDataAdapter(MySQL, MyConnection);
            MyAdapter.Fill(MyPersonnelTable);
            string MyName = "姓名";
            string MyValue = MyPersonnelTable.Rows[0][MyName].ToString();
            foreach (DataRow MyRow in MyPersonnelTable.Rows)
            {
                this.经办人ComboBox.Items.Add(MyRow[MyName].ToString());
            }
            if (MyConnection.State == ConnectionState.Open)
            {
                MyConnection.Close();
            }
        }

        private void 显示文件Button_Click(object sender, EventArgs e)
        {
            string MyPath = Environment.CurrentDirectory + "\\Data\\" + this.文件名TextBox.Text;
            System.Diagnostics.Process.Start(MyPath);
        }

        private void 查询ToolStripButton_Click(object sender, EventArgs e)
        {
            try
            {
                this.租售成交管理TableAdapter.FillBy(this.myHouseDataSet.租售成交管理, 资料编号ToolStripTextBox.Text, 经办人ToolStripTextBox.Text);
            }
            catch (System.Exception ex)
            {
                System.Windows.Forms.MessageBox.Show(ex.Message);
            }
        }   

      
    }
}