/// <summary>
/// 输入上传用户名来搜索文件
/// </summary>
private void SearchFile_Click(object sender, RoutedEventArgs e)
{
//清空文件列表
infoList.Clear();
//Stu为单个文件
Filename Stu = new Filename();
#region 数据库连接
SqlConnection myConnection;
string connStr = "Server ='" + IPAddress.ip + "'; database =测试数据库; uid =sa; pwd=1738010002";
//string connStr = @"Server = LAPTOP-25MJ4H0M\SQLEXPRESS; database =教学系统; Trusted_Connection=SSPI";
myConnection = new SqlConnection(connStr);
try
{
myConnection.Open();
}
catch (Exception)
{
MessageBox.Show("连接失败");
}
#endregion
//从数据库读取上传人为输入值的文件
SqlCommand cmd2 = new SqlCommand("select 上传人,文件标题 from zyb where 上传人 = '" + FileBox.Text + "'", myConnection);
SqlDataReader sdr2 = cmd2.ExecuteReader();
//循环读取文件并将其加入文件列表
while (sdr2.Read())
{
Stu.Uploader = sdr2[0].ToString();
Stu.File_Name = sdr2[1].ToString();
infoList.Add(Stu);
}
sdr2.Close();
myConnection.Close();
myConnection.Dispose();
//关闭连接
//重新绑定datagrid数据源
DG_FilStu.AutoGenerateColumns = false;
DG_FilStu.ItemsSource = null;
DG_FilStu.ItemsSource = infoList;
}
public FileStu()
{
InitializeComponent();
WindowStartupLocation = WindowStartupLocation.CenterScreen;
//建立定时器，时间间隔为1s，并启动定时器
//Stu为单个文件的信息集
Filename Stu = new Filename();
#region 数据库连接
SqlConnection myConnection;
string connStr = "Server ='" + IPAddress.ip + "'; database =测试数据库; uid =sa; pwd=1738010002";
//string connStr = @"Server = LAPTOP-25MJ4H0M\SQLEXPRESS; database =教学系统; Trusted_Connection=SSPI";
myConnection = new SqlConnection(connStr);
try
{
myConnection.Open();
}
catch (Exception)
{
MessageBox.Show("连接失败");
}
#endregion
//从服务器中查询所有文件的列表
SqlCommand cmd2 = new SqlCommand("select 上传人,文件标题 from zyb", myConnection);
SqlDataReader sdr2 = cmd2.ExecuteReader();
//循环读取数据库文件并将其添加到文件列表
while (sdr2.Read())
{
Stu.Uploader = sdr2[0].ToString();
Stu.File_Name = sdr2[1].ToString();
infoList.Add(Stu);
}
sdr2.Close();
myConnection.Close();
myConnection.Dispose();
//关闭数据库连接
DG_FilStu.AutoGenerateColumns = false;
DG_FilStu.ItemsSource = infoList;
//绑定datagrid的数据源为文件列表
}
