今天写了个c#下listview的排序，若果显示的量小，用这个感觉很方便。mysql的数据库

本文链接：https://blog.csdn.net/woshidaniu/article/details/39451591

      private int g_nColumn = 0;
        private int g_nSort = 0;
        private string[] g_column = { "id", "username", "pwd", "t1", "t2", "t3", "t4", "t5", "t6" };

        private void listView1_ColumnClick(object sender, ColumnClickEventArgs e)
        {
            try
            {
                listView1.Items.Clear();

                MySqlClientFactory factory = MySqlClientFactory.Instance;
                MySqlConnection conn = new MySqlConnection();
                conn.ConnectionString = string.Format("server={0};user id={1}; password={2}; database={3}; port={4}; pooling=false",
                            "ServerAddress", "tb_user", "uername", "pwd", 3306);
                conn.Open();
                string strSql ="";
                if (g_nSort == 0)
                {
                    strSql = String.Format("select * from tb");
                }
                if (g_nSort == 1)
                {
                    strSql = String.Format("select * from tb order by {0} DESC",g_column[e.Column]);
                }
                if (g_nSort == 2)
                {
                    strSql = String.Format("select * from tb order by {0}", g_column[e.Column]);
                }
                MySqlDataAdapter mysqlDa = new MySqlDataAdapter(strSql, conn);
                DataTable tb = new DataTable();
                mysqlDa.Fill(tb);

                conn.Close();

                g_nSort += 1;
                g_nSort = g_nSort % 3;
                listView1.Items.Clear();
                for (int i = 0; i < tb.Rows.Count; i++)
                {
                    ListViewItem lt = new ListViewItem(tb.Rows[i][0].ToString());
                    lt.SubItems.Add(tb.Rows[i][1].ToString());
                    lt.SubItems.Add(tb.Rows[i][2].ToString());
                    lt.SubItems.Add(tb.Rows[i][3].ToString());
                    lt.SubItems.Add(tb.Rows[i][4].ToString());
                    lt.SubItems.Add(tb.Rows[i][5].ToString());
                    lt.SubItems.Add(tb.Rows[i][6].ToString());
                    lt.SubItems.Add(tb.Rows[i][7].ToString());
                    lt.SubItems.Add(tb.Rows[i][8].ToString());
                    listView1.Items.Add(lt);

                }
            }
            catch (Exception ex)
            {
                //MessageBox.Show(ex.Message);
            }
        }