form6.cs

vs2008 组织部信息系统

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

namespace 团委组织部信息系统
{
    public partial class Form6 : Form
    {
        public Form6()
        {
            
            InitializeComponent();
        }

        private void Form6_Load(object sender, EventArgs e)
        {
            // TODO: 这行代码将数据加载到表“tuanweizuzhibu_infDataSet.erjibuzhang_inf”中。您可以根据需要移动或移除它。
            this.erjibuzhang_infTableAdapter.Fill(this.tuanweizuzhibu_infDataSet.erjibuzhang_inf);

        }

        private void erjibuzhang_infBindingNavigatorSaveItem_Click(object sender, EventArgs e)
        {
            this.Validate();
            this.erjibuzhang_infBindingSource.EndEdit();
            this.tableAdapterManager.UpdateAll(this.tuanweizuzhibu_infDataSet);

        }

        private void button3_Click(object sender, EventArgs e)
        {

            SqlDataAdapter da;
            DataSet ds;
; 
            string connectionstring = @"data source=localhost;Initial catalog=tuanweizuzhibu_inf;integrated security=SSPI;";
            string commandstring = @"select * from erjibuzhang_inf where colleage like'" + comboBox3.Text + "'";
            da = new SqlDataAdapter(commandstring, connectionstring);
            ds = new DataSet();
            da.Fill(ds, "erjibuzhang_inf");
            erjibuzhang_infDataGridView.DataSource = ds.Tables["erjibuzhang_inf"];
        }

        private void button4_Click(object sender, EventArgs e)
        {
            this.Hide();
        }

        private void button1_Click(object sender, EventArgs e)
        {
            SqlDataAdapter da;
            DataSet ds;
            string connectionstring = @"data source=localhost;Initial catalog=tuanweizuzhibu_inf;integrated security=SSPI;";
            string commandstring = @"select * from erjibuzhang_inf ";
            SqlConnection conn = new SqlConnection(connectionstring);
            string sqlStatement = "UPDATE erjibuzhang_inf SET " +
                    "姓名='" + nameTextBox.Text + "'," +
                    "学院='" + colleageTextBox.Text + "'" +
                    "手机号码='" + phoneNumTextBox.Text + "'" +
                    "WHERE 姓名 = '" + nameTextBox.Text + "'";
            SqlCommand cmd = new SqlCommand(sqlStatement, conn);
            try
            {
                conn.Open();
                int rowAffected = cmd.ExecuteNonQuery();
                if (rowAffected == 1)
                {
                    da = new SqlDataAdapter(commandstring, connectionstring);
                    ds = new DataSet();
                    da.Fill(ds, "erjibuzhang_inf");
                    MessageBox.Show("修改成功!");
                    erjibuzhang_infDataGridView.DataSource = ds.Tables["erjibuzhang_inf"];
                    nameTextBox.Text = "";
                    colleageTextBox.Text = "";
                    phoneNumTextBox.Text = "";
                }

            }

            catch (SqlException ex)
            {
                MessageBox.Show("修改失败：" + ex.Message, "出现错误",
                    MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
            finally
            {

                conn.Close();
            }

        
        }

        private void button5_Click(object sender, EventArgs e)
        {
            nameTextBox.Text = "";
            colleageTextBox.Text = "";
            phoneNumTextBox.Text = "";
        }

        private void button6_Click(object sender, EventArgs e)
        {
            SqlDataAdapter da;
            DataSet ds;
            string connectionstring = @"data source=localhost;Initial catalog=tuanweizuzhibu_inf;integrated security=SSPI;";
            string commandstring = @"select * from erjibuzhang_inf ";
            if (colleageTextBox.Text == "")
            { MessageBox.Show(" 学院不能为空！"); }
            else
            {

                SqlConnection conn = new SqlConnection(connectionstring);
                SqlCommand cmd = new SqlCommand(commandstring, conn);
                SqlDataReader dr;
                int prime = 0;
                conn.Open();
                dr = cmd.ExecuteReader();
                while (dr.Read())
                {
                    if (dr.GetString(0) == colleageTextBox.Text)
                    {
                        MessageBox.Show("学院已存在，不能添加相同学院的部长信息！");
                        prime = 1;
                        break;
                    }
                }
                if (prime == 0)
                    try
                    {
                        da = new SqlDataAdapter(commandstring, connectionstring);
                        SqlCommandBuilder scb = new SqlCommandBuilder(da);
                        ds = new DataSet();
                        da.Fill(ds, "erjibuzhang_inf");
                        DataTable mytable = ds.Tables["erjibuzhang_inf"];
                        DataRow myrow = ds.Tables["erjibuzhang_inf"].NewRow();
                        myrow[0] = nameTextBox.Text.ToString();
                        myrow[1] = colleageTextBox.Text.ToString();
                        myrow[2] = phoneNumTextBox.Text.ToString();


                        mytable.Rows.Add(myrow);
                        da.Update(ds, "erjibuzhang_inf");
                        ds.AcceptChanges();
                        MessageBox.Show("添加成功!");
                        erjibuzhang_infDataGridView.DataSource = ds.Tables["erjibuzhang_inf"];
                    }
                    catch (SqlException ex)
                    {
                        MessageBox.Show("添加失败：" + ex.Message, "出现错误",
                            MessageBoxButtons.OK, MessageBoxIcon.Error);
                    }
                    finally
                    {
                        dr.Close();
                        conn.Close();
                    }
            }
        }

        private void erjibuzhang_infDataGridView_CellContentClick(object sender, DataGridViewCellEventArgs e)
        {

            nameTextBox.Text = erjibuzhang_infDataGridView.Rows[e.RowIndex].Cells[0].Value.ToString();
            colleageTextBox.Text = erjibuzhang_infDataGridView.Rows[e.RowIndex].Cells[1].Value.ToString();
            phoneNumTextBox.Text = erjibuzhang_infDataGridView.Rows[e.RowIndex].Cells[2].Value.ToString();
        }
    }
}