Konekcija na Access mdb bazu

Code:

SqlConnection conn = new SqlConnection(ConfigurationManager.AppSettings.Get("conn"));

SqlCommand cmd = conn.CreateCommand();

cmd.CommandText = "SELECT Pravila FROM Clanovi WHERE KorIme=@KorIme AND Lozinka=@Lozinka";

cmd.Parameters.Add("@KorIme", SqlDbType.NVarChar, 15).Value = txtKorIme.Text;

cmd.Parameters.Add("@Lozinka", SqlDbType.NVarChar, 50).Value = 
FormsAuthentication.HashPasswordForStoringInConfigFile(txtLozinka.Text, "md5"); // Or "sha1"

SqlDataReader reader = null;

try
{
            conn.Open();

            reader = cmd.ExecuteReader();

            itd.

Code:


  <appSettings>
    <add key="conn" value="Data Source=MY-COMPUTER\SQLEXPRESS; Initial Catalog=MojaBaza; Integrated Security=True;"/>
  </appSettings>  

Code:

    <connectionStrings>
        <add name="conn"
            connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|\Data\cabletv.mdb;Persist Security Info=True"
            providerName="System.Data.OleDb" />
    </connectionStrings>
[/quote]

U web.config ide ovo gore

Pretpostavljam da radis u VS 2005 ili bilo kojem Express izdanju VS-a.
Pa onda izcitavs podatke ovako



Samo nije mi jasno zasto dodajes <appSettings> kada mozes <connectionStrings>. Ali ni ne znam postoji li razlika :)
U svakom slucaju ako hoces u <appSettings> onda samo umesto "add name" stavis "add key" :)

Code:

Data Source=|DataDirectory|\Data\cabletv.mdb

Code:

Data Source=|DataDirectory|\baza.mdb