在不同的用户中设置用户类型. [英] set the user type in different users.

问题描述

如何在不同级别的用户和admin中设置用户类型

how to set usertype in siffernt level of users and admin

推荐答案

<table align="center" class="style1">
          <tr>
              <td>
                  &nbsp;</td>
              <td>
                  &nbsp;</td>
          </tr>
          <tr>
              <td>
                  UserName</td>
              <td>
                  <asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>
              </td>
          </tr>
          <tr>
              <td>
                  Psw</td>
              <td>
                  <asp:TextBox ID="TextBox2" runat="server" TextMode="Color"></asp:TextBox>
              </td>
          </tr>
          <tr>
              <td>
                  &nbsp;</td>
              <td>
                  <asp:Button ID="Button1" runat="server" onclick="Button1_Click" Text="Login" />
              </td>
          </tr>
          <tr>
              <td>
                  &nbsp;</td>
              <td>
                  &nbsp;</td>
          </tr>
          <tr>
              <td>
                  name</td>
              <td>
                  <asp:TextBox ID="TextBox3" runat="server"></asp:TextBox>
              </td>
          </tr>
          <tr>
              <td>
                  &nbsp;</td>
              <td>
                  <asp:Button ID="Button2" runat="server" onclick="Button2_Click" Text="save" />
              </td>
          </tr>
      </table>

protected void Button1_Click(object sender, EventArgs e)
   {
       //user type check fun();
       con.Open();
       SqlCommand cmd = new SqlCommand(@"select * from lg_usertype where name='"+TextBox1.Text+"'",con);
       SqlDataReader dr = cmd.ExecuteReader();
       if (dr.Read())
       {
           Int16 utps = Convert.ToInt16(dr["usertype"]);
           if (utps ==1)
           {
               Response.Redirect("~/usertype/frm1.aspx");

           }
           else
           {
               Response.Redirect("~/usertype/frm2.aspx");
           }
       }
       else
       {
           Response.Write("username is incorrect");
       }
       con.Close();
   }
   protected void Button2_Click(object sender, EventArgs e)
   {
       //insert funs();
       SqlCommand cmd = new SqlCommand("insert into lg_usertype(name) values('" + TextBox3.Text + "')", con);
       con.Open();
       cmd.ExecuteNonQuery();
       con.Close();
   }

这篇关于在不同的用户中设置用户类型.的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！