database.cs

C#连接式访问数据库,最初级的数据库SQL 2005操作

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;
using System.Collections;
namespace DataBase
{
    public partial class DataBase : Form
    {

        private SqlCtrl sqlCtrl;
        
        public DataBase()
        {
            
            InitializeComponent();
        }

        //连
        private void connBtn_Click(object sender, EventArgs e)
        {

                sqlCtrl = new SqlCtrl(serverTxt.Text, databaseTxt.Text, uidTxt.Text, pwdTxt.Text);
                MessageBox.Show("OK");


        }

        //增
        private void addBtn_Click(object sender, EventArgs e)
        {

                int id = int.Parse(idTxt.Text.Trim());
                string name= nameTxt.Text.Trim();
                int age = int.Parse(ageTxt.Text.Trim());

                sqlCtrl.AddData(id,name,age);

        }

      

        //删
        private void delBtn_Click(object sender, EventArgs e)
        {

                sqlCtrl.DelData(Convert.ToInt32(idTxt.Text.Trim()));

        }

        //改
        private void changeBtn_Click(object sender, EventArgs e)
        {
             sqlCtrl.ChangeData(idTxt.Text, nameTxt.Text,ageTxt.Text);

        }

        //查
        private void selectBtn_Click(object sender, EventArgs e)
        {
           
                resuleTxt.Text = "";

                ArrayList result=sqlCtrl.SelectData();

                for (int i = 0; i < result.Count;i++ )
                {
                    resuleTxt.Text+= result[i].ToString()+Environment.NewLine;
                }
               
         
        }


        //关
        private void shutBtn_Click(object sender, EventArgs e)
        {

            sqlCtrl.ShutData();
        }
    }
}