www.pudn.com > FORU(SMS).rar > UserData.cs

using System; 
using System.Collections.Generic; 
using System.Text; 
using System.Data; 
using System.Data.SqlClient; 
 
namespace FORU_SMS_.BaseClass 
{ 
    public class UserData 
    { 
        DataConn Dconn = new DataConn(); 
        DataClass Dclass = new DataClass(); 
        SqlCommand sqlcom; 
        SqlDataAdapter adpter; 
        public string _Name; 
        public string _Pass; 
        public string _confPass; 
 
        public string UserName 
        { 
            set { _Name = value; } 
            get { return _Name; } 
        } 
 
        public string Password 
        { 
            set { _Pass = value; } 
            get { return _Pass; } 
        } 
 
        public string confPass 
        { 
            set { _confPass = value; } 
            get { return _confPass; } 
        } 
 
        public void addAdmin() 
        { 
            string sql = ""; 
            sql = sql + "insert into SMS_User(UserName,Password) values (@UserName,@Password)"; 
            sqlcom = new SqlCommand(sql, Dconn.OpenConn()); 
            adpter = new SqlDataAdapter(); 
            adpter.SelectCommand = sqlcom; 
            sqlcom.Parameters.Add("@UserName", SqlDbType.VarChar, 20).Value = this.UserName; 
            sqlcom.Parameters.Add("@Password", SqlDbType.VarChar, 20).Value = this.Password; 
            try 
            { 
                sqlcom.ExecuteNonQuery(); 
            } 
            catch (Exception) { } 
            finally 
            { 
                Dconn.CloseConn(); 
            } 
        } 
 
        public void editAdmin() 
        { 
            string sql = ""; 
            sql = sql + "update SMS_User set Password=@Password where UserName=@UserName"; 
            sqlcom = new SqlCommand(sql, Dconn.OpenConn()); 
            adpter = new SqlDataAdapter(); 
            adpter.SelectCommand = sqlcom; 
            sqlcom.Parameters.Add("@UserName", SqlDbType.VarChar, 20).Value = this.UserName; 
            sqlcom.Parameters.Add("@Password", SqlDbType.VarChar, 20).Value = this.Password; 
            try 
            { 
                sqlcom.ExecuteNonQuery(); 
            } 
            catch (Exception) { } 
            finally 
            { 
                Dconn.CloseConn(); 
            } 
        } 
    } 
}