Example #1
0
        private void button11_Click(object sender, EventArgs e)
        {
            string          s    = "";
            OleDbConnection conn = new OleDbConnection(accesspath);

            if (button11.Text == "查看帖子")
            {
                conn = new OleDbConnection(accesspath);
                panel_tiezi.Visible = true;
                OleDbDataAdapter da = new OleDbDataAdapter("select * from tiezi", conn);
                DataTable        dt = new DataTable();
                da.Fill(dt);
                //dt.Columns.Remove("ID");
                //  dt.Columns.Remove("发帖时间(数字)");
                dataGridView4.DataSource                  = dt;
                dataGridView4.Columns["ID"].Visible       = false;
                dataGridView4.Columns["发帖时间(数字)"].Visible = false;
                conn.Close();
                conn.Dispose();
                da.Dispose();
            }
            if (button11.Text == "发表帖子")
            {
                string           str = "select * from login where 用户名='" + label36.Text + "'";
                OleDbDataAdapter da  = new OleDbDataAdapter(str, conn);
                DataSet          ds  = new DataSet();
                da.Fill(ds, "login");
                s = ds.Tables["login"].Rows[0]["姓名"].ToString();
                tiezi f = new tiezi();
                f.Show();
                f.label1.Text          = s;
                f.panel_ttiezi.Visible = false;
                f.panel_stiezi.Visible = true;
                conn.Open();
                conn.Dispose();
                da.Dispose();
            }
            if (button11.Text == "查看帖子 ")
            {
                string           str = "select * from login where 用户名='" + label36.Text + "'";
                OleDbDataAdapter da  = new OleDbDataAdapter(str, conn);
                DataSet          ds  = new DataSet();
                da.Fill(ds, "login");
                s = ds.Tables["login"].Rows[0]["编号"].ToString();
                tiezi f = new tiezi();
                f.Show();
                f.label1.Text          = s;
                f.panel_ttiezi.Visible = true;
                f.panel_stiezi.Visible = false;
                conn.Open();
                conn.Dispose();
                da.Dispose();
            }
        }
Example #2
0
        private void label41_Click(object sender, EventArgs e)
        {
            tiezi f = new tiezi();

            f.Show();
            f.label1.Text            = "管理员";
            f.panel_ttiezi.Visible   = true;
            f.panel_stiezi.Visible   = false;
            f.button4.Visible        = true;
            f.dataGridView2.ReadOnly = false;
            f.dataGridView2.Columns["Column1"].Visible = true;
        }