codice:
public static String createUserLogin()
{
String NuovoUserName = "";
String Caratteri = "0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz";
Random randomNumber = new Random();
Boolean user = false;
String Query = "";
SqlCommand selectCmd;
using (SqlConnection cnn = new SqlConnection(DALFactory.DbConnectionString))
{
try
{
cnn.Open(); // Open DB Connection using Connection Pool
while (!user)
{
for (Int32 i = 0; i < 8; i++)
{
Int32 rndNum = randomNumber.Next(1, 62);
NuovoUserName = NuovoUserName + Caratteri.Substring(rndNum, 1);
}
Query = "Select * from xxxxxxx WHERE USR_LOGIN='" + NuovoUserName + "'";
selectCmd = new SqlCommand(Query, cnn);
SqlDataReader reader = selectCmd.ExecuteReader();
if (!reader.HasRows) user = true;
}
}
catch (Exception ex)
{
String retTemp = ex.Message;
//Return Error
}
}
return NuovoUserName;
}