日韩无码专区无码一级三级片|91人人爱网站中日韩无码电影|厨房大战丰满熟妇|AV高清无码在线免费观看|另类AV日韩少妇熟女|中文日本大黄一级黄色片|色情在线视频免费|亚洲成人特黄a片|黄片wwwav色图欧美|欧亚乱色一区二区三区

CREATE PROCEDURE GetCustomerOrdersInfo

AS

SELECT CustomerID,CompanyName,ContactName FROM Customers WHERE CustomerID LIKE 'A%'

SELECT OrderID,OrderDate,CustomerID FROM Orders WHERE CustomerID IN 
(SELECT CustomerID FROM Customers WHERE CustomerID LIKE 'A%')

SELECT OrderID,ProductID,UnitPrice,Quantity,Discount FROM [Order Details] WHERE OrderID IN
(SELECT OrderID FROM Orders WHERE CustomerID IN 
(SELECT CustomerID FROM Customers WHERE CustomerID LIKE 'A%'))

GO

using System;
using System.Data;
using System.Data.SqlClient;
using Microsoft.ApplicationBlocks.Data;
namespace WinformTest
{
　public class DataAccess
　{
private string _connstring = "data source=(local);initial catalog

=Northwind;uid=csharp;pwd=C#.net2004;";
private SqlConnection _conn;
///構(gòu)造函數(shù)
public DataAccess()
{
　_conn = new SqlConnection(_connstring);
}

public void FillCustomerOrdersInfo(DatasetOrders ds)
{
　SqlCommand comm = new SqlCommand("GetCustomerOrdersInfo",_conn);
　comm.CommandType = CommandType.StoredProcedure;
　SqlDataAdapter dataAdapter = new SqlDataAdapter(comm);
　dataAdapter.TableMappings.Add("Table","Customers");
　dataAdapter.TableMappings.Add("Table1","Orders");
　dataAdapter.TableMappings.Add("Table2","Order Details");
　dataAdapter.Fill(ds);
}

public void FillCustomerOrdersInfoWithSqlHelper(DatasetOrders ds)
{
SqlHelper.FillDataset(_connstring,CommandType.StoredProcedure,

"GetCustomerOrdersInfo",ds,new string[]{"Customers","Orders","Order Details"});
}

private static void FillDataset(SqlConnection connection, 

SqlTransaction transaction, CommandType commandType, 

string commandText, DataSet dataSet, string[] tableNames,
params SqlParameter[] commandParameters)

一種方式（參考）：
{
　if( connection == null ) throw new ArgumentNullException( "connection" );
　if( dataSet == null ) throw new ArgumentNullException( "dataSet" );
　SqlCommand command = new SqlCommand();
　bool mustCloseConnection = false;
　PrepareCommand(command, connection, transaction, commandType, commandText, 

commandParameters, out mustCloseConnection );

　using( SqlDataAdapter dataAdapter = new SqlDataAdapter(command) )
　{
if (tableNames != null && tableNames.Length > 0)
{
　string tableName = "Table";
　for (int index=0; index < tableNames.Length; index++)
　{
if( tableNames[index] == null tableNames[index].Length == 0 ) 
　throw new ArgumentException( "The tableNames parameter must 

contain a list of tables, a value was 　provided as null or empty string.", "tableNames" );

　tableName += (index + 1).ToString();//這里出現(xiàn)錯誤

　}
}
dataAdapter.Fill(dataSet);
command.Parameters.Clear();
　}
　if( mustCloseConnection )
connection.Close();
}

dataAdapter.TableMappings.Add((index>0) (tableName+index.ToString()):

tableName, tableNames[index]);就能解決問題。

public class Form1 : System.Windows.Forms.Form
{
　private DataAccess _dataAccess;
　private DatasetOrders _ds;
　//……
　//構(gòu)造函數(shù)
　public Form1()
　{
InitializeComponent();
_dataAccess = new DataAccess();
_ds = new DatasetOrders();
_ds.EnforceConstraints = false; //關(guān)閉約束檢查，提高數(shù)據(jù)填充效率
this.DataGridCustomers.DataSource = _ds;
this.dataGridCustomers.DataMember = _ds.Customers.TableName;
this.dataGridOrders.DataSource = _ds;
this.dataGridOrders.DataMember = _ds.Customers.TableName+"."+

_ds.Customers.ChildRelations[0].RelationName;
this.dataGridOrderDetails.DataSource = _ds;
this.dataGridOrderDetails.DataMember =_ds.Customers.TableName+"."+
_ds.Customers.ChildRelations[0].RelationName+"."+
_ds.Orders.ChildRelations[0].RelationName;
　}

this.dataGridCustomers.SetDataBinding(_ds,_ds.Customers.TableName);

this.dataGridOrders.SetDataBinding(_ds,_ds.Customers.TableName+"."+

_ds.Customers.ChildRelations[0].RelationName);

this.dataGridOrderDetails.SetDataBinding(_ds,_ds.Customers.TableName+"."+
_ds.Customers.ChildRelations[0].RelationName+"."+_ds.Orders.ChildRelations[0].RelationName);
}

private void buttonFillData_Click(object sender, System.EventArgs e)
{
　_ds.Clear();//重新填充數(shù)據(jù)集
　_dataAccess.FillCustomerOrdersInfo(_ds);
　//_dataAccess.FillCustomerOrdersInfoWithSqlHelper(_ds);
}