Database to #c (username & password) -> error

Question

I'm working on a project of school but im getting an error:

"Keyword not supported: 'integrated security'" Can someone help me with this?

Here is a picuture: http://gyazo.com/5a16cde702601e20c811339c01b1911c

Language: Dutch

Code:

 private void button1_Click(object sender, EventArgs e)
    {
        try
        {
            string database = @"Data Source=(LocalDB)\v11.0;AttachDbFilename=E:\gip_stap_2\loonberekening.mdf;Integra‌ted Security=True;Connect Timeout=30;InitialCatalog=loonberekening";
            SqlConnection myConn = new SqlConnection(database);
            SqlCommand Selectcommand = new SqlCommand("select * from loonberekening.tblInloggen where id = '" + this.txtGebruikersnaam.Text + "' and passwoord= '" + this.txtPaswoord.Text + "' ;", myConn);
            SqlDataReader myReader;
            myConn.Open();
            myReader = Selectcommand.ExecuteReader();
            int count = 0;
            while (myReader.Read())
            {
                count = count + 1;
            }
            if (count == 1)
            {
                MessageBox.Show("Gebruikersnaam en paswoord is correct");
                startmenu.ShowDialog();
            }
            else if (count > 1)
            {
                MessageBox.Show("Dit is een gedupliceerde paswoord en gebruikersnaam... Acces verboden");
            }
            else
            {
                MessageBox.Show("Username and paswoord zijn niet correct, Probeer opnieuw");
                myConn.Close();
            }
        }
        catch (Exception ex)
        {
            MessageBox.Show(ex.Message);
        }

did you attach your database in `SQL Server Management Studio`? — Khurram Ali, Apr 11 '15 at 14:28
try this connection string ` Server=(localdb)\v11.0;Integrated Security=true; AttachDbFileName=C:\MyFolder\MyData.mdf;` — Khurram Ali, Apr 11 '15 at 14:30
Just as a sidenote, you might want to look into `parameterised queries`, your query is suggestive to SQL Injections this way. — Matthijs, Apr 11 '15 at 15:12

score 0 · Answer 1 · answered Apr 11 '15 at 14:30

0

Change the order in your connection it should be Initial catalog first before the integrated security

SqlConnection con = new SqlConnection(@"DataSource=sadf;Initial Catalog=asdf;Integrated Security=TRUE");

answered Apr 11 '15 at 14:30

JC Borlagdan

3,318
5
28
51

it is saying "keyword not supporting: 'datasource'" – termted Apr 11 '15 at 15:03
put space between DATA SOURCE – JC Borlagdan Apr 11 '15 at 15:11
Now im getting this error: http://gyazo.com/5725c180382bf3a88755beaca3a83518 (picture) – termted Apr 11 '15 at 15:23
what version of SQL server you're using? – JC Borlagdan Apr 11 '15 at 15:26
i think your database isn't created yet in the DB, or if it is, your servername/instance name is incorrect. – JC Borlagdan Apr 11 '15 at 15:27
my database is not created in database? but i attached it and what do you mean with servername/instance? and how can i see if my database is created? – termted Apr 11 '15 at 15:35

Khurram Ali · Answer 2 · 2015-04-11T15:50:02.473

0

try this if your database file is attached In SSMS

string database = @"Data Source=.; Integrated Security; 
                  Initial Catalog=loonberekening; Connect Timeout=30;"

If you want LocalDB automatic instance with specific data file then

string database = @"Server=(localdb)\v11.0;Integrated Security=true; 
                  AttachDbFileName=E:\gip_stap_2\loonberekening.mdf;"

Note: Use this loonberekening.dbo.tblInloggen instead of this loonberekening.tblInloggen in your Select Statement

Something like this

SqlCommand Selectcommand = 
new SqlCommand("select * from loonberekening.dbo.tblInloggen where id = '" +
 this.txtGebruikersnaam.Text + "' and passwoord= '" + this.txtPaswoord.Text + "' ;", myConn);

edited Apr 11 '15 at 15:50

answered Apr 11 '15 at 14:34

Khurram Ali

1,659
4
20
37

The second one is working but now im getting this: http://gyazo.com/e6e69199365fdd3674f85a780716ed44 and here is a picture of my database: http://gyazo.com/8e0f827c264e0b0d755d486190224131 dbo.tblInloggen doesnt work also – termted Apr 11 '15 at 15:06
@termted try this `loonberekening.dbo.tblInloggen` – Khurram Ali Apr 11 '15 at 15:44
loonberekening.dbo.tblInloggen didnt work... :( what do you mean with see edit? – termted Apr 11 '15 at 16:05
The string database = @"Server=(localdb)\v11.0;Integrated Security=true; AttachDbFileName=E:\gip_stap_2\loonberekening.mdf;" is working for me and the ("select * from loonberekening.dbo.tblInloggen where id also but now im gettin this error: http://gyazo.com/a08f915d626a2a088dc93bdd03b6061e – termted Apr 11 '15 at 19:36

Database to #c (username & password) -> error

2 Answers2