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 编辑 ]

回复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，我想直接点击登录按钮就完成权限分配...


感谢赐教

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

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

感谢，自己解决了~