Page History

...

Exception

	ArgumentNullException
	ArgumentNullException

BindData will throw this exception if null (C#) or Nothing (VB.NET) is passed to the method.

ArgumentExceptionArgumentException

Exceptionexample

Code Block

	csharp

Example

	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 Block

	vbnet
	vbnet
title	VB

Vbnet

Option Strict On
Option Explicit On

Dim CategoryRdr As OleDbDataReader = GetCategoryReader()
Try
Dim pptt As New PowerPointTemplate()

   Dim CategoryRdr As OleDbDataReader = GetCategoryReader()
          Try
               Dim pptt As New PowerPointTemplate()
               pptt.BindData(CategoryRdr,

_

 _
                    "Category",

_

 _
                    PowerPointTemplate.CreateDataBindingProperties())

Catch ex As System.Exception
Finally


          Catch ex As System.Exception
          Finally
               '--- The OleDbDataReader must be open when it's

passed

 passed
               '--- to PowerPointTemplate. Remember to close it after use.

If Not CategoryRdr = Nothing


               If Not CategoryRdr = Nothing
                    CategoryRdr.Close()

End If
End Try


               End If
          End Try

          '--- Get an OleDbDataReader containing a list of product

categories
Private Function

 categories
          Private Function GetCategoryReader() As

OleDbDataReader
Dim Conn As New OleDbConnection()
Conn.ConnectionString =

 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

 categories
               Dim CategorySQL As String = "SELECT CategoryName FROM Categories"
               Dim Cmd As New OleDbCommand(CategorySQL, Conn)


               Conn.Open()

Return


               Return Cmd.ExecuteReader()

End Function


          End Function

Space Shortcuts

Page tree

Versions Compared

Old Version 4

New Version Current

Key