I had some problems to create a disconnected ADO Recordset in C#. Finally I get it right.
public static Recordset CreateDisconnectedRecordset()
{
// Create new recordset
var rs = new Recordset();
// Add some updatable fields
rs.Fields.Append("name", DataTypeEnum.adVarChar, 20, FieldAttributeEnum.adFldUpdatable, Missing.Value);
rs.Fields.Append("country", DataTypeEnum.adVarChar, 20, FieldAttributeEnum.adFldUpdatable, Missing.Value);
// Open recordset
rs.Open(Missing.Value, Missing.Value, CursorTypeEnum.adOpenUnspecified, LockTypeEnum.adLockUnspecified, 0);
// Add data
rs.AddNew(Missing.Value, Missing.Value);
rs.Fields["name"].Value = "Anders";
rs.Fields["country"].Value = "Sweden";
rs.Update(Missing.Value, Missing.Value);
return rs;
}
ahhhhhh, thank you! this was a real life-saver!!!
ReplyDeleteGlad the post helped you.
ReplyDeleteHelped me too, much thanks.
ReplyDeleteBeen struggling with this and chanced upon this post. Thanks a ton!!
ReplyDeleteThanks Man.
ReplyDelete