Wiki Markup |
---|
{description} {excerpt}Sets an ADO.NET IDataReader as a data source to bind to template data markers.{excerpt} {signature:C#} public void BindData(System.Data.IDataReader source, System.String dataSourceName, DataBindingProperties property) {signature}{signature:vb.net} Public Sub BindData(ByVal source As System.Data.IDataReader, ByVal dataSourceName As String, ByVal [property] As DataBindingProperties) {signature} {parameters} {param:source}This parameter must be an instance of {msdn:System.Data.SqlClient.SqlDataReader|System.Data.SqlClient.SqlDataReader}, {msdn:System.Data.OleDb.OleDbDataReader|System.Data.OleDb.OleDbDataReader} or {msdn:Microsoft.AnalysisServices.AdomdClient.AdomdDataReader|Microsoft.AnalysisServices.AdomdClient.AdomdDataReader}, otherwise {{BindData}} will throw an exception. {param} {param:dataSourceName}The name of the set of data markers at which to insert the values imported from the data source. Note: {{dataSourceName}} does not include a data marker's column name, for example, the {{dataSourceName}} for {{%%=Products.ProductID}} is "Products."{param} {param:property}The [DataBindingProperties|DataBindingProperties] object which contains information about how the data should be bound to the template. {param} {param:property}The [DataBindingProperties|DataBindingProperties] object which contains information about how the data should be bound to the template. {{property}} Must be specified, but the {{DataBindingProperties}} need not be set beforehand. To bind data to a template with the default {{DataBindingProperties}}, pass in {{PowerPointTemplate.CreateDataBindingProperties()}} as the {{property}} value. {param} {exceptions} {exception:ArgumentNullException}{{BindData}} will throw this exception if {{null}} \(C\#\) or {{Nothing}} \(VB.NET\) is passed to the method.{exception} {example} {code:csharp|title=C#} OleDbDataReader CategoryRdr = GetCategoryReader(); try { PowerPointTemplate pptt = new PowerPointTemplate(); pptt.BindData(CategoryRdr, "Category", PowerPointTemplate.CreateDataImportProperties()); } catch(System.Exception ex) { } finally { //--- The OleDbDataReader must be open when it's passed //--- to PowerPointTemplate. Remember to close it after use. if(CategoryRdr!=null) CategoryRdr.Close(); } //--- Get an OleDbDataReader containing a list of product categories private OleDbDataReader GetCategoryReader() { OleDbConnection Conn = new OleDbConnection(); Conn.ConnectionString = Application["connstring"].ToString(); //--- SQL query for a list of categories string CategorySQL = "SELECT CategoryName FROM Categories"; OleDbCommand Cmd = new OleDbCommand(CategorySQL, Conn); Conn.Open(); return Cmd.ExecuteReader(); } {code} {code:vbnet|title=VB} Dim CategoryRdr As OleDbDataReader = GetCategoryReader() Try Dim pptt As New PowerPointTemplate() pptt.BindData(CategoryRdr, _ "Category", _ PowerPointTemplate.CreateDataBindingProperties()) Catch ex As System.Exception Finally '--- The OleDbDataReader must be open when it's passed '--- to PowerPointTemplate. Remember to close it after use. If Not CategoryRdr = Nothing CategoryRdr.Close() End If End Try '--- Get an OleDbDataReader containing a list of product categories Private Function GetCategoryReader() As OleDbDataReader Dim Conn As New OleDbConnection() Conn.ConnectionString = Application("connstring").ToString() '--- SQL query for a list of categories Dim CategorySQL As String = "SELECT CategoryName FROM Categories" Dim Cmd As New OleDbCommand(CategorySQL, Conn) Conn.Open() Return Cmd.ExecuteReader() End Function {code} {example} |
Page History
Overview
Content Tools