程序師世界是廣大編程愛好者互助、分享、學習的平台,程序師世界有你更精彩!
首頁
編程語言
C語言|JAVA編程
Python編程
網頁編程
ASP編程|PHP編程
JSP編程
數據庫知識
MYSQL數據庫|SqlServer數據庫
Oracle數據庫|DB2數據庫
 程式師世界 >> 編程語言 >> .NET網頁編程 >> C# >> C#入門知識 >> C# 讀取在存儲過程多結果集

C# 讀取在存儲過程多結果集

編輯:C#入門知識

C# 讀取在存儲過程多結果集


--SQL Server 測試環境搭建:

 

Create database Test; 
go
USE [Test]
GO
if OBJECT_ID('Tab','U') is not null
	drop table Tab
go
CREATE TABLE [dbo].[Tab](
	[ID] [int] identity(1,1) NOT NULL,
	[name] [sysname] NOT NULL,
)
go
if OBJECT_ID('Tab2','U') is not null
	drop table Tab2
go
CREATE TABLE [dbo].[Tab2](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[TabID] [int] NOT NULL,
	[Name2] [nvarchar](50) NULL
) ON [PRIMARY]
GO
--創建存儲過程:

 

 

if OBJECT_ID('P3','P') is not null
	drop procedure P3
go
create procedure P3
as
select * from Tab;
select * from Tab2;
--打開Visual Studio—創建項目—選擇【控制台應用程序】

 

 

#region Using Directives
using System;
using System.Data;
using System.Data.SqlClient;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
#endregion

namespace TestReadingStoreProc
{
    class Program
    {
        static void Main(string[] args)
        {
            SqlConnection thisConnection = new SqlConnection(@Server=(Local);Database=Test;User ID=sa;Password=1);  
            SqlCommand thisCommand = thisConnection.CreateCommand();
            thisCommand.CommandType = CommandType.StoredProcedure;
            thisCommand.CommandText = P3;
            SqlDataAdapter thisAdapter = new SqlDataAdapter(thisCommand);
            DataSet thisDataSet = new DataSet();
            thisAdapter.Fill(thisDataSet);
            if (thisDataSet.Tables.Count > 0)
            {
                Console.WriteLine(Table Name:{0}
Table Rows:{1},thisDataSet.Tables[0].TableName, thisDataSet.Tables[0].Rows.Count);
                Console.WriteLine(Table Name:{0}
Table Rows:{1}, thisDataSet.Tables[1].TableName, thisDataSet.Tables[1].Rows.Count);
            }
            thisConnection.Close();
            Console.ReadKey();
        }
    }
}


 

----按F5運行結果:

/

 

 

  1. 上一頁:
  2. 下一頁:
Copyright © 程式師世界 All Rights Reserved