Ejemplo n.º 1
0
        public Int32 insrt_usr(clsusr usr)
        {
            if (con.State == ConnectionState.Closed)
            {
                con.Open();
            }
            SqlCommand cmd = new SqlCommand("sp_adminreg", con);
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.Add("@p_name", SqlDbType.VarChar, 50).Value = usr.p_name;

            Int32 i = cmd.ExecuteNonQuery();
            cmd.Dispose();
            con.Close();
            return i;
        }
Ejemplo n.º 2
0
        public Int32 insrt_usr(clsusr usr)
        {
            if (con.State == ConnectionState.Closed)
            {
                con.Open();
            }
            SqlCommand cmd = new SqlCommand("sp_adminreg", con);

            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.Add("@p_name", SqlDbType.VarChar, 50).Value = usr.p_name;

            Int32 i = cmd.ExecuteNonQuery();

            cmd.Dispose();
            con.Close();
            return(i);
        }
    protected void btnsubmit_Click(object sender, EventArgs e)
    {
        clsusr objusr = new clsusr();
        clsprp objprp = new clsprp();

        clsusr1 objusr1 = new clsusr1();
        clsprp1 objprp1 = new clsprp1();

        objusr.p_name = txtname.Text;

        objusr1.p_username = txtusrname.Text;
        objusr1.p_password = txtpass.Text;

        Int32 i = objprp.insrt_usr(objusr);
        if (i > 0)
        {
            comment.Text = "registered";

        }
        else
        {
            comment.Text = "not registered";
        }

        Int32 j = objprp1.insrt_usr(objusr1);
        if (j > 0)
        {
            comment.Text = "registered";

        }
        else
        {
            comment.Text = "not registered";
        }
        Response.Redirect("adminlogin.aspx");
    }