changing the database after addition to the project ?
-
hello.. actually the problen is that i have added an msaccess database to my project and have buitl about 10 queries and contains 3 tables in it. now i want to add a new table or modify an existing table in the database and when i modify the tables its not effecting in the data-sources in the project..what is the way to edit the database after adding it to the project without loosing the queries built in the dataset designer.. thans...
-
hello.. actually the problen is that i have added an msaccess database to my project and have buitl about 10 queries and contains 3 tables in it. now i want to add a new table or modify an existing table in the database and when i modify the tables its not effecting in the data-sources in the project..what is the way to edit the database after adding it to the project without loosing the queries built in the dataset designer.. thans...
max.4u Please Please take your time and explain things clearly.
Vuyiswa Maseko, Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers." C#/VB.NET/ASP.NET/SQL7/2000/2005/2008 http://www.vuyiswamaseko.tiyaneProperties.co.za vuyiswa@its.co.za www.ITS.co.za
-
max.4u Please Please take your time and explain things clearly.
Vuyiswa Maseko, Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers." C#/VB.NET/ASP.NET/SQL7/2000/2005/2008 http://www.vuyiswamaseko.tiyaneProperties.co.za vuyiswa@its.co.za www.ITS.co.za
sure.. actually mine is c# project.. and it has database of ms access by name test.mdb test.mdb has a table named user_data it has coloums id,pass. this database is added to the project. then i need to modify the table coloums like adding the new coloums. when i add the new coloums its change is not taking effect in my project...
-
sure.. actually mine is c# project.. and it has database of ms access by name test.mdb test.mdb has a table named user_data it has coloums id,pass. this database is added to the project. then i need to modify the table coloums like adding the new coloums. when i add the new coloums its change is not taking effect in my project...
If i understand you correctly you went to Access Db and Opened it and change or added new columns and when you say it does not reflect in your project what do you mean ? please explain that part.
Vuyiswa Maseko, Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers." C#/VB.NET/ASP.NET/SQL7/2000/2005/2008 http://www.vuyiswamaseko.tiyaneProperties.co.za vuyiswa@its.co.za www.ITS.co.za
-
If i understand you correctly you went to Access Db and Opened it and change or added new columns and when you say it does not reflect in your project what do you mean ? please explain that part.
Vuyiswa Maseko, Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers." C#/VB.NET/ASP.NET/SQL7/2000/2005/2008 http://www.vuyiswamaseko.tiyaneProperties.co.za vuyiswa@its.co.za www.ITS.co.za
exactly .... and does not reflect the changes means that in my project the database in the right side in visual studio is not showing the modified tables i mean the new tows which i have added to the table...
-
exactly .... and does not reflect the changes means that in my project the database in the right side in visual studio is not showing the modified tables i mean the new tows which i have added to the table...
Delete the Connection and recreate it , it should appear. But before you do that try to refresh it first from the Server explorer. i dont use Wizards for my database work.
Vuyiswa Maseko, Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers." C#/VB.NET/ASP.NET/SQL7/2000/2005/2008 http://www.vuyiswamaseko.tiyaneProperties.co.za vuyiswa@its.co.za www.ITS.co.za
-
Delete the Connection and recreate it , it should appear. But before you do that try to refresh it first from the Server explorer. i dont use Wizards for my database work.
Vuyiswa Maseko, Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers." C#/VB.NET/ASP.NET/SQL7/2000/2005/2008 http://www.vuyiswamaseko.tiyaneProperties.co.za vuyiswa@its.co.za www.ITS.co.za
if i recreate a new connection then i am loosing the queries i built in the dataset designer.... is it possible to make it without looosing the queries...?
-
if i recreate a new connection then i am loosing the queries i built in the dataset designer.... is it possible to make it without looosing the queries...?
If the Refresh in the server explorer does not work , unfortunately you will have to loose them.
Vuyiswa Maseko, Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers." C#/VB.NET/ASP.NET/SQL7/2000/2005/2008 http://www.vuyiswamaseko.tiyaneProperties.co.za vuyiswa@its.co.za www.ITS.co.za