C# (CSharp) UserSQL.getAllUser示例

示例#1

        private void Form1_Load(object sender, EventArgs e)
        {
            DataTable dt = UserSQL.getAllUser();

            if (dt != null)
            {
                this.dataGridView1.Rows.Clear();
                for (int i = 0; i < dt.Rows.Count; i++)
                {
                    this.dataGridView1.Rows.Add(i + 1,
                                                dt.Rows[i]["UserName"],
                                                dt.Rows[i]["UserRole"],
                                                "删除");
                    this.dataGridView1.Rows[i].Tag = dt.Rows[i];
                }
            }
            this.dataGridView1.ClearSelection();
        }

示例#2

        private void ReFresh()
        {
            this.dataGridView1.Rows.Clear();
            DataTable dt = UserSQL.getAllUser();

            if (dt != null)
            {
                this.dataGridView1.Rows.Clear();
                for (int i = 0; i < dt.Rows.Count; i++)
                {
                    this.dataGridView1.Rows.Add(i + 1,
                                                dt.Rows[i]["UserName"],
                                                dt.Rows[i]["UserRole"],
                                                "删除");
                    this.dataGridView1.Rows[i].Tag = dt.Rows[i];
                }
            }
            this.dataGridView1.ClearSelection();
        }