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（“修改成功“）;
????????????????}
????????????}
????????}
????}
}

?屬性????????????大小?????日期????時(shí)間???名稱
-----------?---------??----------?-----??----
?????目錄???????????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個(gè)文件信息