ASP.Net web project database connection error

Question

I am trying to create registiration. Here is web.config

<configuration>
      <connectionStrings>
        <clear/>
        <add name="connect" connectionString="Data Source=.\SQLEXPRESS; AttachDbFilename=|DataDirectory|web.mdf; Security=True; uid=Rahman\Rahman; pwd=12345;"/>
      </connectionStrings>
        <system.web>
          <compilation debug="true" targetFramework="4.5" />
          <httpRuntime targetFramework="4.5" />
        </system.web>

        </configuration>

and here I use sql query to write data into table called Users

protected void btnReg_Click(object sender, EventArgs e) {

    SqlConnection cnn = new SqlConnection(ConfigurationManager.ConnectionStrings["connect"].ConnectionString);
    string q = "Insert into Users (Username, Password) Values(@username, @password)";
    SqlCommand cmd = new SqlCommand(q, cnn);
    cnn.Open();

    try {
        cmd.Parameters.AddWithValue("@username", txtUsername.Text);
        cmd.Parameters.AddWithValue("@password", txtPass.Text);
        cmd.ExecuteNonQuery();
        cnn.Close();
        textReg.Text = "Pozitive";
    }
    catch {
        textReg.Text = "Negative";
    }
}

But unfortunately I got error

"An exception of type 'System.ArgumentException' occurred in System.Data.dll but was not handled in user code"

Error points this line,

SqlConnection cnn = new SqlConnection(ConfigurationManager.ConnectionStrings["connect"].ConnectionString);

score 0 · Answer 1 · answered Apr 01 '15 at 21:06

0

You need to reference System.Configuration

SqlConnection cnn = new SqlConnection(System.Configuration.ConfigurationManager.
    ConnectionStrings["connect"].ConnectionString);

answered Apr 01 '15 at 21:06

StevieB

67
4

I have changed it just now but I got same error http://postimg.org/image/hq2wf55jz/ – user1953051 Apr 01 '15 at 21:08

score 0 · Answer 2 · answered Apr 01 '15 at 21:07

0

Use

// read connection string 
private string connString = Convert.ToString (System.Configuration.ConfigurationManager.ConnectionStrings["connect"].ConnectionString); 

// use the variable for a connection
SqlConnection cnn = new SqlConnection(connString );

Also, make sure that you have added a reference to System.Configuration in your project.

answered Apr 01 '15 at 21:07

Saagar Elias Jacky

2,684
2
14
28

SqlConnection cnn = new SqlConnection(connString ); I got same error on this line – user1953051 Apr 01 '15 at 21:12
where is `DataDirectory` set and whats the value? – Saagar Elias Jacky Apr 01 '15 at 21:21
C:\Program Files\Microsoft SQL Server\MSSQL11.SQLEXPRESS\MSSQL\DATA\web.mdf – user1953051 Apr 01 '15 at 21:25
where do you set the value for `DataDirectory`? please include the config – Saagar Elias Jacky Apr 01 '15 at 21:26
I think I shared in question.Do you mean the file web.config? – user1953051 Apr 01 '15 at 21:35
Refer this http://stackoverflow.com/questions/1409358/ado-net-datadirectory-where-is-this-documented – Saagar Elias Jacky Apr 01 '15 at 21:41

ASP.Net web project database connection error

2 Answers2