Connection C# & sql server 2005 [Résolu]

Je me trompe peut etre mais OleDBConnection c'est pas pour une base de donnée Access ? Pour une base de donnée SQL Server c'est SqlConnection je crois.

To connect to SQL Server from C#.NET, you need to create a connection string such as below:

private SqlConnection connection;
private string connectionString =
@"Server=(local);Database=Embedding_SQL_Test;User ID=sa;Password=123";
connection = new SqlConnection( connectionString );

Next, you use the SqlConnection object created above to create a 'SqlCommand', as shown below:
SqlCommand cmd = new SqlCommand( "select * from Customer where CustomerID = @Cid", connection);

The SQL query shown here can be replaced by a SELECT, INSERT, UPDATE queries etc.

Next to execute the SQL queries in the database, you use the following methods:
ExecuteReader - to execute SELECT queries
ExecuteNonQuery - to execute INSERT, DELETE, UPDATE, and SET statements.

This is a very short description of how to connect to SQL Server database from C# and execute SQL queries in the database.
For details about the connection string, the methods and their parameters check the following link: ( http://www.shahriarnk.com/Shahriar-N-K-Research-Embedding-SQL-in-C-Sharp-Java.html )
Here you will also find details about how to pass parameters to the SQL queries as well as calling stored procedures and much more.

Bonjour,
Jettez un oeil la dessus : http://www.connectionstrings.com/

Merci Melooo pour votre reponse,

j'ai deja cherché sur ce site mais j'ai pas arrivé a trouvé la solution...

toujours il m'affiche:

Spécification de permission non valide
Attribut de chaîne de connexion non valide

Merci à tous
j'ai trouver la solution...

OleDbConnection conn = new OleDbConnection();
            conn.ConnectionString = "Provider=SQLOLEDB;Driver={SQL Native Client};Server=SERT\\SQLEXPRESS;Database=client;Trusted_Connection=yes;";
            try
            {
                conn.Open();
                MessageBox.Show("Base de données ouverte....");
                // Insert code to process data.
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.ToString());
            }