Jump to content


Photo

Table Data Insertion


  • Please log in to reply
4 replies to this topic

#1 PhilPense

PhilPense

    Active Member

  • Members
  • PipPip
  • 11 posts
  • Gender:Male
  • Location:Washington, DC
  • Interests:Travel, Information Technology

Posted 18 May 2012 - 01:49 PM

Able to enter data in the recently created table. Everything except row1 column 6... invalid value. Don't know how to address this. Looking for troubleshooting guidance

Attached Thumbnails

  • Invalid Value for column 6.jpg


#2 Sikta_26785

Sikta_26785

    Active Member

  • Members
  • PipPipPip
  • 68 posts

Posted 22 May 2012 - 07:25 PM

Boolean data type means that 'true' or 'false' are valid values. YES is not a valid data type for this field. (Note: it could be '0' or '1' in this entry format.)

#3 PhilPense

PhilPense

    Active Member

  • Members
  • PipPip
  • 11 posts
  • Gender:Male
  • Location:Washington, DC
  • Interests:Travel, Information Technology

Posted 24 May 2012 - 01:18 PM

Boolean data type means that 'true' or 'false' are valid values. YES is not a valid data type for this field. (Note: it could be '0' or '1' in this entry format.)



#4 PhilPense

PhilPense

    Active Member

  • Members
  • PipPip
  • 11 posts
  • Gender:Male
  • Location:Washington, DC
  • Interests:Travel, Information Technology

Posted 24 May 2012 - 02:14 PM

Boolean data type means that 'true' or 'false' are valid values. YES is not a valid data type for this field. (Note: it could be '0' or '1' in this entry format.)


Greetings Sikta:

As ususal, you have been helpful with my studies. I recognized the issue just after posting and so I solved this one myself. I have moved on and find another issue. The database has been populated and now I want to drag the table onto the form. The text is not specific on this and I have uploaded an image of my circumstance. My People table has no arrow next to it. The issue is how to get the Objectville form onto the IDE then drag 'people' onto it. Much thanks for your continued support.

Attached Thumbnails

  • Database Driven Controls.jpg


#5 Sikta_26785

Sikta_26785

    Active Member

  • Members
  • PipPipPip
  • 68 posts

Posted 25 May 2012 - 09:52 PM

These are the steps to make it look like it does in the book.

1) Right click Form1.cs in the solutions explorer and choose to "View Designer"
2) Select "People" in the Data Sources explorer
3) Click the dropdown arrow next to "People" and choose "Details" (NOTE: There are many different control types you can select here. Play around with them afterwards.)
4) Click and drag "People" onto the form.

You should now have something that looks like what is in the book. You can move the individual controls around and place the Objectville logo to complete it.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users