系统应用管理 C#第三章课上练习

最新推荐文章于 2019-10-16 09:38:22 发布

原创最新推荐文章于 2019-10-16 09:38:22 发布 · 438 阅读

CC 4.0 BY-SA版权

本文介绍了一个使用 C# 编写的简单示例程序，演示了如何通过按钮点击事件更改 ListView 的视图显示方式，并展示了如何从数据库中加载数据到 ListView 中。示例包括了 LargeIcon、SmallIcon 和 Details 视图的切换。

private void button1_Click(object sender, EventArgs e)
        {
            this.listView1.View = View.LargeIcon;
        }

        private void button2_Click(object sender, EventArgs e)
        {
            this.listView1.View = View.SmallIcon;
        }

        private void button3_Click(object sender, EventArgs e)
        {
            this.listView1.View = View.Details;
        }

        private void contextMenuStrip1_Opening(object sender, CancelEventArgs e)
        {


        }

        private void listView1_SelectedIndexChanged(object sender, EventArgs e)
        {

        }

        private void Form1_Load(object sender, EventArgs e)
        {
            ListViewItem lvi1 = new ListViewItem("苏琳琳", 0);
            lvi1.SubItems.Add("24G");
            lvi1.SubItems.Add("本地磁盘");
            lvi1.SubItems.Add("13G");
            ListViewItem lvi2 = new ListViewItem("苏琳", 0);
            lvi2.SubItems.AddRange(new string[] { "34G", "本地磁盘", "12G" });
            this.listView1.Items.Add(lvi1);
            this.listView1.Items.Add(lvi2);
        }
        public String str = "Data Source=.;Initial Catalog=MySchool;Integrated Security=True";
        private void FillListView()
        {

            if (listView1.Items.Count > 0)
            {
                listView1.Items.Clear();
            }
            StringBuilder sql = new StringBuilder();
            sql.AppendLine("SELECT S.[StudentNo],S.[StudentName],S.[Sex],G.[GradeName]");
            sql.AppendLine("FROM Student AS S,Grade AS G");
            sql.AppendLine("WHERE S.[GradeId]=G.[GradeId]");
            sql.AppendFormat("AND S.[StudentName] LIKE '%{0}%'",this.textBox1.Text.Trim());
            第三章上机练习.DBHelper s = new 第三章上机练习.DBHelper();
            try
            {

                SqlCommand cammand = new SqlCommand(sql.ToString(), s.Connection);
                s.OpenConnection();
                SqlDataReader reader = cammand.ExecuteReader();
                if (!reader.HasRows)
                {
                    MessageBox.Show("没有要查询的记录", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                }
                else
                {
                    while (reader.Read())
                    {
                        string studentNo = reader["StudentNo"].ToString();
                        string studentName = reader["StudentName"].ToString();
                        string sex = reader["Sex"].ToString();
                        string gradeName = reader["GradeName"].ToString();
                        ListViewItem item = new ListViewItem(studentNo);
                        item.SubItems.Add(studentName);
                        item.SubItems.Add(sex);
                        item.SubItems.Add(gradeName);
                        listView1.Items.Add(item);



                    }
                }
                reader.Close();
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message, "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);

            }
            finally {
                s.CloseConnection();
            }
        
        }

        private void button4_Click(object sender, EventArgs e)
        {
            FillListView();
        }