Hello,
I have a program, running in several places, using SQLEXPRESS as database.
The different places are stand-alone, and not connected to a network.
Regulary, I have to apply changes on certain tables of the database.
In a previous program, written in VB6 with an Access database, I used JRO
through VB6-code to delete the table in the different databases and to copy
the new one.
Is something similar possible with SQLEXPRESS. I would like to be able to
update tables in an SQLEXPRESS database file by deleting them and replace
them with the new table. Is this possible through VB.NET code?
Many thanks and greetings from Brugge (Bruges - Belgium),
Michel 2 1318
Michel,
With normal SQL script you can do that, have by instance a look at the drop
command.
Cor
"Michel Vanderbeke" <mi***************@skynet.beschreef in bericht
news:46***********************@news.skynet.be...
Hello,
I have a program, running in several places, using SQLEXPRESS as database.
The different places are stand-alone, and not connected to a network.
Regulary, I have to apply changes on certain tables of the database.
In a previous program, written in VB6 with an Access database, I used JRO
through VB6-code to delete the table in the different databases and to
copy the new one.
Is something similar possible with SQLEXPRESS. I would like to be able to
update tables in an SQLEXPRESS database file by deleting them and replace
them with the new table. Is this possible through VB.NET code?
Many thanks and greetings from Brugge (Bruges - Belgium),
Michel
hello Michel
You can do this with SQL -DMO objects or with DDL-SQL ( wich suits you the
best )
regards
Michel Posseth
"Michel Vanderbeke" <mi***************@skynet.beschreef in bericht
news:46***********************@news.skynet.be...
Hello,
I have a program, running in several places, using SQLEXPRESS as database.
The different places are stand-alone, and not connected to a network.
Regulary, I have to apply changes on certain tables of the database.
In a previous program, written in VB6 with an Access database, I used JRO
through VB6-code to delete the table in the different databases and to
copy the new one.
Is something similar possible with SQLEXPRESS. I would like to be able to
update tables in an SQLEXPRESS database file by deleting them and replace
them with the new table. Is this possible through VB.NET code?
Many thanks and greetings from Brugge (Bruges - Belgium),
Michel
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: andrewcw |
last post by:
I am trying to use the NorthWind database or anything with SQLEXPRESS on VS
2005 RC. I can see SQLExpress started with the tool SQL Server Configuration
Manager. But when i select DataBase | New...
|
by: Nedu N |
last post by:
Hi Techies,
I am facing problem in copying content of table from a untyped dataset into
to a table inside the typed dataset. I wanted to copy the data into typed
dataset in order to ease the...
|
by: Crash |
last post by:
Windows XP
MS SQLExpress
VS 2003
..NET 1.x SP1 {for Application}
..NET 2.0 {for SQLExpress}
MS Enterprise Library June 2005
This works from a command prompt
osql -E -S localhost\SQLEXPRESS
|
by: Matt Fielder |
last post by:
First off, if this is better posted in another group that qualifies as a
manged group, please let me know.
I currently have an application written in VB.Net using MSDE as the
database. Current...
|
by: koonda |
last post by:
Hi guys,
I am trying to create a web interface in C# using ASP.NET. The database being used is SQL Server. I have some problems loading the tables in the datalist controls. When I run the program...
|
by: Torben Laursen |
last post by:
Hi
I am trying to find find the sqlserver express that is running on my
computer using:
DataTable dtSQLServers = SmoApplication.EnumAvailableSqlServers(false);
It returns one row that holds...
|
by: =?Utf-8?B?bXVzb3NkZXY=?= |
last post by:
Hi,
I wonder if someone could shed some light on this one for me.
I have developed a web app in VS2005 with the built in server. It uses an
sql database, everytihng works.
I need to test it...
|
by: troy_lee |
last post by:
What is the best way of copying all the records from a linked table
into a replica table that is local on my computer? This is for
development work at home where I can not access the main table. Is...
|
by: tshad |
last post by:
Running on VS.net 2005,
I am trying to copy rows from my datatable to another datatable in the same
dataset.
The schema would be identical.
I need to make the table name "forms" as I am...
|
by: DolphinDB |
last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation.
Take...
|
by: isladogs |
last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM).
In this month's session, we are pleased to welcome back...
|
by: isladogs |
last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM).
In this month's session, we are pleased to welcome back...
|
by: Vimpel783 |
last post by:
Hello!
Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
|
by: ArrayDB |
last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
|
by: CloudSolutions |
last post by:
Introduction:
For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
|
by: Defcon1945 |
last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
|
by: af34tf |
last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
|
by: Faith0G |
last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
| |