课程表管理系统C#

具有 增删改查 四大基本功能 具有注册登录功能 对付软件工程课程设计绰绰有余。

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Windows;
using System.Windows.Controls;
using System.Windows.Data;
using System.Windows.Documents;
using System.Windows.Input;
using System.Windows.Media;
using System.Windows.Media.Imaging;
using System.Windows.Shapes;
using System.Data.SqlClient;

namespace LIWANJIE
{
    /// 

    /// alterCourse.xaml 的交互逻辑
    /// 

    public partial class alterCourse : Window
    {
        public alterCourse（）
        {
            InitializeComponent（）;
            this.Reset（）;
            string dataDir = AppDomain.CurrentDomain.baseDirectory;
            if （dataDir.EndsWith（@“\bin\Debug\“）
                || dataDir.EndsWith（@“\bin\Release\“））
            {
                dataDir = System.IO.Directory.GetParent（dataDir）.Parent.Parent.FullName;
                AppDomain.CurrentDomain.SetData（“DataDirectory“ dataDir）;
            }
        }
        private void Reset（）
        {
            week.Text = string.Empty;
            course.Text = string.Empty;
            place.Text = string.Empty;
        }

        private void back_Click（object sender RoutedEventArgs e）
        {
            LIWANJIE.Window1 w = new Window1（）;
            w.Show（）;
            this.Close（）;
        }

        private void reset_Click（object sender RoutedEventArgs e）
        {
            this.Reset（）;
        }

        private void sure_Click（object sender RoutedEventArgs e）
        {
            using （SqlConnection conn = new SqlConnection（@“Data Source=.\SQLEXPRESS;AttachDBFilename=|DataDirectory|\Student.mdf;Integrated Security = True;User Instance=True“））
            {
                conn.Open（）;
                string t = week.Text.Trim（）;
                string c = course.Text.Trim（）;
                string p = place.Text.Trim（）;
                 
                using （SqlCommand cmd = conn.CreateCommand（））
                {
                    cmd.CommandText = “update course set time=@cplace=@p where studentNumber=@sn and time=@t“;
                    cmd.Parameters.Add（new SqlParameter（“sn“ student.studentnumber））;
                    cmd.Parameters.Add（new SqlParameter（“t“ t））;
                    cmd.Parameters.Add（new SqlParameter（“c“ c））;
                    cmd.Parameters.Add（new SqlParameter（“p“ p））;
                    cmd.ExecuteNonQuery（）;
                    MessageBox.Show（“修改成功“）;
                }
            }
        }
    }
}

 属性            大小     日期    时间   名称
----------- ---------  ---------- -----  ----
     目录           0  2011-12-02 12:28  LIWANJIE\
     目录           0  2011-12-02 12:28  LIWANJIE\LIWANJIE\
     文件         319  2011-11-29 20:33  LIWANJIE\LIWANJIE\App.xaml
     文件         304  2011-11-29 20:33  LIWANJIE\LIWANJIE\App.xaml.cs
     目录           0  2011-12-02 12:28  LIWANJIE\LIWANJIE\Images\
     文件      645198  2011-11-30 12:29  LIWANJIE\LIWANJIE\Images\0d4ff9eeab84f302279791e5.jpg
     文件       85641  2011-11-30 12:27  LIWANJIE\LIWANJIE\Images\1234691290005.jpg
     文件      143948  2011-11-30 12:33  LIWANJIE\LIWANJIE\Images\2913786_150314008_2.jpg
     文件      202147  2011-11-30 12:22  LIWANJIE\LIWANJIE\Images\3701509_193116025587_2.jpg
     文件       99286  2011-11-30 12:29  LIWANJIE\LIWANJIE\Images\599768_002239099_2.jpg
     文件      262317  2011-11-30 12:17  LIWANJIE\LIWANJIE\Images\658932920480893825.jpg
     文件      258077  2011-11-30 12:12  LIWANJIE\LIWANJIE\Images\89523035a5ec5526eac4afeb.jpg
     文件      146650  2011-11-30 12:34  LIWANJIE\LIWANJIE\Images\d36ebc2dc41603684ec2264e.jpg
     文件        8136  2011-11-30 12:35  LIWANJIE\LIWANJIE\LIWANJIE.csproj
     文件         452  2011-11-29 20:57  LIWANJIE\LIWANJIE\LIWANJIE.csproj.user
     文件        1978  2011-12-01 12:41  LIWANJIE\LIWANJIE\MainWindow.xaml
     文件        3991  2011-12-01 13:04  LIWANJIE\LIWANJIE\MainWindow.xaml.cs
     目录           0  2011-12-02 12:28  LIWANJIE\LIWANJIE\Properties\
     文件        2181  2011-11-29 20:33  LIWANJIE\LIWANJIE\Properties\AssemblyInfo.cs
     文件        2866  2011-11-29 20:33  LIWANJIE\LIWANJIE\Properties\Resources.Designer.cs
     文件        5612  2011-11-29 20:33  LIWANJIE\LIWANJIE\Properties\Resources.resx
     文件        1093  2011-11-29 20:33  LIWANJIE\LIWANJIE\Properties\Settings.Designer.cs
     文件         201  2011-11-29 20:33  LIWANJIE\LIWANJIE\Properties\Settings.settings
     文件        1908  2011-11-30 12:35  LIWANJIE\LIWANJIE\Search.xaml
     文件        3332  2011-11-29 21:37  LIWANJIE\LIWANJIE\Search.xaml.cs
     文件     2359296  2012-01-07 16:32  LIWANJIE\LIWANJIE\Student.mdf
     文件      589824  2012-01-07 16:32  LIWANJIE\LIWANJIE\Student_log.LDF
     文件        1278  2011-11-30 12:22  LIWANJIE\LIWANJIE\Window1.xaml
     文件        1293  2011-11-29 21:07  LIWANJIE\LIWANJIE\Window1.xaml.cs
     文件        1795  2011-11-30 12:35  LIWANJIE\LIWANJIE\alterCourse.xaml
     文件        2593  2011-11-29 21:13  LIWANJIE\LIWANJIE\alterCourse.xaml.cs
............此处省略48个文件信息