Why is the system not able to find the specified file?

Asked May 17 '16 at 06:42

Active May 17 '16 at 07:10

Viewed 89 times

So, I have this bit of code, and it would seem I am getting an error on the fourth line. The error specifically is "The system cannot find the file specified". Where did I go wrong, and how can I fix this bug?

SqlConnection con = new SqlConnection(@"server=localhost;user id=root;database=localhost");
SqlDataAdapter sda = new SqlDataAdapter("Select Role from accounts Where Username='" + UserNameBox.Text + "' and Password='" + PasswordBox.Text +"'", con);
DataTable dt = new DataTable();
sda.Fill(dt);

asked May 17 '16 at 06:42

user3735278

Maybe you have the wrong connection string? To what exactly are you trying to connect? – npinti May 17 '16 at 06:46
My MySQL database. – user3735278 May 17 '16 at 06:48
1

Do you allow `' OR Username='admin` as a password? – Sayse May 17 '16 at 06:48
is your database really called "localhost"?? – BugFinder May 17 '16 at 07:01
Yeah, but this is basically only a personal project right now; it is not on the 'net or anything. – user3735278 May 17 '16 at 07:05
http://stackoverflow.com/questions/9394907/mysql-trying-to-import-a-database-get-message-the-system-cannot-find-the-fil – mohsen May 17 '16 at 08:22

Why is the system not able to find the specified file?

0 Answers0