Torna al Thread

private DataTable GetDati() { DataTable table = new DataTable(); using (SqlConnection cn = new SqlConnection("Data Source=#SERVER#;Initial Catalog=#DATABASE#;User Id=#UTENTE#;Password=#PASSWORD#;")) { SqlCommand cmd = cn.CreateCommand(); cmd.CommandText = "SELECT * FROM Customers"; cn.Open(); IDataReader rd = cmd.ExecuteReader(); table.Load(rd); } return table; }
Copyright © dotNetHell.it 2002-2024
Running on Windows Server 2008 R2 Standard, SQL Server 2012 & ASP.NET 3.5