Parameters["@KasutajaID"].Value.ToString(); KasutajaOK = true; } return KasutajaOK; } #endregion } Kasutajagruppide hoidmine andmebaasis RoleProvider using System; using System.Collections; using System.Data; using System.Data.SqlClient; using System.Configuration; using System.Web; using System.Web.Security; public class SqlRoleProvider : RoleProvider { public override void AddUsersToRoles(string[] usernames, string[] roleNames) { SqlCommand cmd = new SqlCommand(); cmd.CommandText = "AddUserToRole_proc"; cmd.CommandType = CommandType.StoredProcedure; cmd.Connection = new SqlConnection(ConfigurationManager.ConnectionStrings["yhendusTekst"].ConnectionStri ng); cmd.Parameters.Add("@UserName", SqlDbType.NVarChar, 50); cmd.Parameters.Add("@RoleName", SqlDbType.VarChar, 50); cmd.Connection.Open(); foreach (string user in usernames) {
Parameters["@KasutajaID"].Value.ToString(); KasutajaOK = true; } return KasutajaOK; } #endregion } Kasutajagruppide hoidmine andmebaasis RoleProvider using System; using System.Collections; using System.Data; using System.Data.SqlClient; using System.Configuration; using System.Web; using System.Web.Security; public class SqlRoleProvider : RoleProvider { public override void AddUsersToRoles(string[] usernames, string[] roleNames) { SqlCommand cmd = new SqlCommand(); cmd.CommandText = "AddUserToRole_proc"; cmd.CommandType = CommandType.StoredProcedure; cmd.Connection = new SqlConnection(ConfigurationManager.ConnectionStrings["yhendusTekst"].ConnectionString); cmd.Parameters.Add("@UserName", SqlDbType.NVarChar, 50); cmd.Parameters.Add("@RoleName", SqlDbType.VarChar, 50); cmd.Connection.Open(); foreach (string user in usernames) {
annaabi.ee 
