conexão sql server com o visual
13/01/2010
0
Tiago Alves
Posts
15/01/2010
Netasper
15/01/2010
Paulo Freire
Eu gosto de usar Factory, veja só:
//Conexao Factory
System.Data.Common.
DbProviderFactory xproviderFactory = System.Data.Common.DbProviderFactories.GetFactory("System.Data.SqlClient");
System.Data.Common.DbConnection con;
con = xproviderFactory.CreateConnection();
con.ConnectionString =
"Data Source=Server07\\SQL2008; Initial Catalog=QuartelGeneralSP; Integrated Security=false; User Id=shalom; password=adonai";
con.Open();
if (con.State == ConnectionState.Open)
{
lblMessage.Text = ""Conexão OK e aberta";
}
//quando sair, lembre de fechar a conexão
con.Close();
}
18/01/2010
Tiago Alves
18/01/2010
Netasper
18/01/2010
Tiago Alves
18/01/2010
Tiago Alves
16/02/2010
Eleuterio Gonzalez
http://msdn.microsoft.com/pt-br/library/1se6685s(VS.80).aspx
Clique aqui para fazer login e interagir na Comunidade :)