Conexao banco dados

[juniorneo2 0]

Ola pessoal,

 

Estou tendo um probleminha na hora de pegar a string de conexão no web.config

 

Olha como estou fazendo:

 

web.config

 

CODE

<?xml version="1.0"?>

<configuration xmlns="http://schemas.microsoft.com/.NetConfiguration/v2.0">

<system.web>

<sessionState timeout="30"/>

<compilation debug="true"/>

<authentication mode="None" />

 

</system.web>

<connectionStrings>

<add name="times" connectionString="Data source=JUNIOR-B6ACD0D5\SQLEXPRESS;Initial Catalog=junior;Integrated Security=SSPI;"/>

</connectionStrings>

 

</configuration>

conexao.aspx

CODE

ConnectionStringSettings getString = WebConfigurationManager.ConnectionStrings[“times”] as ConnectionStringSettings;

If (getString != null) {

Using(SqlConnection conn = SqlConnection(getString.ConnectionString) {

Conn.Open();

}

}

Pessoal no livro que eu estou estudando diz o seguinte: Recupere uma string de conexão armazenada num arquivo de configuração que seria (web.config) com a classe WebConfigurationManager, mas ele não inporta esta class, e esta dando erro é nela, por favor pessoal me de uma dica.

 

vlw http://forum.imasters.com.br/public/style_emoticons/default/thumbsup.gif

[quintelab 91]

Importe esta classe no seu formulário: System.Web.Configuration.

Ficará:

using System.Web.Configuration;

Abraços...

[juniorneo2 0]

Valeu quintelab, mas ainda esta dando este erro:

 

Description: An error occurred during the compilation of a resource required to service this request. Please review the following specific error details and modify your source code appropriately.

 

Compiler Error Message: CS0118: 'System.Data.SqlClient.SqlConnection' is a 'type' but is used like a 'variable'

 

Source Error:

 

Line 19: if (getString != null)

Line 20: {

Line 21: using (SqlConnection conn = SqlConnection(getString.ConnectionString)) //aqui que esta o erro

Line 22: {

Line 23: SqlCommand cmd = new SqlCommand();

 

conexao.aspx

 

CODE

using System;

using System.Data;

using System.Configuration;

using System.Collections;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Web.UI.HtmlControls;

using System.Web.Configuration;

using System.Data.SqlClient;

public partial class conexao2 : System.Web.UI.Page

{

protected void Page_Load(object sender, EventArgs e)

{

 

ConnectionStringSettings getString = WebConfigurationManager.ConnectionStrings["times"] as ConnectionStringSettings;

if (getString != null)

{

using (SqlConnection conn = SqlConnection(getString.ConnectionString))

{

SqlCommand cmd = new SqlCommand();

cmd.Connection = conn;

Conn.Open();

}

}

 

}

}

 

vlw

[juniorneo2 0]

A desculpa quintelab, ja sei o que eu errei, esqueci do (new).

 

 

vlw quintelab