Data Reader Returns only schema of the data

Question

Hello I want to know that how I Return Only the schema of the data store by the data reader rather than data.

MuthuMari M · Answer

Hi use this line. SqlDataReader dr = cmd . ExecuteReader(CommandBehavior.SchemaOnly) DataTable dt = dr.GetSchemaTable(); thanks. If this post is useful then mark it as  Accepted Answer

Anil Kumar · Answer

I hope you would have got solved your problem?

Kunal Vaishya · Answer

Dear Gaurav  Try this DataTable Sdt ; Sdt = IReader.GetSchemaTable();

Anil Kumar · Answer

Try- DataTable schema = reader.GetSchemaTable();