From: Wotan v. K. <von...@we...> - 2003-04-18 14:18:55
|
Hallo, I tried to fill a dataset with a dataadapter. The selectCommand of the dataadapter calls a stored procedure that returns many records. But only the first record is filled in the dataset. .. FbConnection conn = new FbConnection(Common.Configuration.ConnectionString); conn.Open(); FbDataAdapter custDA = new FbDataAdapter(); custDA.TableMappings.Add("Table",PersonData.PERSONEN_TABLE); FbTransaction txn = conn.BeginTransaction(); custDA.MissingSchemaAction = MissingSchemaAction.AddWithKey; custDA.SelectCommand = new FbCommand("EXECUTE PROCEDURE PERSONS_S", conn, txn); custDA.SelectCommand.CommandType = CommandType.StoredProcedure; PersonData personDS = new PersonData(); custDA.Fill(personDS); txn.Commit(); personDS.AcceptChanges(); ... Wotan von Klass Germany |