C#DataSet处理数据

最新推荐文章于 2023-10-17 21:50:21 发布

标哥-iOS攻城狮

最新推荐文章于 2023-10-17 21:50:21 发布

阅读量821

点赞数 1

分类专栏： C#数据库应用

本文链接：https://blog.csdn.net/woaifen3344/article/details/8218896

版权

C#数据库应用专栏收录该内容

8 篇文章 0 订阅

订阅专栏

该示例展示了如何在C#中使用DataSet、SqlConnection和SqlCommand从Northwind数据库的Customers表中检索数据并进行输出。代码创建了一个SqlDataAdapter，填充了DataSet，并遍历结果打印CustomerID和CompanyName。

摘要由CSDN通过智能技术生成

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
请按任意键继续. . .