Testing Ado.net
Fetching all books
ISBN    Author  Title
1111111111      Guillou Arn
2222222222      Padron-McCarthy, Ri     Databasteknik
3333333333      Elmasri, Navathe        Compilers
Insert a new Category, prepared
Category id: 10
Category: Tandpetare

Insert a new Category
Category id: 20
Category: Tandkräm

Testing DataSet
<Categories>
  <Categoryitem>
    <CATEGORY_ID>1</CATEGORY_ID>
    <CATEGORY>Music</CATEGORY>
  </Categoryitem>
  <Categoryitem>
    <CATEGORY_ID>2</CATEGORY_ID>
    <CATEGORY>Books</CATEGORY>
  </Categoryitem>
  <Categoryitem>
    <CATEGORY_ID>3</CATEGORY_ID>
    <CATEGORY>Video</CATEGORY>
  </Categoryitem>
  <Categoryitem>
    <CATEGORY_ID>10</CATEGORY_ID>
    <CATEGORY>Tandpetare</CATEGORY>
  </Categoryitem>
  <Categoryitem>
    <CATEGORY_ID>20</CATEGORY_ID>
    <CATEGORY>Tandkräm</CATEGORY>
  </Categoryitem>
</Categories>
Done. Press enter to exit