Search code examples
c++sql-serveroledb

SQL Server Table-Valued Parameters in c++ OLEDB client?

I have an c++ application working ith SQL Server via OLEDB. How to use table-valued parameters in old good unmanaged c++ OLEDB clients?

In NET app it is clear how to :

SqlParameter param = new SqlParameter("@Customers", dataTable);
            param.SqlDbType = SqlDbType.Structured;           
            cmd.Parameters.Add(param);
            // Execute the command
            SqlDataReader rdr = cmd.ExecuteReader();

How to pass this kind of parameters calling stored procedures in c++ oledb client app?

Solution

  • Here's an example of doing it using ADO, is that what you're looking for? http://msftdpprodsamples.codeplex.com/wikipage?title=SS2008%21Readme_Table-Valued%20Parameters&referringTitle=Home