Login为登录窗体，Form1为主窗体. button1为Login窗体中的登录按钮

为什么无论用任何用户登录，都是管理员的用户界面？
小弟刚入门，想了好久仍然没有找到原因，还望各位赐教~




                  private void button1_Click(object sender, EventArgs e)
             {
                           
                            ...............
                             
                            conn.Open();
                             
                            ...............

                            string userlimit = "select userlimit form UserInfo where userid='"+textBox1.Text.Trim()+"'and userpwd='"+textBox2.Text.Trim()+"'";
                            Form1 form1 = new Form1();
                            if (userlimit=="0")//学生权限
                                
                            {      
                                
                                form1.toolStripButton1.Enabled = false;
                                form1.toolStripButton2.Enabled = false;
                                form1.toolStripButton3.Enabled = false;
                                form1.toolStripButton4.Enabled = true;
                                form1.toolStripButton5.Enabled = true;
                                form1.toolStripButton6.Enabled = true;
                                form1.toolStripButton7.Enabled = true;
                                form1.Show();
                                this.Visible=false;
                                   
                            }
                            else if (userlimit == "1")//教师权限
                            {
                                form1.toolStripButton1.Enabled = false;
                                form1.toolStripButton2.Enabled = false;
                                form1.toolStripButton3.Enabled = true;
                                form1.toolStripButton4.Enabled = true;
                                form1.toolStripButton5.Enabled = true;
                                form1.toolStripButton6.Enabled = true;
                                form1.toolStripButton7.Enabled = true;
                                form1.Show();
                                this.Visible = false;
                            }
                            else//管理员权限
                            {
                                form1.Show();
                                this.Visible = false;
                            }
                                

                                   .......
                }

[ 本帖最后由 snkev 于 2010-1-30 20:03 编辑 ]

userlimit的值呢？

    public partial class frmLogin : Form
    {
        public frmLogin()
        {
            InitializeComponent();
        }

        private void uiButton1_Click(object sender, EventArgs e)
        {
            Mian(0);
        }
        private void Mian(int User)
        {
            frmMain frm = new frmMain();
            if (User == 0)
            {
                frm.toolStripButton3.Enabled = false;
                frm.Show();
                this.Visible = false;
            }
            else if(User == 1)
            {
                frm.ShowDialog();
                this.Visible = false;
            }
        }

        private void uiButton2_Click(object sender, EventArgs e)
        {
            Mian(1);
        }

回复2楼：

userlimit的值不是已经赋给它了吗？

然后再用if语句判断userlimit是否与数据库中用户权限的匹配，不是吗？

 string userlimit = "select userlimit form UserInfo where userid='"+textBox1.Text.Trim()+"'and userpwd='"+textBox2.Text.Trim()+"'";

textBox1.Text是用户名，textBox2.Text是密码

3楼的方法好像和我想一样，但是一共用到了2个Button，我想直接点击登录按钮就完成权限分配...


感谢赐教

我想说的是你的userlimit是"select userlimit form UserInfo where userid='"+textBox1.Text.Trim()+"'and userpwd='"+textBox2.Text.Trim()+"'";这段字符串，肯定每次都是
进
else//管理员权限
                            {
                                form1.Show();
                                this.Visible = false;
                            }
这段了，

为什么？能说的详细点吗？谢谢

因为你跟本没有去查过数据库啊，你的userlimit就是这段拼接的字符串

userlimit是什么值呀 请理清下

我明白问题了，那要怎么执行呢？我对SQL操作类不是很熟悉

SqlCommand sqlcommand=new SqlCommand(userlimit ,con)；
SqlConnection con = new SqlConnection(sqlcon);
            SqlCommand sqlcommand = new SqlCommand(userlimit, con);
            SqlDataReader sr = sqlcommand.ExecuteReader();
           while(sr.Read())
            {
                userlimit = sr["userlimit"].ToString();
            }
然后再判