通过C#操作数据库

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 SQL
{
    public partial class Form1 : Form
    {
        SqlConnection MyConnect = new SqlConnection();

        public Form1()
        {
            InitializeComponent();
        }

        private void LinkDatabase_Click(object sender, EventArgs e)
        {
            MyConnect.ConnectionString = "Data Source =(local); Initial Catalog = yyj; User ID = yangyanjie; Password = 123456"; //中            间不能有任何引号
            MyConnect.Open();
            MessageBox.Show("打开数据库成功");
        }

        private void CreateTable_Click(object sender, EventArgs e)
        {
            SqlCommand CreateTableCmd = new SqlCommand();
            CreateTableCmd.Connection = MyConnect;
            CreateTableCmd.CommandType = CommandType.Text;
            CreateTableCmd.CommandText = "CREATE TABLE Teacher(Tea_ID nchar(10) NOT NULL Primary Key, Name nchar(20) NOT NULL, Sex nc            har(8) NOT NULL, Address nchar(40) NOT NULL)";
            //      CreateTableCmd.ExecuteScalar();
            CreateTableCmd.CommandText = "CREATE TABLE Student(Stu_ID nchar(10) NOT NULL Primary Key, Name nchar(20) NOT NULL, Sex nc            har(8) NOT NULL, Phone nchar(18) NOT NULL, Address nchar(40) NOT NULL)";
             //       CreateTableCmd.ExecuteScalar();
            CreateTableCmd.CommandText = "CREATE TABLE Money(Stu_ID nchar(10) NOT NULL Primary Key, Name nchar(20) NOT NULL, Phone nc            har(18) NOT NULL, Year money NOT NULL)";
            //       CreateTableCmd.ExecuteScalar();
            CreateTableCmd.CommandText = "CREATE TABLE Subject(Sub_ID nchar(10) NOT NULL Primary Key, Sub_Name nchar(20) NOT NULL, Sc            ore smallint NOT NULL)";
            CreateTableCmd.ExecuteScalar();
            CreateTableCmd.CommandText = "CREATE TABLE AddrBook(Name nchar(20) NOT NULL Primary Key, Score smallint NOT NULL, Phone n            char(18) NOT NULL, QQ nchar(15) NOT NULL, Address nchar(40) NOT NULL)";
            CreateTableCmd.ExecuteScalar();

            MessageBox.Show("创建表格成功");
        }

        private void AlterTable_Click(object sender, EventArgs e)
        {
            SqlCommand CreateTableCmd = new SqlCommand();
            CreateTableCmd.Connection = MyConnect;
            CreateTableCmd.CommandType = CommandType.Text;
            CreateTableCmd.CommandText = "ALTER TABLE  add name_123 nchar(18)";
            CreateTableCmd.ExecuteScalar();

            MessageBox.Show("修改表格成功");
        }

        private void DropTable_Click(object sender, EventArgs e)
        {
            SqlCommand CreatetableCmd = new SqlCommand();
            CreatetableCmd.Connection = MyConnect;
            CreatetableCmd.CommandType = CommandType.Text;
            CreatetableCmd.CommandText = "DROP TABLE dd";
            CreatetableCmd.ExecuteScalar();

            MessageBox.Show("删除表格成功");
        }

        private void CloseDatabase_Click(object sender, EventArgs e)
        {
            MyConnect.Close();
            MessageBox.Show("关闭数据库成功");
        }
    }
}