扣扣图标动态加载的功能 1130

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using System.Data.SqlClient;

namespace WindowsFormsApplication30
{
    public partial class QQForm : Form
    {
        public QQForm()
        {
            InitializeComponent();
        }
        
        // 大图模式的点击事件
        private void tsmiBigView_Click(object sender, EventArgs e)
        {
            lvQQMenu.View = View.LargeIcon;
        }

        private void tsmiSmallView_Click(object sender, EventArgs e)
        {
            lvQQMenu.View = View.SmallIcon;
        }

        private void tsmiDetialView_Click(object sender, EventArgs e)
        {
            lvQQMenu.View = View.Details;
        }

        // 窗体加载事件
        private void QQForm_Load(object sender, EventArgs e)
        {
            // 绑定数据
            BindData();
        }

        // 绑定数据的方法
        public void BindData() {
            // 连接字符串
            String connStr = "Data Source=.;Initial Catalog=dbok;User ID=sa;Password=root123123";

            // 连接对象
            SqlConnection conn = new SqlConnection(connStr);


            // sql语句
            String sql = "select * from sanguo";

            // 执法者
            SqlCommand cmd = new SqlCommand(sql, conn);

            // 打开连接
            conn.Open();

            // 执法者获取所有的数据
            SqlDataReader result = cmd.ExecuteReader();

            // 遍历结果，拿到想要的数据
            while(result.Read()){
                // String name =(String)result["name"];
                String name = Convert.ToString(result["name"]);
                int attack = (int)result["attack"];
                String country = result["country"].ToString();
                int imgIndex = Convert.ToInt32(result["imgIndex"]);

                // 利用拿到的数据，生成一个项
                ListViewItem item = new ListViewItem();
                item.Text = name;
                item.ImageIndex = imgIndex;
                // 给项添加子项
                item.SubItems.Add(country);
                item.SubItems.Add(Convert.ToString(attack));

                // 把生成的这个项，放到listview对象的items集合中
                lvQQMenu.Items.Add(item);

            }


        }
    }
}