string strcmd;
                if (txtloginname.Text != "" && txtpassword.Text != "")
                {
                    strcmd = "select * from EmployeesCompetence where employeeid=" + txtloginname.Text + " and pwd='" + txtpassword.Text + "'";
                    login.Select(strcmd, "login");
                    if (sql.ds.Tables["login"].Rows.Count != 0)
                    {
                        Form mainfrm = new FrmMain();
                        mainfrm.Show();
                        this.Hide();
                    }
                    else
                        MessageBox.Show("用户名或密码错误！");
                }
这个是我做的登陆界面确定的代码，怎么在这里加上权限判断呢，先谢啦

论坛有过类似的帖子 楼主可以加一个权限的字段

版主可以加q么，我正在做一个课程设计，有很多东西不懂啊

浮萍漂泊本无根 天涯游子君莫问  有问题还是发帖子吧

。。。。。。。。在那段代码中加一个什么字段来判断权限呢

建立一个权限表 ID(int) 用户身份(nvarchar) 指定模块权限(bit)等等  EmployeesCompetence放一个权限表的ID

是在select语句中加入这张权限表，然后where语句查询这个权限的字段，判断在登陆界面选择的权限是否与这个表中的数据一致对么？

恩 对 权限表 ID其实就是外键

恩，谢谢版主啊，我搞下试试，不行的话我在问啊

版主在么，做完登录界面后，程序崩溃，显示数据库登录失败： public static  DataSet ds = new DataSet();
        public static string connstring = "server=.;database=ssxt;uid=sa;pwd=123456;";
        //执行select命令，并返回结果写入数据集的表中
        public bool  Select(string cmdstr, string tablename)
        {

               SqlConnection  conn = new SqlConnection(connstring);
                conn.Open();
                SqlCommand cmd = new SqlCommand(cmdstr, conn);
                cmd.ExecuteNonQuery();
                SqlDataAdapter sda = new SqlDataAdapter(cmd);
                sda.Fill(ds, tablename);
                conn.Close();
                return true;

        }
        public void Insert(string cmdstr)
        {
            SqlConnection conn = new SqlConnection(connstring);
            conn.Open();
            SqlCommand cmd = new SqlCommand(cmdstr, conn);
            cmd.ExecuteNonQuery();
            conn.Close();
        }
        public void Update(string cmdstr)
        {
            SqlConnection conn = new SqlConnection(connstring);
            conn.Open();
            SqlCommand cmd = new SqlCommand(cmdstr, conn);
            cmd.ExecuteNonQuery();
            conn.Close();
        }
        public void Delete(string cmdstr)
        {
            SqlConnection conn = new SqlConnection(connstring);
            conn.Open();
            SqlCommand cmd = new SqlCommand(cmdstr, conn);
            cmd.ExecuteNonQuery();
            conn.Close();
这个是我编写的类，运行后出现：  这个是我的按钮代码： sql login = new sql();
        private void button1_Click(object sender, EventArgs e)
        {
            string strcmd;
            if (txtloginname.Text != "" && txtpassword.Text != "")
            {
                strcmd = "select * from ygb where yg_id=" + txtloginname.Text + " and mm='" + txtpassword.Text + "'";
                login.Select(strcmd, "login");
                if (sql.ds.Tables["login"].Rows.Count != 0)
                {
                    Form GLYJM = new frmlogin();
                    GLYJM.Show();
                    this.Hide();
                }
                else
                    MessageBox.Show("用户名或密码错误！");
            }