C# Format of the initialization string does not conform to specification error

Question

I hava a C# code that throwing an error:

SqlConnection sq = new SqlConnection(@"C:\USERS\USER\DOCUMENTS\VISUAL STUDIO 2012\PROJECTS\LOGINAPP\DB\LOGINDB.MDF");
            string q = "Select * from Table where textBox1= '" + textBox1.Text.Trim() + "'and Password'" + textBox2.Text.Trim() + "'";
            SqlDataAdapter s = new SqlDataAdapter(q, sq);
            DataTable d = new DataTable();
            s.Fill(d);
            if (d.Rows.Count == 1)
            {
                frmMain G = new frmMain();
                this.Hide();
                G.Show();
            }
            else
            {
                MessageBox.Show("Check your Username or Password or both");
            }

this code throwing (Format of the initialization string does not conform to specification) error, so how can i fix it?

Pro tip: post error messages as *text*, not images. Everything in that message box can be copied and pasted with Ctrl+C. And if you drop down the "Details", you can show us the stack trace, too. — Cody Gray - on strike, Jun 25 '17 at 15:41
See the end of this message for details on invoking just-in-time (JIT) debugging instead of this dialog box. — M.Saif, Jun 25 '17 at 16:09

score 4 · Accepted Answer · answered Jun 25 '17 at 15:37

4

SqlConnection requires a connection string, not a path to a file. See this question and the documentation.

answered Jun 25 '17 at 15:37

async

1,537
11
28

C# Format of the initialization string does not conform to specification error

1 Answers1