/// <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的数据源为文件列表 }