I want to force the data reader

Question

Hi.. Ques : I want to force the data reader to return only schema of the data store rather than data?

Jignesh Trivedi · Answer

hi try myReader = cmd.ExecuteReader(CommandBehavior.KeyInfo) 'Retrieve column schema into a DataTable. schemaTable = myReader.GetSchemaTable() also refer http://support.microsoft.com/kb/310108 http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqldatareader.getschematable.aspx hope this help.

Satyapriya Nayak · Answer

Hi Manish PobjDataReader = pobjCommand.ExecuteReader (CommandBehavior.SchemaOnly) Thanks