Add Table to Exisiting Project

[thefox149]

I am an absolut noob to visual basic I have been a vba programmer now have made the attempt at .net.

I have visual studo express connect to my database and all is fine however now I have created another table but i cannot find where I add or refresh the changes so I can see the table in my project.The only place I can see is to add another datasource but this makes no sense I would have thought the connection the app makes to the database is dynamic and should reflect the changes

any help?

My cat's name is sprinkles
-Ralph Wigam

 

[OrthoDocSoft]

When you say "table", do you mean a flexgrid or datagrid?

Ortho

 

[thefox149]

I am referrring to the datasources. If you make design changes to the dbase they are not reflected in the datasources

My cat's name is sprinkles
-Ralph Wigam

 

[thefox149]

Any help

I am currently undertaking my mcsd.net and the documentation states that datasets are what's known as the "disconnected layer" so running the data config wizard again should update the dataset I am yet to try however it sounds logical I would have thought that an open connection is what would have been used

I suppose my next question is how does sql server handle multiple users accessing the same record access used the whole dbpessimistic/dboptimistic....

My cat's name is sprinkles
-Ralph Wigam

 

[macleod1021]

> I am currently undertaking my mcsd.net

Might wanna get a bit more experience under the belt before wasting money on the tests If you're just starting out, I'd give it a year or so of hands on experience before attempting to get certified.

> I would have thought that an open connection

It is an open connection, however the wizard does the initial schema query. If you were to create the connection at run-time, you could pull the latest schema down with no problem. The listing you see is a design-time helper.

> how does sql server handle multiple users accessing the same record

When you open a connection to the server and perform a query, the SQL server will place a record level lock on the row requested. It will then release the lock when you're done. Because this is disconnected, there's nothing to stop someone else from updating the row that you are about to update. You have to add logic to your program to handle this situation gracefully.

 

[thefox149]

Thanks for the answers. I have been an access vba programmer for a long time however the mcsd.net is ok I get alot of the concepts etc however there is alot of new content which I am con-currently trying to apply with applications and examples that I have created over the years

My cat's name is sprinkles
-Ralph Wigam

 

[thefox149]

This has been driving me nuts.

I have a dataset based from a table which I can use to create the forms for data entry etc however I have had to add a field to the table in the database. I cannot see this amendment in my dataset even when I refresh. any help would be greatly appreciated

My cat's name is sprinkles
-Ralph Wigam

 

[thefox149]

I worked it out I am such a spaz. I had intially set my project to make a copy of the database therefore I was making a change to my db however the project was referring to a copied one in the project folder

My cat's name is sprinkles
-Ralph Wigam