FarPoint.Web.Spread Assembly > FarPoint.Web.Spread.Model Namespace > IDataSourceSupport Interface : GetDataView Method |
'Usage Dim instance As IDataSourceSupport Dim create As Boolean Dim value As DataView value = instance.GetDataView(create)
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())
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