da.FillSchema help

[rodchar]

hey all,
i'm using the fillowing line:
DataTable dt=null;
da.FillSchema(dt,SchemaType.Source);

well, it's pulling in extra columns from another table. anybody have any
ideas?

thanks,
rodchar

 

[Nicholas Paldino [.NET/C# MVP]]

rodchar,

You are going to have to post a complete example which shows the
problem. It would seem, however, that your command for the data adapter is
returning multiple result sets, which would account for multiple tables
(according to the documentation).

 

[rodchar]

thank you Nicholas, after further digging 2 resultsets were being returned.
rod.