Spread for ASP.NET 8.0 Product Documentation
GetDataView Method (IDataSourceSupport)
Example 


Whether to recreate the DataView
Gets the DataView object.
Syntax
'Declaration
 
Function GetDataView( _
   ByVal create As Boolean _
) As DataView
'Usage
 
Dim instance As IDataSourceSupport
Dim create As Boolean
Dim value As DataView
 
value = instance.GetDataView(create)
DataView GetDataView( 
   bool create
)

Parameters

create
Whether to recreate the DataView

Return Value

DataView object containing the view
Example
This example binds the model to a data set.
string strConn  = "data source = 127.0.0.1;initial catalog=Pubs; integrated security = SSPI";
string sqlStr = "SELECT * FROM Authors; Select * From Titles";

System.Data.SqlClient.SqlDataAdapter da = new System.Data.SqlClient.SqlDataAdapter(sqlStr, strConn);
DataSet ds = new DataSet();
da.Fill(ds);

FarPoint.Web.Spread.Model.IDataSourceSupport dss;
dss = (FarPoint.Web.Spread.Model.IDataSourceSupport)FpSpread1.ActiveSheetView.DataModel;
dss.AutoGenerateColumns = true;
dss.DataSource = ds;
dss.DataMember = "Table";
dss.DataKeyField = "auid";

DataView dv;
dv = dss.GetDataView(false);
Response.Write("The name of the table in the data view is " + dv.Table.ToString());
Dim strConn As String = "data source = 127.0.0.1;initial catalog=Pubs; integrated security = SSPI"
Dim sqlStr As String = "SELECT * FROM Authors; Select * From Titles"

Dim da As New System.Data.SqlClient.SqlDataAdapter(sqlStr, strConn)
Dim ds As New DataSet
da.Fill(ds)

Dim dss As FarPoint.Web.Spread.Model.IDataSourceSupport
dss = FpSpread1.ActiveSheetView.DataModel
dss.AutoGenerateColumns = True
dss.DataSource = ds
dss.DataMember = "Table"
dss.DataKeyField = "auid"

Dim dv As DataView
dv = dss.GetDataView(False)
Response.Write("The name of the table in the data view is " & dv.Table.ToString())
Requirements

Target Platforms: Windows 7, Windows 8, Windows Vista, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6

See Also

Reference

IDataSourceSupport Interface
IDataSourceSupport Members

 

 


Copyright © GrapeCity, inc. All rights reserved.