"Keith R" <ASpamfilterAddress@NoMail.org> wrote in message
news:O$LFvt$DHHA.4952@TK2MSFTNGP06.phx.gbl...
> Very new to dotnet, using VB.net express 2005.
>
> I created two tables, starting with only a few fields to get the tables
> started and key fields (foreign key fields, etc.) linked. I went back to
> add a few more fields, and added them just fine to the table definition
> view (allowing nulls for the moment, until I can put some fake data in and
> then supress null data in those fields).
>
> In the database explorer (after saving all) I then click on the show table
> data view, but my extra fields are not there. I've not worked with
> databases before (learning as I go on this simple project) and I haven't
> been able to figure out how to successfully edit my table structure
> without just throwing out my tables and starting from scratch. Don't want
> to do that, because I'll continue to think of new fields I need to add
> throughout the project and can't afford to keep starting from scratch each
> time.
>
> Also, since it is related- once I get my fields added and can add data in
> the existing records, do I need to do anything in my data sources tab to
> make sure I have access to all my fields within my project?
>
> Many thanks,
> Keith
>

"RobinS" <RobinS@NoSpam.yah.none> wrote in message
news:YomdnbHVAfIcxvrYnZ2dnUVZ_vadnZ2d@comcast.com...
> Did you try clicking the Refresh button in Server Explorer?
> I assume you're talking about Server Explorer when you say
> database explorer.
>
> Robin S.
> ---------------------------------------
> "Keith R" <ASpamfilterAddress@NoMail.org> wrote in message
> news:O$LFvt$DHHA.4952@TK2MSFTNGP06.phx.gbl...
>> Very new to dotnet, using VB.net express 2005.
>>
>> I created two tables, starting with only a few fields to get the tables
>> started and key fields (foreign key fields, etc.) linked. I went back to
>> add a few more fields, and added them just fine to the table definition
>> view (allowing nulls for the moment, until I can put some fake data in
>> and then supress null data in those fields).
>>
>> In the database explorer (after saving all) I then click on the show
>> table data view, but my extra fields are not there. I've not worked with
>> databases before (learning as I go on this simple project) and I haven't
>> been able to figure out how to successfully edit my table structure
>> without just throwing out my tables and starting from scratch. Don't want
>> to do that, because I'll continue to think of new fields I need to add
>> throughout the project and can't afford to keep starting from scratch
>> each time.
>>
>> Also, since it is related- once I get my fields added and can add data in
>> the existing records, do I need to do anything in my data sources tab to
>> make sure I have access to all my fields within my project?
>>
>> Many thanks,
>> Keith
>>
>
>

"Keith R" <ASpamfilterAddress@NoMail.org> wrote in message
news:%23zqHjTBEHHA.3668@TK2MSFTNGP06.phx.gbl...
> It is a docked window on the left side, with the title 'database
> explorer'. I'm following an online training video series, and that was how
> they created the project database. I had clicked save all (as well as
> clicking on each level of the database explorer tree and saving) and
> refreshed everywhere I saw it in a right-click menu, to no avail. I
> finally started closing all the main window tabs (including the
> database-related windows), then opened it back up to try to play with it
> one more time... and when I re-opened it, the extra fields were magically
> there. It hadn't asked me to do any extra saves when I was closing, so I'm
> not really sure why the view wouldn't refresh before, but now I have a
> strategy... close all the windows and re-open them :)
>
> Thanks!
> Keith
>
> "RobinS" <RobinS@NoSpam.yah.none> wrote in message
> news:YomdnbHVAfIcxvrYnZ2dnUVZ_vadnZ2d@comcast.com...
>> Did you try clicking the Refresh button in Server Explorer?
>> I assume you're talking about Server Explorer when you say
>> database explorer.
>>
>> Robin S.
>> ---------------------------------------
>> "Keith R" <ASpamfilterAddress@NoMail.org> wrote in message
>> news:O$LFvt$DHHA.4952@TK2MSFTNGP06.phx.gbl...
>>> Very new to dotnet, using VB.net express 2005.
>>>
>>> I created two tables, starting with only a few fields to get the tables
>>> started and key fields (foreign key fields, etc.) linked. I went back to
>>> add a few more fields, and added them just fine to the table definition
>>> view (allowing nulls for the moment, until I can put some fake data in
>>> and then supress null data in those fields).
>>>
>>> In the database explorer (after saving all) I then click on the show
>>> table data view, but my extra fields are not there. I've not worked with
>>> databases before (learning as I go on this simple project) and I haven't
>>> been able to figure out how to successfully edit my table structure
>>> without just throwing out my tables and starting from scratch. Don't
>>> want to do that, because I'll continue to think of new fields I need to
>>> add throughout the project and can't afford to keep starting from
>>> scratch each time.
>>>
>>> Also, since it is related- once I get my fields added and can add data
>>> in the existing records, do I need to do anything in my data sources tab
>>> to make sure I have access to all my fields within my project?
>>>
>>> Many thanks,
>>> Keith
>>>
>>
>>
>
>

"Keith R" <ASpamfilterAddress@NoMail.org> wrote in message
news:O$LFvt$DHHA.4952@TK2MSFTNGP06.phx.gbl...
> Very new to dotnet, using VB.net express 2005.
>
> I created two tables, starting with only a few fields to get the tables
> started and key fields (foreign key fields, etc.) linked. I went back to
> add a few more fields, and added them just fine to the table definition
> view (allowing nulls for the moment, until I can put some fake data in and
> then supress null data in those fields).
>
> In the database explorer (after saving all) I then click on the show table
> data view, but my extra fields are not there. I've not worked with
> databases before (learning as I go on this simple project) and I haven't
> been able to figure out how to successfully edit my table structure
> without just throwing out my tables and starting from scratch. Don't want
> to do that, because I'll continue to think of new fields I need to add
> throughout the project and can't afford to keep starting from scratch each
> time.
>
> Also, since it is related- once I get my fields added and can add data in
> the existing records, do I need to do anything in my data sources tab to
> make sure I have access to all my fields within my project?

>
> Many thanks,
> Keith
>