C#, dao, optional parameters and Seek method

[info]

I need to use DAO in one of my applications. It was too hard to pass
through by optional parameters for several methods, but now I'm totally
lost at DAO seek method (the main method for key s).
The method has a next declaration:

Sub Seek(Comparison As String, Key1, [Key2], [Key3], [Key4], [Key5],
[Key6], [Key7], [Key8], [Key9], [Key10], [Key11], [Key12], [Key13])
Member of DAO.Recordset

12 optional parameters. I tried anything for the Key2-Key13, without
success - Null, System.Guid.Empty, System.TypeCode.DBNull, ... But
without success. The Seek method always returns:

"Additional information: Could not build key."

What can I do with the method?

My code looks like:

DAO.Database db = CreateDatabase("test.mdb");

DAO.Recordset A =
db.OpenRecordset("A",DAO.RecordsetTypeEnum.dbOpenT able,0,
DAO.LockTypeEnum.dbOptimistic);
A.Index="PrimaryKey";

for (int i=1; i<100000;i++)
{
A.Seek ("=", i,
System.Guid.Empty,System.Guid.Empty,System.Guid.Em pty,System.Guid.Empty,System.Guid.Empty,System.Gui d.Empty,System.Guid.Empty,System.Guid.Empty,System .Guid.Empty,System.Guid.Empty,System.Guid.Empty,Sy stem.Guid.Empty);
//...
}

Thank you.
Antonin

[David Anton]

Use System.Type.Missing for the arguments you want to skip.
--
David Anton
www.tangiblesoftwaresolutions.com
Instant C#: VB to C# converter
Instant VB: C# to VB converter
Instant C++: C# to C++ converter
Instant C++: VB to C++ converter
"in**@pstruh.cz" wrote:

I need to use DAO in one of my applications. It was too hard to pass
through by optional parameters for several methods, but now I'm totally
lost at DAO seek method (the main method for key s).
The method has a next declaration:

Sub Seek(Comparison As String, Key1, [Key2], [Key3], [Key4], [Key5],
[Key6], [Key7], [Key8], [Key9], [Key10], [Key11], [Key12], [Key13])
Member of DAO.Recordset

12 optional parameters. I tried anything for the Key2-Key13, without
success - Null, System.Guid.Empty, System.TypeCode.DBNull, ... But
without success. The Seek method always returns:

"Additional information: Could not build key."

What can I do with the method?

My code looks like:

DAO.Database db = CreateDatabase("test.mdb");

DAO.Recordset A =
db.OpenRecordset("A",DAO.RecordsetTypeEnum.dbOpenT able,0,
DAO.LockTypeEnum.dbOptimistic);
A.Index="PrimaryKey";

for (int i=1; i<100000;i++)
{
A.Seek ("=", i,
System.Guid.Empty,System.Guid.Empty,System.Guid.Em pty,System.Guid.Empty,System.Guid.Empty,System.Gui d.Empty,System.Guid.Empty,System.Guid.Empty,System .Guid.Empty,System.Guid.Empty,System.Guid.Empty,Sy stem.Guid.Empty);
//...
}

Thank you.
Antonin