using System; using System.Data; using System.Data.SqlClient; namespace Northwind { class Program { static void Main(string[] args) { SqlConnection sqlConn = null; SqlCommand sqlCmd = null; try { //创建连接对象,使用集成安全方式连接,更安全 sqlConn = new SqlConnection(@"data source=localhost; Integrated Security=SSPI;Initial Catalog=northwind"); //创建命令对象,参数1是存储过程名 string strSql = "select CustomerID, CompanyName from Customers;"; SqlDataAdapter sqlDataAdapter = new SqlDataAdapter(strSql, sqlConn); //打开数据库 sqlConn.Open(); DataSet ds = new DataSet(); sqlDataAdapter.Fill(ds, "Customers"); foreach (DataRow dr in ds.Tables["Customers"].Rows) { Console.WriteLine("{0, -15}{1, -15}", dr["CustomerID"], dr["CompanyName"]); } } catch (System.Exception e) { Console.WriteLine(e.Message); } finally { //断开数据库连接 sqlConn.Close(); } } } }
ALFKI Alfreds Futterkiste ANATR Ana Trujillo Emparedados y helados ANTON Antonio Moreno Taquería AROUT Around the Horn BERGS Berglunds snabbk?p BLAUS Blauer See Delikatessen BLONP Blondesddsl père et fils BOLID Bólido Comidas preparadas BONAP Bon app' BOTTM Bottom-Dollar Markets BSBEV B's Beverages CACTU Cactus Comidas para llevar CENTC Centro comercial Moctezuma CHOPS Chop-suey Chinese COMMI Comércio Mineiro CONSH Consolidated Holdings WANDK Die Wandernde Kuh DRACD Drachenblut Delikatessen DUMON Du monde entier EASTC Eastern Connection ERNSH Ernst Handel FAMIA Familia Arquibaldo FISSA FISSA Fabrica Inter. Salchichas S.A. FOLIG Folies gourmandes FOLKO Folk och f? HB FRANR France restauration FRANS Franchi S.p.A. FRANK Frankenversand FURIB Furia Bacalhau e Frutos do Mar GALED Galería del gastrónomo GODOS Godos Cocina Típica GOURL Gourmet Lanchonetes GREAL Great Lakes Food Market GROSR GROSELLA-Restaurante HANAR Hanari Carnes HILAA HILARION-Abastos HUNGC Hungry Coyote Import Store HUNGO Hungry Owl All-Night Grocers ISLAT Island Trading KOENE K?niglich Essen LACOR La corne d'abondance LAMAI La maison d'Asie LAUGB Laughing Bacchus Wine Cellars LAZYK Lazy K Kountry Store LEHMS Lehmanns Marktstand LETSS Let's Stop N Shop LILAS LILA-Supermercado LINOD LINO-Delicateses LONEP Lonesome Pine Restaurant MAGAA Magazzini Alimentari Riuniti MAISD Maison Dewey MEREP Mère Paillarde MORGK Morgenstern Gesundkost NORTS North/South OCEAN Océano Atlántico Ltda. OLDWO Old World Delicatessen OTTIK Ottilies K?seladen PARIS Paris spécialités PERIC Pericles Comidas clásicas PICCO Piccolo und mehr PRINI Princesa Isabel Vinhos QUEDE Que Delícia QUEEN Queen Cozinha QUICK QUICK-Stop RANCH Rancho grande RATTC Rattlesnake Canyon Grocery REGGC Reggiani Caseifici RICAR Ricardo Adocicados RICSU Richter Supermarkt ROMEY Romero y tomillo SANTG Santé Gourmet SAVEA Save-a-lot Markets SEVES Seven Seas Imports SIMOB Simons bistro SPECD Spécialités du monde SPLIR Split Rail Beer & Ale SUPRD Suprêmes délices THEBI The Big Cheese THECR The Cracker Box TOMSP Toms Spezialit?ten TORTU Tortuga Restaurante TRADH Tradi??o Hipermercados TRAIH Trail's Head Gourmet Provisioners VAFFE Vaffeljernet VICTE Victuailles en stock VINET Vins et alcools Chevalier WARTH Wartian Herkku WELLI Wellington Importadora WHITC White Clover Markets WILMK Wilman Kala WOLZA Wolski Zajazd 请按任意键继续. . .