sqlCommand.CommandText = "SELECT * FROM table1,table2,table3 WHERE table1.a (+)= talble2.b AND table2.b (+)= table3.c";sqlDataAdapter.SelectCommand = sqlCommand;sqlDataAdapter.Fill(dataSet,"_table");dataGrid.DataSource = dataSet["_table"];
调试欢乐多
drop table [dbo].[TABLE1]
GOif exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TABLE2]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[TABLE2]
GOif exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TABLE3]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[TABLE3]
GOCREATE TABLE [dbo].[TABLE1] (
[tid1] [decimal](18, 0) NOT NULL ,
[t1name] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL
) ON [PRIMARY]
GOCREATE TABLE [dbo].[TABLE2] (
[tid2] [decimal](18, 0) NOT NULL ,
[t2name] [char] (10) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GOCREATE TABLE [dbo].[TABLE3] (
[tid] [decimal](18, 0) NOT NULL ,
[tid1] [decimal](18, 0) NOT NULL ,
[tid2] [decimal](18, 0) NOT NULL ,
[t3name] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL
) ON [PRIMARY]
GOif exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[VIEW11]') and OBJECTPROPERTY(id, N'IsView') = 1)
drop view [dbo].[VIEW11]
GOSET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GOCREATE VIEW dbo.VIEW11
AS
SELECT dbo.TABLE1.t1name, dbo.TABLE2.t2name, dbo.TABLE3.t3name, dbo.TABLE3.tid,
dbo.TABLE3.tid1, dbo.TABLE3.tid2
FROM dbo.TABLE1 INNER JOIN
dbo.TABLE3 ON dbo.TABLE1.tid1 = dbo.TABLE3.tid1 INNER JOIN
dbo.TABLE2 ON dbo.TABLE3.tid2 = dbo.TABLE2.tid2GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO以上生成表及视图
把视图View11当做表来看待;
public DataSet getViewInfo()
{
DataSet ds =new DataSet();
string strSql="SELECT * FROM View11 ";
try
{
sqlConn1.Open();
//sqlConn1事先声明好的的数据库连接对象
SqlDataAdapter sda = new SqlDataAdapter(strSql,sqlConn1);
ds.Clear();
sda.Fill(ds,"View11");
}
catch(System.Exception ex)
{
throw ex;
}
finally
{
sqlConn1.Close();
}
return ds;
}private void BindGrid()
{
DataGrid1.DataSource=getViewInfo.Tables[0].DefaultView;
DataGrid1.DatBind();
}以上是数据帮定
霜冷长河 你的_table 指的是新建的表还是?
虫子,你创建view是系统有提示你“约束太多”或一些差不多的话???