« DataSource ds = (DataSource)ctx.lookup(“jdbc/EmployeeDB”); | Home | Serializar objeto Java em XML »

Conectar no SQL Server via C#

de raydacosta | Quinta, 30 de Outubro de 2008

class ConnectionManager
{
public static SqlConnection GetConnectionObject()
{
string connectionString = ConfigurationManager.ConnectionStrings[”Adventureworks”].ConnectionString;
SqlConnection connection = new SqlConnection(connectionString);
return connection;
}

public static void carregar2(){
string queryString = “SELECT * FROM dbo_VISITA_MOBILE WHERE (STATUSComunicacao = ‘0′)”;
ArrayList lista = new ArrayList();
using (SqlConnection connection = ConnectionManager.GetConnectionObject()){
SqlCommand command = new SqlCommand(queryString, connection);
connection.Open();
SqlDataReader reader = command.ExecuteReader();
while(reader.Read()){
visitaSynchro v = new visitaSynchro();
Console.WriteLine(reader[0]);
lista.Add(v);
}
reader.Close();
}
}

}