I am creating a database which will contain information about book. (title, author, description, edition etc). Is there anyway i can download book data from the web so that i can insert in my database. I want database to have between 500 - 1000 books information. The database is in Sql Server.
You could source data from websites like Amazon.com - they have APIs for this. But, you may not be able to redistribute the data without permission from Amazon. There's nothing stopping you from getting public domain data from a government organisation like the Library of Congress - they probably have it somewhere.
If you are just looking for sample data you can use the pubs db that comes with ms sql server
Most well known book content API's are from Amazon.com and more recent from Google (Amazon's API can often seen been republished on the web):
To see what is allowed with the Amazon API please see:
Some excelent info on other providers can be found here: Code4lib: Using Book Data Providers to Improve Services to Patrons
The Internet Archive offers Open Library bulk exports in a variety of formats (MARC, primarily). If you are looking for records for specific books, you might look at LibraryThing's API.