Use for xml auto after query .ie select * from table for xml auto . This will be show data in xml format