I tried to sign up and insert encrypted password into the database but got an error.
Cannot open database "C:\USERS\BLOCBONDY\APP_DATA\DATAREGISTER.MDF" requested by the login. The login failed.
Login failed for user 'BLOC-BONDY\BlocBondy'.
The error comes after I clicked the sign up button.
May I please ask how to overcome this error?
Here is my code
protected void Button1_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection("Data Source=(LocalDB)\\MSSQLLocalDB;AttachDbFilename=|DataDirectory|\\Dataregister.mdf;Integrated Security=True");
SqlDataReader dr;
using (SqlCommand cmd = new SqlCommand())
{
cmd.Parameters.Clear();
cmd.CommandText = "SELECT * FROM Users WHERE email=@email OR Name=@Name";
cmd.Parameters.AddWithValue("@email", mailtxtbx.Text);
cmd.Parameters.AddWithValue("@Name", txtname.Text);
cmd.Connection = con;
con.Open();
dr = cmd.ExecuteReader();
}
if (dr.HasRows)
{
dvMessage.Visible = true;
Div1.Visible = false;
lblMessage.Text = "Email with Name Already Exists";
lblMessage.ForeColor = System.Drawing.Color.Red;
mailtxtbx.Text = "";
lblsuccess.Visible = false;
lblMessage.Visible = true;
mailtxtbx.Focus();
}
else
{
con.Close();
if (mailtxtbx.Text != "" & pass.Text != "" & conpass.Text != "" & txtname.Text != "")
{
if (pass.Text == conpass.Text)
{
if (Filedoc.PostedFile.FileName != "")
{
if (check1.Checked)
{
int Uid = -1;
byte[] image;
Stream s = Filedoc.PostedFile.InputStream;
BinaryReader br = new BinaryReader(s);
image = br.ReadBytes((Int32)s.Length);
string query = @"INSERT INTO Users (email, pass, Role, Name, CreatedBy, image, CreateDate) VALUES (@email, @pass, @Role, @Name, @CreatedBy, @image, @CreateDate);
SELECT SCOPE_IDENTITY();";
using (SqlCommand objCMD = new SqlCommand(query, con))
{
objCMD.Parameters.Add("@email", SqlDbType.VarChar, 50).Value = mailtxtbx.Text.Trim();
objCMD.Parameters.Add("@pass", SqlDbType.VarChar, 100).Value = Encrypt(pass.Text.Trim());
objCMD.Parameters.Add("@Role", SqlDbType.VarChar, 50).Value = "Admin";
objCMD.Parameters.Add("@Name", SqlDbType.VarChar, 50).Value = txtname.Text.Trim();
objCMD.Parameters.Add("@CreatedBy", SqlDbType.VarChar, 50).Value = mailtxtbx.Text.Trim();
objCMD.Parameters.Add("@image", SqlDbType.VarBinary).Value = image;
objCMD.Parameters.Add("@CreateDate", SqlDbType.DateTime, 100).Value = DateTime.Now;
cmd.Connection = con;
con.Open();
object returnObj = objCMD.ExecuteScalar();
if (returnObj != null)
{
int.TryParse(returnObj.ToString(), out Uid);
}
con.Close();
}
if (Uid > 0)
{
query = @"INSERT INTO UserWallet (Uid, email, Name, amount) VALUES (@Uid, @email, @Name, @amount)";
using (SqlCommand objCMD = new SqlCommand(query, con))
{
objCMD.Parameters.Add("@Uid", SqlDbType.Int, 50).Value = Uid;
objCMD.Parameters.Add("@email", SqlDbType.VarChar, 50).Value = mailtxtbx.Text.Trim();
objCMD.Parameters.Add("@Name", SqlDbType.VarChar, 50).Value = txtname.Text.Trim();
objCMD.Parameters.Add("@amount", SqlDbType.Float, 100).Value = 0; //Change type here accordingly
con.Open();
objCMD.ExecuteNonQuery();
SendActivationEmail(Uid);
lblsuccess.Text = "An Activation link has been sent to your Email.";
lblsuccess.Visible = true;
Div1.Visible = true;
lblsuccess.ForeColor = System.Drawing.Color.Green;
lblMessage.Visible = false;
dvMessage.Visible = false;
mailtxtbx.Text = "";
pass.Text = "";
conpass.Text = "";
txtname.Text = "";
}
}
con.Close();
}
else
{
dvMessage.Visible = true;
lblMessage.Visible = true;
lblMessage.Text = "Please Check Box";
lblsuccess.Visible = false;
lblMessage.ForeColor = System.Drawing.Color.Red;
}
}
else
{
dvMessage.Visible = true;
lblMessage.Visible = true;
lblMessage.Text = "Please Upload Identification Document";
lblsuccess.Visible = false;
lblMessage.ForeColor = System.Drawing.Color.Red;
}
}
else
{
dvMessage.Visible = true;
lblMessage.Visible = true;
lblMessage.Text = "Passwords don't match";
lblMessage.ForeColor = System.Drawing.Color.Red;
conpass.Text = "";
lblsuccess.Visible = false;
}
}
else
{
dvMessage.Visible = true;
lblMessage.Visible = true;
lblMessage.ForeColor = System.Drawing.Color.Red;
lblMessage.Text = "*All Fields Are Required*";
lblsuccess.Visible = false;
}
}
}